Although I am not new to Airtable, scripting/ coding is not something I am familiar with and I would like to ask if anyone can help with a script I set up below.
Now that Airtable allows for sync bases, I finally have to opportunity to combine multiple bases in one and look up all records from one source instead of having to click at a million things.
That said, since I have 8 active bases (the reason being that we are using Airtable to in order to Telemarket/ Telefundraise) I also have 8 synced tables - with multiple columns each - that are still kind of tedious to go through.
I found this script from one of the Airtbale members that allows for a lookup function
Now my question is:
Is there a way for the if statement to update multiple records and if so how would that script look like?
e.g if “Name” === the lookupValue then
let returnValue = rangeRecord.getCellValue(“Attempt Counts”);
let returnValue = rangeRecord.getCellValue(“Column 1”); etc.
and update the main table.
-Also if that is too tricky, then I am also fine that if Name = lookupvalue,
update all other columns that match.
since all I am trying to do is to merge 8 tables in one therefore all columns are identical.
As I said I have zero knowledge of scripting so any help would be greatly appreciated. Thank you in advance!