Hi! I have a table called “Initiatives” - each “Initiative” has a multi-select for 50 states. I would like to generate a new row in a table called “Tasks” for each state selected for an Initiative.
Example:
INITIATIVES TABLE
Row 1: Initiative A | NY...
Thanks @ScottWorld! I figured it out using your suggestion of automations in combination with the suggestions from this post here: Creating multiple records based on a range of numbers
Thanks so much
@ScottWorld Sorry, I’m not sure I understand. I’m trying to create one Initiative record, select let’s say 30 States, and result in one Task for each Initiative:State (30 tasks in total).
The way I have it set up now, I’d have to create an Initiative...
Thanks @ScottWorld! Is there a way to make the data entry part a bit easier? Manually selecting 50 linked states in the Airtable UI is a touch slow - ideally would love to “select all” to create a task for each.
