Below is the script that I started. Any help will be appreciated.
//script to conditionally update single select field in Airtable base
//script to conditionally update single select field to Past seervice Check
//when a new record is created for the same location
//Get the input vatiable from the trigger
//const recordId = input.config().recordId;
let inputConfig = input.config();
let RecordID = inputConfig.RecordID;
console.log(RecordID);
//Get the record information from the Table View
let table = base.getTable(“Maintenance Schedule”);
let view = table.getView(“All Upcoming Service Check”);
let QueryResult = await view.selectRecordsAsync({
fields: [“Maintenance Schedule”, “Location”,“Last Checked Date”],
sorts: [
// sort by “Maintenance Schedule” in ascending order
{field: “Maintenance Schedule”},
// then by “Location” in descending order.
{field: “Location”, direction: “desc”},
// then by “Location” in descending order.
{field: “Last Checked Date”, direction: “desc”},
]
});
//console.log(record.getCellValue(“Maintenance Schedule”));
let NewRecord = QueryResult.getRecord(${inputConfig.RecordID});
//let location = QueryResult.getRecord(table.fields.name);
console.log(NewRecord);
// Identify Records with identical Locations fields
// loop through all of the records
let DupsRecords = QueryResult.records.filter((NewRecord)=> {
return QueryResult.records.find((potentialDuplicate)=> {
//compare record to potential duplicate
return NewRecord.getCellValue(“Maintenance Schedule”) ===
potentialDuplicate.getCellValue(“Maintenance Schedule”)
&& NewRecord.id !== potentialDuplicate.id;
})
});
console.log(DupsRecords);
the script works up to this point. I am not sure how to finish it
