Hello,
I am new to Airtable. I’m trying to create a project where i have different tables with Start date, end date, people.
I want to write a script that will loop through the all tables to check if there is any conflict of assigned date to any person.
Can anyone put me through please.
Below is my script i started.
let table1 = base.getTable(“Project 1”);
let table2 = base.getTable(“Project 2”);
let table3 = base.getTable(“Project 3”);
let Conflict = await input.fileAsync()
if (Conflict) {
record.getCellValue('table1.Start Date') == record.getCellValue('table2.Start Date');
output.text(`Yes`);
} else {
output.text('No');
}