The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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.
Help?
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...
Hi Jeremy,
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...
@Jeremy_Oglesby
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?
(Or -...