How can I take data manually added into the Jotform submission sheet &a

JSC Admin
Asked on April 04, 2022 at 02:28 PM

How can I take data manually added into the Jotform submission sheet & show that in Google Sheets; eg we've added Invoice ID against every line item in the Submission sheet & we'd like to manipulate that in Google Sheets.
Secondly, why cant we extract comment type text from the Jotform form that appears in the Jotform Submissions sheet into Google Sheets?

I await your advice,
Thanks
Steve

This is a re-post of a comment on How to Integrate Forms with Google Sheets

This is a re-post of a comment on How to Integrate Forms With Google Sheets

Page URL:
https://www.jotform.com/help/228-how-to-integrate-forms-with-google-sh<br/>eets/
Carlo

Jotform Support

Answered on April 04, 2022 at 05:50 PM
Hello JSC,

Thank you for reaching out to Jotform Support. If you are editing the submission within the Tables page, you have two options to do so:
- Inline edit (you just double click a cell and add a new value)
- Edit Entry (it loads the whole submission in edit mode)
If you wish for emails and integrations to be triggered, please make sure the edit entry option.
How-to-edit-submissions-made-on-your-forms
If the issue persists even when using that option, please re-integrate Google Sheets and refrain from making manual edits within the Google Sheet as it may break the integration.

For your other query, I have to move it to a different thread to avoid confusion which can be found on this ticket #3907399. I will be assisting you further on that ticket.