How can I display value from google sheet to form?

  • Profile Image
    Asked on April 12, 2016 at 04:23 AM
  • Profile Image
    Answered 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 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 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 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
    Answered 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.



  • Profile Image
    Answered on April 13, 2016 at 06:38 AM

    Thanks bro