Anyway to make script wait to next record is updated?

I tried a few things like putting a for-loop inside a for-loop

but now it seems my code never breaks out of the inner for-loop which I’m not sure why.

let luPlanRecords = await prodView.selectRecordsAsync();

console.log(luPlanRecords.records)

for(i = 0; i < luPlanRecords.records.length; i++){
    
    console.log('el1',i)

    let newUpd = await prodView.selectRecordsAsync();
    
    for(let record of newUpd.records){
        let startDate = record.getCellValue(prodStartDate);
        let depDate = record.getCellValue(prevFinishDate)

        console.log('el2',record)

        if(startDate !== depDate && depDate !== null ){
    
        
         await prodTable.updateRecordAsync(record, 
            {'start (vs2)': new Date(depDate)});
        }
    }
    
}

but added a break
now it runs through the code as intended but it still does not update my startDate with my depDate except for the first record

let luPlanRecords = await prodView.selectRecordsAsync();

console.log(luPlanRecords.records)

for(i = 0; i < luPlanRecords.records.length; i++){
    
    console.log('el1',i)

    let newUpd = await prodView.selectRecordsAsync();
    
    

    for(let record of newUpd.records){
        let startDate = record.getCellValue(prodStartDate);
        let depDate = record.getCellValue(prevFinishDate)

        console.log('el2',record)

        if(startDate !== depDate && depDate !== null ){
    
        
         await prodTable.updateRecordAsync(record, 
            {'start (vs2)': new Date(depDate)});
            break
        }
break
    }
    
}

Anyone who know how best to deal with this problem?
I assume it has to do with the lookup delay.

You need to do a fresh read/select of the records after each update to get the new values in the lookups and the formulas.

If a fresh read doesn’t do the trick by itself, you may also need to wait until the formula field and lookups have recalculated. Just because the update request is done doesn’t mean all the calculations are done.

Try the setTimeout function described in this thread. Contrary to the post title, setTimeout does work.

isn’t this the fresh read?

Ah. I was just looking at your code in your first post.

The code in you second post is more than I can really picture on my phone, so I can’t comment on it now.

Been playing around with the setTimeout - however I can’t get it to timeout, am I doing something wrong?

let luPlanRecords = await prodView.selectRecordsAsync();

console.log(luPlanRecords.records)

for(i = 0; i < luPlanRecords.records.length; i++){
    
    setTimeout(console.log('waiting'),4000);
    
    let newUpd = await prodView.selectRecordsAsync()


    for(let record of newUpd.records){
        let startDate = record.getCellValue(prodStartDate);
        let depDate = record.getCellValue(prevFinishDate)

        console.log('el2',record)

        if(startDate !== depDate && depDate !== null ){
    
        
         await prodTable.updateRecordAsync(record, 
            {'start (vs2)': new Date(depDate)});
            setTimeout(4000)
            break
        }

       break
                
    }

Setting a timeout, will that have some implication if a calculation for whatever reason is slow like internet connection etc…?

let luPlanRecords = await prodView.selectRecordsAsync();

console.log(luPlanRecords.records)

for(i = 0; i < luPlanRecords.records.length; i++){
    
    setTimeout(console.log('waiting'),4000);
    
    let newUpd = await prodView.selectRecordsAsync()


    for(let record of newUpd.records){
        let startDate = record.getCellValue(prodStartDate);
        let depDate = record.getCellValue(prevFinishDate)

        console.log('el2',record)

        if(startDate !== depDate && depDate !== null ){
    
        
         await prodTable.updateRecordAsync(record, 
            {'start (vs2)': new Date(depDate)});
            setTimeout(4000)
            break
        }

       break
                
    }

You need to create a new function for setTimeout that returns a promise, then, when you want a pause, call the function and await the result. See the example function and the example call by OpenSide in the second post in the topic.

I’m not sure why your code doesn’t break out of the inner for-loop. It’s hard to tell without knowing any of the values or how they are calculated.

Have you checked the comments/history for the records in question. Do they show any changes?

Here is another idea that does away with the inner for loop. For each record,

1. do a fresh read of the data
2. get the next record by id using the getRecord function on the query results. This will eliminate the inner for loop.
3. update the record with the values you want
4. pause for a second or so for Airtable to update its formula fields and lookups (you may need to play around with this. Some formulas & lookups recalculate very quickly and some take longer depending on how complex they are)
5. continue to the next record

Depending on how your tasks and dependencies are linked, you might need to have a separate pass through the records to identify the order to process the records.

Thank you @kuovonne

That worked to get my setTimeout sorted - I was not paying attention and still trying to wrap my head around JS.

Thank you @Jeremy_Oglesby and thank you for the advise - I’ll try to keep my queries out of my loops, its just so tempting… :grimacing:

For some reason my brain have been fixating on working with the look up that I completely blocked out better ways.
Basically I just want the calculated end-date of the above record passed in as a start date in the below record.
It’s a small script for the Gaant chart block. Instead of using dependencies I just want to quickly stack a bunch of records. Put a startDate in the first record click a button and then have the script to calculate all the other start and end dates based upon a few different parameters.

As you point out I assume I can just save the endDate Value outside the loop and use it in the next iteration, or use part of the other code you helped me with the other day and grab the endDate directly from the record below.
These ways might also be more desirable as it takes out the need to use dependencies which was just one extra step to get the look up to work.