Apr 05, 2023 07:46 AM
Is it possible to use an Automation and a looping function to create the scenario in the subject line?
I have a form to create a new record in table A, one of the fields is a manually selected number (X) from 1-20 (single select). Can an Automation generate X number of linked records in table B? If so, how is this configured please?
Apr 05, 2023 11:06 PM
Yeap this is possible. I think I would:
1. Create a formula field that would, based on the single select field, show the numbers within it (just hardcode it)
- So if '5' was selected, it would show '1, 2, 3, 4, 5'
- If '12' was selected, it would show '1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12'
2. Create another single select field
3. Create an automation that would paste the value from the field in step 1 into the field from step 2
4. The same automation would have a repeating group step that would utilize the updated field from step 3 and would have a Create Record action in it
This would do what you're looking for
Apr 06, 2023 04:53 AM
Thanks for your help Adam, I'll get to work on following your solution