Help

Error: Exceeded quota of 30 table queries per script invocation.

Topic Labels: Automations
305 0
cancel
Showing results for 
Search instead for 
Did you mean: 
MarioD
5 - Automation Enthusiast
5 - Automation Enthusiast

I am trying to hava a base or table that keeps track of all of the visible fields in a view, and I want this to be done automatically whenever a fields is added, removed or it's visibility is changing.  We have more than 30 views and more than 30 fields.  I am getting this error, whenever I try to run the following code.  

 

let table = base.getTable("Master Product List");
console.log(table)
let recordId = input.config().triggerId;
let records = await table.selectRecordsAsync();
//let updatedRecord = base.getTable('Master Product List')
let updatedRecord = records.getRecord(recordId);
console.log(updatedRecord)
let viewNames = [];
let views = await table.views;
console.log(views);

for (let view of views) {
  let queryResult = await view.selectRecordsAsync();
  let recordIds = queryResult.recordIds;
  if (recordIds.includes(updatedRecord.id)) {
    viewNames.push(view.name);
  }
}

let newFields = {
  Views: viewNames.join(", "),
};
await table.updateRecordAsync(updatedRecord, newFields);
console.log(viewNames)
 
 
//end of code. 
Is there a better way to accomplish this that does encounter this limitation, and preferably does not rely on api calls or some third party solution?
0 Replies 0