How to pause script and then repeat automatically?

It sounds to me like you’re looking for automation.

The new automation beta can trigger a JavaScript based on a new record in view. That would definitely help you out. You can contact support@airtable.com about getting involved in that beta program.

Even better, you can automate tasks on a schedule with Integromat, which is my preferred method.

Hi @matt_stewart - I had exactly the same issue - tasks and dates. It can be done. Here’s the script I used. On its own, it won’t mean much as it works with a specific base set up, but hopefully you can get a sense of what it is doing and copy the structure:

let tasksTbl = base.getTable('Tasks');

output.text('Updating project dates - please wait');
let status = 1;
while (status > 0) {
    
    status = 0
    let tasks = await tasksTbl.selectRecordsAsync();
    for (let record of tasks.records) {
        let actualEndDate = record.getCellValue('Actual end date');
        let actualEndDateCopy = record.getCellValue('Actual end date copy');      
        if (actualEndDate != actualEndDateCopy) {
            status ++;
        }
    }
    // console.log(status)  
    for (let record of tasks.records) {
        let actualEndDate = record.getCellValue('Actual end date');
        let actualEndDateCopy = record.getCellValue('Actual end date copy');
        if(actualEndDate != actualEndDateCopy) {
            await tasksTbl.updateRecordAsync(record, {
                "Actual end date copy": actualEndDate
            })
        }
    }  
}

output.text('Project dates updated');

There’s a couple of trick in this.

• Use a while loop and set some check that determines if it should run again
• Query the records inside the loop so that you get the latest records based on updates from previous iterations:

while (status > 0) {
    
    status = 0
    let tasks = await tasksTbl.selectRecordsAsync();

note that the selectRecordsAsync is inside the while loop.

The structure I used was:

• Set the checker (status) = 1 to ensure it runs once
• Reset the checker to 0
• query the records and find out if the script has anything to do and set the checker to something other than zero (in my case I was counting how many dates I would need to amend)
• If it does, then do the thing

At this point because my checker is non-zero, it will run again, setting the checker back to zero, getting the records again and so on.

If at any point the line status++ returns zero, then there’s nothing to do and the while loop will finish.

I can see some improvements in the script, so maybe don’t take it verbatim, but hopefully this helps some. You can also use a do-while loop which has at least one run built into it.
More here on that

Integromat is yet another paid service, so id like to avoid that. Its one of my qualms with Airtable that so many things rely on these paid 3rd party services as opposed to enhancing the internal paid features of my pro or enterprise plan.

Automation beta I wasn’t aware of so ill have to contact and see how that works.

But to clarify, I don’t want to trigger this automatically necessarily. I just want the script to repeat until there is nothing left to update. The first time it runs and stops, its because there is nothing left to update from the moment the script started. But there IS now new tasks/dates to update as a result of the last script run.

So essentially once I press the run button, I just want it to repeat until it runs once with zero tasks updated.

Hi @matt_stewart - I had exactly the same issue - tasks and dates. It can be done. Here’s the script I used. On its own, it won’t mean much as it works with a specific base set up, but hopefully you can get a sense of what it is doing and copy the structure:

let tasksTbl = base.getTable('Tasks');

output.text('Updating project dates - please wait');
let status = 1;
while (status > 0) {
    
    status = 0
    let tasks = await tasksTbl.selectRecordsAsync();
    for (let record of tasks.records) {
        let actualEndDate = record.getCellValue('Actual end date');
        let actualEndDateCopy = record.getCellValue('Actual end date copy');      
        if (actualEndDate != actualEndDateCopy) {
            status ++;
        }
    }
    // console.log(status)  
    for (let record of tasks.records) {
        let actualEndDate = record.getCellValue('Actual end date');
        let actualEndDateCopy = record.getCellValue('Actual end date copy');
        if(actualEndDate != actualEndDateCopy) {
            await tasksTbl.updateRecordAsync(record, {
                "Actual end date copy": actualEndDate
            })
        }
    }  
}

output.text('Project dates updated');

There’s a couple of trick in this.

• Use a while loop and set some check that determines if it should run again
• Query the records inside the loop so that you get the latest records based on updates from previous iterations:

while (status > 0) {
    
    status = 0
    let tasks = await tasksTbl.selectRecordsAsync();

note that the selectRecordsAsync is inside the while loop.

The structure I used was:

• Set the checker (status) = 1 to ensure it runs once
• Reset the checker to 0
• query the records and find out if the script has anything to do and set the checker to something other than zero (in my case I was counting how many dates I would need to amend)
• If it does, then do the thing

At this point because my checker is non-zero, it will run again, setting the checker back to zero, getting the records again and so on.

If at any point the line status++ returns zero, then there’s nothing to do and the while loop will finish.

I can see some improvements in the script, so maybe don’t take it verbatim, but hopefully this helps some. You can also use a do-while loop which has at least one run built into it.
More here on that

Integromat is yet another paid service, so id like to avoid that. Its one of my qualms with Airtable that so many things rely on these paid 3rd party services as opposed to enhancing the internal paid features of my pro or enterprise plan.

Automation beta I wasn’t aware of so ill have to contact and see how that works.

But to clarify, I don’t want to trigger this automatically necessarily. I just want the script to repeat until there is nothing left to update. The first time it runs and stops, its because there is nothing left to update from the moment the script started. But there IS now new tasks/dates to update as a result of the last script run.

So essentially once I press the run button, I just want it to repeat until it runs once with zero tasks updated.

Your solution work like a charm. I use a similar method that uses boolean values

let shouldContinue = true
while (shouldContinue == true) {
     ...
    actualEndDate != actualEndDateCopy ? shouldContinue = true : shouldContinue = false
}