- exsfvidAsked on May 27, 2016 at 12:38 PM<br class="Apple-interchange-newline"><div id="inner-editor"></div>JotForm team
Please wanted to know how I post a JotForm form a link of google spreadsheet in a spreadsheet specific editable but in a form JotForm.
I remain attentive to your comments, thank you very much ..Page URL:
- JotForm SupportWelvinAnswered on May 27, 2016 at 12:58 PM
If you want to integrate your form to Google Spreadsheet, this guide should help you how to do it: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet. If you are looking for something, please give us more details about it so we can assist you further. You are free to reply using your native language.
- exsfvidAnswered on May 30, 2016 at 08:58 AM
on this thread, the question is focused on whether the tool through text (html tools) on the part of souce code, can integrate the following code:
<P style = "text-align: center;"> <iframesrc="https://docs.google.com/spreadsheets/d/1aQ1vXVbltI8b3Yiz-O3rTdWC2ks2z_wXGim5HDPEpRI/pubhtml?widget=true&headers=false" width = "1095" height = "500"> </ iframe> </ p>
but this time you can edit or manipulate it from my JotForm formilario, here is the demonstration in this link, but as you can see, I can only review as an image, without the ability to edit spreadsheets google sheet.
Deputy example of what you want to do in the next picture
Please appreciate your help,
- CharlieAnswered on May 30, 2016 at 10:16 AM
If you want to embed your Google Spreadsheet in your live form and allow users to edit them, then you will need to make the Google Spreadsheet shareable. In my case, you can see that it is set to "Anyone with the link can edit" option.
Now use the iFrame embed widget, instead of the "Text" field to embed your Google spreadsheet shareable link.
It depends on how you have setup your Google spreadsheet, do you allow ANYONE to edit it? Or it it editable to specific people?
Here's a sample form: https://form.jotform.com/61503776437965. You can see there that you can edit the embedded spreadsheet, regardless if you are signed in or not on an account.
I hope that helps.
- exsfvidAnswered on May 30, 2016 at 11:21 AMPerfect, just what I need, in this case I require from editing specific people.
- JotForm SupportEltonCrisAnswered on May 30, 2016 at 12:28 PM
Great! Glad my colleague's solution helped you. Should you have any other questions or concerns, feel free to open a new thread.
Have a good one!