Sort submissions data by state from the address field

  • Lori318
    Asked on March 15, 2017 at 11:21 AM

    My grid shows submission date, church, ethnicity, pastor's name, birthday etc., but not state.  How can I get a state to show up? (It's on my form).

    Page URL: https://www.jotform.com/submissions/50886527058162
  • Elton Support Team Lead
    Replied on March 15, 2017 at 1:58 PM

    Unfortunately, there's no way to filter the data by state in the submissions page. Since the state field is under the address field, they are only shown as single field in the table. 

    You may want to download your form submissions to Excel for now so you can filter it on the Excel app.

    https://www.jotform.com/help/73-How-to-Download-Form-Submissions-as-Excel-CSV-PDF

    Example:

    Sort submissions data by state from the address field Image 1 Screenshot 20

    Thanks!