Help

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.

Repeating group is creating an extra row with all selections

Topic Labels: Automations
Solved
Jump to Solution
825 4
cancel
Showing results for 
Search instead for 
Did you mean: 
jillmonterey
6 - Interface Innovator
6 - Interface Innovator

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.