- BuzzcomAsked on February 23, 2016 at 11:30 PM
I have several questions regarding one form.
I have a form that requires a lot of repeat input fields. I would like the user to be able to add them as needed. The input fields need to be able to be added as a group, rather than individual.
Please see form
You will see the calculation field total - and then the result input fields below - it is these fields that I am referring to.
2 -I would like the form to be submitted to a spreadsheet that is viewable by other users on my website. Does your spreadsheet system do this automatically and how long will the results remain online - or do I need to link to zapier to do this? Please explain further what is the best way to achieve this?
3 -Is there any way of ordering the results listing from first place to last depending on the score inputed. At the moment I have allowed the user to put in the placing - but then they are not necessarily in order - I would prefer to not to have the user input the placing however the system do it automatically from the score input and then to appear in order from first place to last place on the spreadsheet. Please explain how I can achieve this.
Thanks in advance
- JotForm UI DevelopermertAnswered on February 24, 2016 at 08:17 AM
For your first question, you can use the "Configurable List" widget, if you don't use those values in calculation from those fields. With adding that one, you can let the users add as many fields as they want.
However, you need to calculate values, so we need to hide the fields first, then we can show the fields with respect to the users' choice by using the "Show/Hide a Field" condition; but first we need to use form collapse to divide our form in sections.
Below, you will find the guide about this feature:
Also, please check the example "Show/Hide a Field" condition from the image below:
Please, see the live form from the link below:
I hope this method will meet your needs. For further assistance, please do let us know.