Question about integrating with google spreadsheet

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

  • Profile Image
    aubreybourke
    Answered on June 30, 2017 at 01: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:

     

    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:

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

    And finally click on Download as Excel: