Question about integrating with google spreadsheet

  • CMHForms
    Asked on June 30, 2017 at 12:49 PM

    When using the pertinent widget to send form submissions to a spreadsheet, is it possible to customize the output (need to exclude some fields, change headings etc.)?

     

    Thanks.

  • aubreybourke
    Replied on June 30, 2017 at 1:21 PM

    If you use the Google Spreadsheet integration the headings and fields that you specify in JotForm will be the headings and fields you get in your spreadsheet:

    Question about integrating with google spreadsheet Image 1 Screenshot 60

    Question about integrating with google spreadsheet Image 2 Screenshot 71

     

    Note that if you want to filter your submissions you can export your submission data in Excel format. For example you can specify a time range, or omit fields you dont want to show.

    To do that, you need to go to "My Forms", select a form, click on submissions:

    Question about integrating with google spreadsheet Image 3 Screenshot 82

    then click on the gear icon. And you will be able to select your filters.

    Question about integrating with google spreadsheet Image 4 Screenshot 93

    And finally click on Download as Excel:

    Question about integrating with google spreadsheet Image 5 Screenshot 104