Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Repeating group is creating an extra row with all selections

Topic Labels: Automations
Solved
Jump to Solution
300 4
cancel
Showing results for 
Search instead for 
Did you mean: 
jillmonterey
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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

See Solution in Thread

4 Replies 4
ScottWorld
18 - Pluto
18 - Pluto

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

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. 

Try putting a "Run a script" action to delete the form submission:

Screenshot 2024-09-30 at 10.43.37 AM.png

And here's a thread where there's a simple delete record script you can modify for yourself

This is what I wound up doing.