Add spreadsheet from google editable form a JotForm

  • Profile Image
    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 ..
  • Profile Image
    Welvin
    Answered 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. 

  • Profile Image
    exsfvid
    Answered on May 30, 2016 at 08: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

     

     

    Please appreciate your help,

    Thank you

     

     

  • Profile Image
    Charlie
    Answered 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.

  • Profile Image
    exsfvid
    Answered on May 30, 2016 at 11:21 AM
     
    Perfect, just what I need, in this case I require from editing specific people.
  • Profile Image
    EltonCris
    Answered 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!