- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 05, 2023 10:38 AM
I am working on a massive update to my table 250+ records. Each record has a "terpene profile" field that can contain anywhere from 1-9 terpenes, each with their own associated "effect" , "flavor and aroma profile" and "helps with" fields that all need their associated selectable added to their already existing fields. I know that my best bet is to run a script, but I am not very good at writing scripts yet. Any ideas on a framework for how I might format a script like this?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 05, 2023 10:57 AM
Hi @William_Sweet,
You can use the Batch Update extension by Airtable to quickly update records contained within a view. I would create a temporary view, filter it based on something existing in your data to select the records you want to update, then update records in this view using the "Add/remove multiple choices" action of the Batch Update extension.
Another less fun by possibly bearable option is to utilize the keyboard only by beginning to type the multi-select value, then hitting Enter once it appears, and moving with the arrow keys.
Hope that helps!
-Stephen
-Stephen