Help

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

Topic Labels: Automations Formulas
Solved
Jump to Solution
694 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!