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

    How can I display value from google sheet to form?

    Asked by vikramvn on April 12, 2016 at 04:23 AM
    sheet how retrieve value Google Sheets
  • Profile Image
    JotForm Support

    Answered by ashwin_d on April 12, 2016 at 05:19 AM

    Hello vikramvn,

    I am not sure if I have understood your question correctly. Do you mean to say that you want to populate your form fields with the values form google spreadsheet?

    Unfortunately it is currently not possible to achieve this. It is not possible to read data form any external source or previous submissions you have received in form.

    Hope this answers your question. 

    Do get back to us if you mean to ask something else.

    Thank you!

  • Profile Image

    Answered by vikramvn on April 12, 2016 at 05:43 AM

    Thanks bro. then what is the use of the app "Import data" kindly help me

  • Profile Image

    Answered by Ben on April 12, 2016 at 06:50 AM

    It is possible to import the data to your submissions panel - not to the form itself.

    What that means is that if you have Google Sheet, you could download it as Excel file and then upload it to your form. This would allow you to consolidate all data in one place.

    That will then allow you to view that data together with the submitted data on your form.

    What my colleague meant is that you would not be able to load the data from Google Sheet to your form in a sense of pre-filling the fields.

    Hope that this helps.

  • Profile Image

    Answered by vikramvn on April 12, 2016 at 07:23 AM

    Lots of thanks for your immediate reply,it save my time.Finally i ask you one help.

    Description of my task

    i want to maintain and allocate stock material.if the user enter to allocate material i want to check the stock qty exceed or not.Is it possible to do?

  • Profile Image
    JotForm Support

    Answered by mert on April 12, 2016 at 09:15 AM

    To do the similar task, you can use the "Gift Registry" widget, this one will allow you to define the number of the items in the list; but it is not working real time with your spreadsheet, you need to enter the values manually and also, the changes are not applied to your spreadsheet. Only on your form, the stock is going to decrease.

    To sum up, your users will understand the stock status on your form; but the changes won't applied to your spreadsheet. For further assistance, please do let us know.

     

    Regards.

  • Profile Image

    Answered by vikramvn on April 13, 2016 at 06:38 AM

    Thanks bro