// Correctly retrieve the record ID from the automation's input configuration
let recordId = input.config().recordId;
if (!recordId) {
throw new Error('Record ID is undefined. Make sure the input variable is correctly configured.');
}
let bookingsTable = base.getTable("Bookings");
let episodesTable = base.getTable("Episodes");
let mixElementsTable = base.getTable("Mix Elements");
// Retrieve the trigger record
let record = await bookingsTable.selectRecordAsync(recordId);
let numberOfDuplicates = record.getCellValue("Duplicates") ? parseInt(record.getCellValue("Duplicates"), 10) : 1;
numberOfDuplicates = Math.max(1, numberOfDuplicates); // Ensure at least one duplicate
console.log(`Creating ${numberOfDuplicates} duplicates for record ID ${recordId}`);
async function findNextRecordId(tableName, name) {
let table = base.getTable(tableName);
let records = await table.selectRecordsAsync();
let match = name.match(/(\d+)/);
if (match) {
let num = parseInt(match[1], 10);
let numIndex = name.indexOf(match[1]);
let newNamePrefix = name.substring(0, numIndex);
let newNameSuffix = name.substring(numIndex + match[1].length);
let incrementedNum = num + 1;
let searchPattern = newNamePrefix + incrementedNum + newNameSuffix;
console.log(`Searching for "${searchPattern}" in ${tableName}`);
let found = records.records.find(r => r.name.includes(incrementedNum.toString()) && r.name.startsWith(newNamePrefix) && r.name.endsWith(newNameSuffix));
if (found) {
console.log(`Found matching record "${found.name}" with ID ${found.id} in ${tableName}`);
return [found.id]; // Ensure this is returned as an array
} else {
console.log(`No matching record found for "${searchPattern}" in ${tableName}`);
return null;
}
} else {
console.log(`No numeric part found in "${name}" to increment`);
return null;
}
}
for (let i = 0; i < numberOfDuplicates; i++) {
let episodeName = record.getCellValueAsString("Episode");
let elementName = record.getCellValueAsString("Element");
let newEpisodeId = await findNextRecordId("Episodes", episodeName);
let newElementId = await findNextRecordId("Mix Elements", elementName);
console.log(`Attempting to create record with new Episode ID: ${JSON.stringify(newEpisodeId)} and Element ID: ${JSON.stringify(newElementId)}`);
if (newEpisodeId && newElementId) {
try {
await bookingsTable.createRecordAsync({
"Episode": newEpisodeId, // "Episode" field expects an array of record IDs
"Element": newElementId, // "Element" field expects an array of record IDs
// Include other fields as needed from the original record, ensuring to adjust for correct data types
});
console.log('Record created successfully');
} catch (error) {
console.error(`Error creating record: ${error}`);
}
} else {
console.error('Could not find matching Episode or Element for increment');
}
}
