Problem on my Script Suddenly

[Marc_Justin_Rai]

I suddenly get an error while executing my script. “There was an unexpected error while executing your script”. It doesn’t say which one causes it. I only change my table name and change immediately the value on the gsctable variable.

let gsctable = base.getTable("CBD B2B DE 5");
let query = await gsctable.selectRecordsAsync();
let today = new Date();
let year = new Intl.DateTimeFormat('en', { year: 'numeric' }).format(today);
let month = new Intl.DateTimeFormat('en', { month: '2-digit' }).format(today);
let day = new Intl.DateTimeFormat('en', { day: '2-digit' }).format(today);
let todate = `${year}-${month}-${day}`;

let lw = new Date(today.getFullYear(), today.getMonth(),today.getDate()-7);
let ly = new Intl.DateTimeFormat('en', { year: 'numeric' }).format(lw);
let lm = new Intl.DateTimeFormat('en', { month: '2-digit' }).format(lw);
let ld = new Intl.DateTimeFormat('en', { day: '2-digit' }).format(lw);
let lastweek = `${ly}-${lm}-${ld}`;

for(let dates of query.records){
    let todaycell = dates.getCellValue('EndDate'); //End Date
    let lastweekcell = dates.getCellValue('StartDate');//Start Date
    if(todate != todaycell){
        await gsctable.updateRecordAsync(dates,{
         "Update":todate
        })
    }
}

[Dominik_Bosnjak]

Marc_Justin_Rait:

I only change my table name and change immediately the value on the gsctable variable.

Well, that makes your first step in debugging this easy enough - does changing back the table name and its variable reference restore the original behavior?

If not, how about restoring your base from a snapshot and seeing if the issue is present?
If it isn’t, try changing the snapshot’s table name to what you did the first time - see if you can replicate the problem.
If not, try changing it to something else entirely, etc.

[Jack_Evans]

We are having the same problem at present with no changes implemented from a user perspective. It looks like an airtable issue but at present i’m awaiting feedback from the helpdesk.

[Claire_Conza]

I’m having the same issue. I even tried just a simple script

console.log(Hello, ${base.name}!);

and it failed with this message

ERROR

There was an unexpected error while executing your script.

Any ideas?

Thanks

Claire

[Costantini_s_r_]

same here, my base is stuck at automation “in progress” level

[kuovonne]

Looks like an Airtable issue.