Skip to main content
Solved

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


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.

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?

 

Best answer by TheTimeSavingCo

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

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

View original
Did this topic help you find an answer to your question?

2 replies

TheTimeSavingCo
Forum|alt.badge.img+18

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

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


  • Author
  • New Participant
  • 1 reply
  • May 20, 2024

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


Reply