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

  • lifeminny
    Asked on August 27, 2020 at 2: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. 

  • grace JotForm Developer
    Replied on August 27, 2020 at 7: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 Screenshot 10

    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 Screenshot 21

    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.