Correct the script for Apps Script

The existing script does not write data into an already created row with a date and with each new report in Telegram, it creates a new row with a date that has already been created by the first report. Reports are sent to the Telegram group by different employees. A screenshot of the table is attached.

The principle of the script: when a message arrives in the group regarding reports, the data from it is transferred to the Google spreadsheet; at the same time, the script determines from the message which tab to send the data to and in which column. If there is data in the cell in the required column and in the row with the already created date, then new data should not be inserted there.

It needs to be fixed so that a new row is not created if a row with the date has already been created. And data should be added to the row with the already created date if the cells are empty.

The script itself:

const TOKEN = "xxxxxxxxxx";

const SPREADSHEET_ID = "xxxxxxxxxx";

/**

* Search for a row with a date or create a new one

*/

function findOrCreateRow(sheet, dateStr) {

const [targetDay, targetMonth] = dateStr.split(".").map(Number);

// Get ALL values from column A

const lastRow = sheet.getLastRow();

if (lastRow > 0) {

const displayValues = sheet.getRange(1, 1, lastRow, 1).getDisplayValues();

for (let i = 0; i < displayValues.length; i++) {

const cellText = displayValues[i][0];

if (!cellText) continue;

const parts = cellText.split(".");

if (parts.length < 2) continue;

const day = parseInt(parts[0]);

const month = parseInt(parts[1]);

if (day === targetDay && month === targetMonth) {

Logger.log("Row found: " + (i + 1));

return i + 1;

}

}

}

// If the date is not found — create a new one

const currentYear = new Date().getFullYear();

const newDate = new Date(currentYear, targetMonth - 1, targetDay);

const newRow = sheet.getLastRow() + 1; // GET CURRENT lastRow

sheet.getRange(newRow, 1)

.setValue(newDate)

.setNumberFormat("dd.MM.yyyy");

SpreadsheetApp.flush();

Logger.log("New row created: " + newRow);

return newRow;

}