Help

How to update multiple records from search block with script

Topic Labels: Automations
806 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sannit_Vartak
5 - Automation Enthusiast
5 - Automation Enthusiast

 

Sannit_Vartak_0-1700494418697.png

 

 

let table = base.getTable("Cashflow Grid (Sales Pipeline)");
let inputConfig = input.config();
let record = inputConfig.record;
let mmyy = inputConfig.mmyy;
let i = 0;

const table2 = base.getTable("Cashinflows")
const fieldName = "Name"
const queryResult = await table2.selectRecordsAsync({fields: ["Name", "Record_ID"]})
const ids = queryResult.records.filter(record => (
  record.getCellValueAsString(fieldName) == mmyy
))
console.log(ids[0].id);
output.set('Cashinflows_Record_ID', ids[0].id);

let id1 = ids[0].id;
console.log(id1);

for (let records of record) {

let recordId = record[i];
console.log(recordId);
await table.updateRecordAsync(recordId, {'Cashinflows x 1st AZ': [{id: id1}],})
i = i+1;
}
console.log(record);

 

 

 

 

2 Replies 2

Hey @Sannit_Vartak

As soon as your action will be to run the script I would recommend to update the script so it will find the records by it self (you could use a specific view for that) and then add a loop in your script to run for every record. 

Combining Find action with Script running as you added it on your screenshot can't run. 

Yours sincerely,

Dimitris Goudis

kuovonne
18 - Pluto
18 - Pluto

Can you say a little more about what you want to accomplish with the script, where the script came from, and what is not working the way you want?

There are a few things about this script that make it hard to read. For example, this line:

for (let records of record) {

Normally in a loop of this sort, you would name your variables so that the singular variable refers to a single item and the plural variable is an array of items. However, in this case your variable with a singular name refers to an array while the plural variable refers to a single element of that array. Yet you are not even using the records variable in your code after it is created.