-
lifeminnyAsked 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 DeveloperReplied 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.
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.