Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 29, 2024 10:11 AM
In the Change Request form I've created, users can enter information about a change request -- item, change type, notes, screenshots, etc -- and then they can use a multiple select dropdown to choose up to four Regions where the changes should apply.
I'm using a Repeating group to cycle through the Regions input to create a separate record for each Region. 4 Regions chosen, 4 rows, 3 Regions chosen, 3 rows, etc. Beautiful! The trouble is, it also creates a single row with ALL 4 or ALL 3 regions etc on it. How do I stop that?
Solved! Go to Solution.
Sep 29, 2024 10:32 AM
You can’t prevent that, because a form submission always creates a new record.
You may want to create your form in a different table, and then loop through the multi-select field to create records in the ACTUAL table where you want the records to appear.
— ScottWorld, Expert Airtable Consultant
Sep 29, 2024 10:32 AM
You can’t prevent that, because a form submission always creates a new record.
You may want to create your form in a different table, and then loop through the multi-select field to create records in the ACTUAL table where you want the records to appear.
— ScottWorld, Expert Airtable Consultant
Sep 29, 2024 11:40 AM
Bleah, I feared this. I also had the idea of the pass-through table where I collect junk rows. I don't get that junk row when my trigger is When-Record-Is-Created or When-Record-Matches-Conditions -- but in either of those cases, I get an infinite loop.
Sep 29, 2024 07:44 PM
Try putting a "Run a script" action to delete the form submission:
And here's a thread where there's a simple delete record script you can modify for yourself
Oct 02, 2024 10:43 AM
This is what I wound up doing.