Hey can someone tell me why I keep getting a error I tried so many different ways that I know but i seem to can't figure It out😩
let table = base.getTable("PS5"); // Replace with your table name
let query = await table.selectRecordsAsync();
let ticketsField = "Tickets"; // The field that contains the number of tickets
// Collect the records that need to be duplicated
let recordsToDuplicate = [];
for (let record of query.records) {
let numTickets = record.getCellValue(ticketsField);
// If Tickets field is greater than 1, add it to the list to be duplicated
if (numTickets && numTickets > 1) {
recordsToDuplicate.push(record);
}
}
// Now we loop through the recordsToDuplicate list and create the new records
for (let record of recordsToDuplicate) {
let numTickets = record.getCellValue(ticketsField);
// Create the specified number of new records (minus 1 since the original record remains)
for (let i = 0; i < numTickets - 1; i++) { // Subtract 1 to avoid duplicating the original record
let newRecordData = {};
// Loop through all fields and copy values to the new record (excluding the Tickets field)
for (let field of table.fields) {
if (field.name !== ticketsField) {
newRecordData[field.name] = record.getCellValue(field.name);
}
}
// Create the new record
await table.createRecordAsync(newRecordData);
}
}
console.log("New records created successfully!");
