Help

Create multiple linked records based on a number (single select) submitted in a form

Topic Labels: Automations
615 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Hairtable
6 - Interface Innovator
6 - Interface Innovator

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?

2 Replies 2

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

Hairtable
6 - Interface Innovator
6 - Interface Innovator

Thanks for your help Adam, I'll get to work on following your solution