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

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

    https://form.jotform.com/202112544017339


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

    https://form.jotform.com/201632682970053


    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
    grace
    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.

    1598526233Screen%20Shot%202020-08-27%20a

    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.

    1598526621Screen%20Shot%202020-08-27%20a

    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.