Add spreadsheet from google editable form a JotForm

  • exsfvid
    Asked 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 ..
    Jotform Thread 848688 Screenshot
  • Welvin Support Team Lead
    Replied 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. 

  • exsfvid
    Replied on May 30, 2016 at 8:58 AM

    JotForm equipment,

    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&amp;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.

    link: https://form.jotformz.com/61137042341645

    Deputy example of what you want to do in the next picture

    Add spreadsheet from google editable form a JotForm Image 1 Screenshot 20

     

     

    Please appreciate your help,

    Thank you

     

     

  • Charlie
    Replied 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.

    Add spreadsheet from google editable form a JotForm Image 1 Screenshot 30

    Now use the iFrame embed widget, instead of the "Text" field to embed your Google spreadsheet shareable link.

    Add spreadsheet from google editable form a JotForm Image 2 Screenshot 41

     

    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.

  • exsfvid
    Replied on May 30, 2016 at 11:21 AM
     
    Perfect, just what I need, in this case I require from editing specific people.
  • Elton Support Team Lead
    Replied 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!