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.

Splitting records with 2 or more multiple-select options into individual records in a new table

Topic Labels: Automations Formulas
Solved
Jump to Solution
860 2
cancel
Showing results for 
Search instead for 
Did you mean: 
electricli
4 - Data Explorer
4 - Data Explorer

I have a table of projects. Associated with each project is multiple teams and multiple quarters. Both the quarters and teams fields are sourced from linked records.

electricli_1-1715365539331.png

I would like automation (or script) to create related projects in another table, one per multiselect field combination. I've tried creating a script with ChatGPT, but no luck. I also so some other solutions in the community that were similar, but not quite the same as my situation. Any suggestions?

electricli_2-1715365568321.png

 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

What issues did you face when attempting to use repeating groups for this?

https://support.airtable.com/docs/repeating-groups-of-automation-actions

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

What issues did you face when attempting to use repeating groups for this?

https://support.airtable.com/docs/repeating-groups-of-automation-actions

electricli
4 - Data Explorer
4 - Data Explorer

The repeating groups helped, but I can only apply it to one field (I can't nest them). For now, this will work. Thanks!