Thank you for your solution, It’s been a while since I’ve written much code (and never for airtable), so I really appreciate your alternative solution. I was able to implement your solution fairly quickly and it seems to be working really well.
I had a little trouble with step 2. I set up an automation to trigger ‘when record updated’ while watching field 2a, but it would only run one time. Instead, I set up an automation to trigger when ‘record matches conditions’ where the condition is ‘2a is not empty’. Now it runs through each step until there is no value in 2a.
For anyone else looking to do this, here’s how I implemented Kuovonne’s solution:
Initial Form Submission & Formula Cells
- Trigger: When a Form is Submitted
- Action: Update Record > Copy the Options field to Stringify
- Results: Creates a single line text field with the values of the multi select field
IF( FIND(",", Stringify),
Result: Populates Field 2a with the ‘first’ choice in Stringify. -1 removes the comma.
Note: Kuovonne, Thank you for this formula too. I found it in one of your old solutions elsewhere in the community.
Result: Populates Field 2b with the remaining options. -1 removes the comma from the text. If there are no strings left (indicated by no commas), it sets Field 2b to a null value ("").
- Trigger: When a record matches conditions > Field2a is not empty
- Action: Create Record with all the required fields Name, Date, and Options.
Make Sure to set Stringify to the contents of Field 2b.
- Result: Field 2a & Field 2b in the new record will be different because of the new values in Stringify. Since Field 2a is not empty, the automation will run again, and again until the Field 2a is empty.
Here are the results: (Checked records were automatically created)
I didn’t end up implementing a scripting automation to delete the original record. My friend wants to hold onto them as ‘receipts’ for the original form submissions, so I will be moving the auto-generated results to a different table.