I'm trying to update a field name in a table using the script below, but getting this error: "Cannot update field name from scripting automation at main on line 22". Has anyone else run into this problem?
let table = base.getTable("tblxxxxxx");
let field1 = table.getField("fldrxxxxx");
let today =newDate();
let quarter =Math.floor((today.getMonth()+3)/3);// Get the current quarter
let year = today.getFullYear();
// Calculate the prior quarter
let priorQuarter = quarter -1;
let priorYear = year;
// Calculate the date for the prior quarter's last day
let priorQuarterLastDay =newDate(priorYear, priorQuarter *3,0);
let priorQuarterDate = priorQuarterLastDay.toLocaleDateString();
Shouldn't that be mentioned in the API documentation even within 'Automations'?
Is there any future roadmap to allow this? I'd request as a future update as it would be nice to make the field options flexible depending on what is happening on other tables and clean out any clutter that would just confuse the data.