Hi Airtable script gurus! I need help.
I am working off of a code that searches for key words and returns results. The code works when var “districtRecord” is an input. However, I need to run the code on 10k+ records, so using the input would take fo...
Not sure why I keep getting an error message when I try to automate this script:
I just need the first 5 digits of the Project code pasted into the 5 digit (linked) column. If it doesn’t already exist, it needs to create a new record.
Is there a way to import a csv, and using an ID var replace certain cell values based on the incoming data?
For example, the base has 100 records, all with a unique identifier. If I upload a csv of the same data set, with updates fields, can i replac...
Thanks for the tip! Your assumptions are correct. I would like it to run through each record, using the search term within that record.
I got the code to work, running through one record at a time. Thanks!
let districtTable = base.getTabl...
Thanks, I have corrected that. I no longer get an error message, it completes the RUN, but still doesn’t work (all the results field cells are still empty).
Here is the updated code:
let districtTable = base.getTable(“Districts(Educat...
So I played with it some more and got it to write in the 5 digit code value. ( added the output.text to ensure pulling the first 5 digits in a string)
However, it only does it for the first record. How can I fix it to run through all records?