What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Forms to read/write info from/to Spreadsheet

    Asked by glandoreghyc on February 10, 2014 at 07:54 AM

    I have a requirement to set up a system where by a form would be set up to "mirror" the cells within a small spreadsheet.

     

    Can i set up a form to display the contents of the spreadsheet?

    And then to update the spread sheet with the changed fields?

     

    Thank You

     

    John

    then and
  • Profile Image
    JotForm Support

    Answered by ashwin_d on February 10, 2014 at 09:43 AM

    Hello John,

    Unfortunately, we do not have such feature. There is no way currently available to read/write data to a google spreadsheet.

    What can be actually done is directly embed a google spreadsheet in an iFrame. That should be very close to your requirement. You can use the "Text" field to embed your form.

    Here is a demo form I have created for you: http://form.jotformpro.com/form/40403652672955

    Feel free to clone this form for a closer look. This guide should help in form cloning:  https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!

    Thank you!

  • Profile Image

    Answered by glandoreghyc on February 11, 2014 at 04:21 AM

    Hello,

     

    I Cloned the Form but when i tried to edit the new form i kept getting a message saying that my browser window was too small to display the full contents i had to change the size of the browser window, unfortuneately the window is already at max screen size, so i am slightly confused as to what to do next.

    Also i think i know where this is going, and it is not what i was looking for unfortuneately.

     

    Thx

     

    John

  • Profile Image
    JotForm Support

    Answered by ashwin_d on February 11, 2014 at 08:20 AM

    Hello John,

    Upon checking your account, I could not find the cloned form. You must have deleted it as not what you were looking form.

    But unfortunately, that is the only way to read/write and to an excel spreadsheet. There is no other option to display the spreadsheet in your form.

    Thank you!

  • Profile Image

    Answered by glandoreghyc on February 11, 2014 at 08:56 AM

    However i am very grateful for your help

    Thank You

    John