Why my all fields cannot be seen in Google Sheets in one form?

  • Profile Image
    Asked on August 27, 2020 at 02:09 AM

    For one of my forms, in the Google integration, IP, Submission ID, and Edit Link fields are the last 3 fields/columns. 


    In another one of my forms, in the Google integration, these 3 fields do not appear. 


    Could you please explain why this is? The forms are very similar and I haven't changed any settings as far as I know. I have a dependency on the SubmissionID and not having it in the form is breaking it. 

  • Profile Image
    Answered on August 27, 2020 at 07:14 AM

    Hi lifeminny,

    In the Google Sheets integration, you should choose your fields. When I've cloned and tested it, IP, Submission ID and Edit Link fields can be seen as in images;

    1. Go to the Settings tab.

    2. Go to the Integrations menu.

    3. Choose Google Sheets and authenticate your account.


    4. When the Google Sheets screen is opened, you can specify the spreadsheet name and change form fields to send Google Sheets.

    5. Click the Save button.


    Here is a detailed guide about Google Sheet app: https://www.jotform.com/integrations/google-sheets

    Here is another detailed guide about How to integrate Google Sheets into Jotform : https://www.jotform.com/help/228-How-to-Integrate-Forms-with-Google-Sheets

    If you require any further assistance feel free to let us know.