Help

Checking for conflicts

Topic Labels: Extensions
604 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Adeyeun_Imoleay
4 - Data Explorer
4 - Data Explorer

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');

}

0 Replies 0