Is it possible to use the contents of one field (number) to populate another? (spreadsheet)

Say if I wanted to have someone enter a "number of locations" in a number box, and they entered 25, and that would automatically tell the spreadsheet widget that i needed to have 25 rows be added.  Is that something one can do? 

It doesn't HAVE to be the spreadsheet widget, it could be configurable list, or something similar. 

Basically what I'm aiming at is to collect a certain amount of information "per location" and have the table built based on how many locations the form filler specifies.  

Unfortunately, there's no widget that automatically adds additional entry based on numbers. You'll need to interact with the widget, that means that you will need to click the button add rows, fields etc..

What you can do is create a field and show and hide it based on the numbers inputted by the user.

Kindly check my sample form here https://form.jotform.com/91047808179970 and see if that works for you.

Looking forward for your response.