- ysmeninternationalAsked on April 11, 2017 at 07:05 AM
I am building a club application form that gives the option to add the club members either in a spreadsheet as an uploaded file, or to enter the members one by one in the actual form.
If they choose to upload them in a file, they skip to page 74 and that field for the upload is shown.
If they choose to enter them one by one, it goes to the next page and the first member to be entered.
As I don't know how many members will be entered (but at least 15 in each case) I have created 70 pages for members' details which is above and beyond the number needed for most expected applications. I am not using a configurable list because there are too many details being requested that just don't fit in a conditional list. After the 15th member, each subsequent page asks if this is the last entry or if they need to enter another member.
If it's the last entry, it skips to page 74, where the rest of the details are entered. If they need to enter another member, it goes to the next page.
What I want to be able to do is ensure that if they are finished entering members, that the remaining unnecessary pages are hidden from the preview (preview and submit feature) and are not included in the submission.
I am relatively confident with using conditions but I am hoping for some shortcuts. I love jotform so much but find many tasks very laborious when you have big forms. (For example, I noticed too late that the pages I had been duplicating had the wrong date format on the date picker - I had 3 pickers per page and 70 pages and had to change them one by one...). Would there have been a shortcut there?
Basically, is it the case that for each page over 15 members (55 pages) I need to have a condition that hides all those remaining fields (which can be hundreds) if they select that it's the last member to be entered?
Would another way be to hide all those pages by default and then for each page just select to show the fields on the very next page if they select to add another member? Does it work like that?
What would be easiest/quickest? or maybe a better way??
Thanks in advance!!
- SvenAnswered on April 11, 2017 at 08:34 AM
You can do that by setting conditional logic to skip pages instead of fields, this way, if the user selects this is the last member to be entered, they can skip immediately to page 74, where they submit the form.
Please refer to the detailed guide below:
- ysmeninternationalAnswered on April 11, 2017 at 08:38 AM
Thanks for the answer but this I don't think this will solve my problem of having up to 55 blank pages in the preview, or the actual submission, if only 15 are submitted. I want the form to be relatively clutter free when the person previews it and only show the actual members entered and nothing more. Also, I hope that when the form is submitted, it also only shows the fields completed.
- JotForm SupportcandyAnswered on April 11, 2017 at 10:30 AM
Having more than 74 pages of form would be a huge work to handle. Why do you want to create separate pages for each person? Each person can submit the same form and you can print the submission PDFs for every submission.
You can skip some of the pages with conditions as my colleague Sven has already suggested and this would be the only way. Unfortunately, we do not have a shortcut for this purpose.
Related to your second comment "Also, I hope that when the form is submitted, it also only shows the fields completed.": This is possible with the "Hide Empty Fields option" of the notification emails as you can see below:
Also, you can hide the empty fields in the submissions page enabling the "Auto Hide Empty Fields Option" as you can see the screenshot below:
I hope this helps.
- ysmeninternationalAnswered on April 12, 2017 at 02:57 AM
Thanks! I know I have created a lot of work - it must be all contained in one form because the individual members are not responsible for completing the member forms - it's one person who completes it on all members' behalf. It also ensures everything comes at once, not form by form and the possibility that some are not completed.
The main way for them to submit the member roster is with a spreadsheet but feedback suggests that some prefer this type of online submission so it's being provided as an option.
I have some ideas on how to accomplish my goal but there are obviously no shortcuts. I will keep trying.
- JotForm SupportChriistianAnswered on April 12, 2017 at 03:57 AM
Yes, you can try the above suggestions of my colleagues. If you need further help, don't hesitate to contact us again. We'll be happy to assist you.
- ysmeninternationalAnswered on April 12, 2017 at 09:05 AM
My idea was to set a condition to hide all remaining, unused fields if it was the last member entered. It will then also use skip logic to go to page 74. This worked. The unnecessary fields do not appear in the preview. However, you have to set this condition for every page (hiding every page beyond that page)...
But with so much logic and so many pages, it seems this is causing the preview to lag. Can I expect such a big form to be as slow once published?
- JotForm SupportcandyAnswered on April 12, 2017 at 10:32 AM
Yes, if your form would be too complex, it could take some time to load the form. Also, if you have too many widgets and too many conditions, your form would be too slow.
All of these factors affect the form performance.
For your information.