let table = base.getTable('Tasks');
let query = await table.selectRecordsAsync()
// get the cell values of the table
// looping through records
for (let record of query.records ) {
//start date
let startDate = record.getCellValue('Start Date')
//end date
let endDate = record.getCellValueAsString('End Date')
let available = record.getCellValue ('Next Workday')
if (startDate == endDate){
}
}
I’ve edited your post for readability. When you enter a code block into a forum post, please precede it with a separate line of three backticks and follow it with a separate line of three backticks to make it easier to read.
You can also use the “preformatted text” tool in the editor (</>
) to add backticks around text.
See this post to find the backtick on your keyboard.
Note: Backticks (`) are not single quotes (’).
1 Like
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.