I need to be able to view the form submissions for each city.

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.