What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
I need to be able to view the form submissions for each city.Asked by narrowbridgecandles on June 07, 2016 at 12:34 AM
I need to be able to view the form submissions for each city (and share this spreadsheet with the group order coordinator. I also need to be able to see totals for all the cities. Are there functions possible? Could you show me some screenshots, or direct me to a demo that walks me through this kind of sorting and viewing of information in my JotForm dashboard?
Also, I don't know if I need 25 separate forms (identical except for city name) on 25 different pages inside of my site, or if I can have 2 links to 2 form (U.S. and International) that begin with a drop down menu that has choice of cities.
Does having separate forms help me with sorting of information and sharing with a group order coordinator? If I need 25 forms for 25 pages inside of my website, How do I distinguish the forms from each other for filtering into separate spreadsheets for each city?
You will be able to view the submissions for each city on the submissions page by typing in the location on the search bar. Please see screenshot below.
Then you can download the result as a spreadsheet by clicking on the Excel button seen in the screenshot below:
If you use 25 separate forms for the 25 locations, then you will be able to see the submissions for each location by checking each form's submissions page. You can also use specific names for each forms such as "Order Form - Boston" and "Order Form - New York" to distinguish which forms are from which location.
However, if you prefer to have all the submissions from the 25 locations to be found in only one submissions page, and just sort it afterwards, then using a dropdown with a choice of cities will be suitable for your requirement.
If you need further assistance, please let us know.