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

[Hairtable]

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?

[TheTimeSavingCo]

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]

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