Sort submissions data by state from the address field

  • Profile Image
    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).

  • Profile Image
    EltonCris
    Answered on March 15, 2017 at 01: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:

    Thanks!