- kpriviteraAsked on March 25, 2016 at 10:59 AM
I am creating 300 forms in a folder on Jotform by using the cloning feature and just changing the title for each. Each one has 16 drop down fields. All 16 maximums are the same for each unique form based on the form title field. I need to be able to have it set the 16 maximum number for each based on information in an excel spreadsheet. Also, each location has a unique price. This is also contained in a separate spreadsheet. I'm looking to clone the original form each time and only change the title without having to manually adjust the other 17 settings. Is this possible?
- BenAnswered on March 25, 2016 at 11:48 AM
When you clone the form, it should contain all of the setup as the previous form did. This includes:
3. thank you page setup
4. form fields
5. form calculations
The only details that are not taken over are the integration(s) and the preferences set up in the form submissions panel, nor of course any submissions already made.
Hope this helps, but do feel free to let us know if you have any additional questions and we would be happy to assist with the same.
- kpriviteraAnswered on March 25, 2016 at 11:51 AM
I understand. The problem is that the maximum entry number for each of the dropdowns and the price is different for each form. Since there are 16 dropdowns, each with two places where I need to manually adjust that maximum allowable entry, along with a different price for each, I am looking to have each form do a lookup from another source. I have an excel spreadsheet with all of the info. I want to clone the original form and change the title and for it to know to change the maximum numbers and the price based on my spreadsheet of information.
- BenAnswered on March 25, 2016 at 12:10 PM
Oh OK, I understand what you mean now.
That is unfortunately not possible.
You would need to add all the data to your form manually. The only thing that could help you is that you could format your cells in Excel to be in the layout that would allow you to copy paste it over in an easier manner.
For example if you have data that you would use as label in one column and price in another.