
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 10, 2023 03:38 PM
I am trying to create a script to overcome the issue with updating multiple records after a "Find Records" search that yields multiple results.
Automation Trigger: Record from "Packing List" table gets updated to Shipped
Desired Actions:
- Use "Find Records" to search for items on the Packing list that were Available and mark them as Shipped (Some items may be on backorder so I want those to remain as is)
- This search returns a list of the 2 items (in my example) with Available as their status.
- Update the status cell to Shipped.
I am not familiar with scripting so any help on writing this will be appreciated! I know I could complete these with Integromat (Make) but I'd rather keep it local to AirTable and less complicated.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 10, 2023 04:55 PM - edited ‎Aug 10, 2023 04:56 PM
You don't need to use a script. Just use a repeating series action and loop through the found records and update them.
If your "find actions" step finds more than 100 records, then you would need to use a script or use Make.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 10, 2023 04:28 PM
What table and field setup do you have for this?
If there are Packing lists and Item lists, and Item is linked table with Packing lists, then when Packing lists is Shipped, Item can also be shown as Shipped in the Lookup field.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 10, 2023 04:55 PM - edited ‎Aug 10, 2023 04:56 PM
You don't need to use a script. Just use a repeating series action and loop through the found records and update them.
If your "find actions" step finds more than 100 records, then you would need to use a script or use Make.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 11, 2023 01:28 PM
Thanks that worked perfectly! (I had to remove my "If Status is Shipped" condition and added the "shipped" condition to the "Find Records" action since you can't do the repeating series within a conditional logic, but it worked after that.)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 11, 2023 01:29 PM
Thanks for the feedback, In some cases that would work, but I wanted some items to remain listed as "backordered"
