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 to retrieve data from one sheet and let customer see the result?

    Asked by Jim  on October 10, 2016 at 09:08 AM

    If I'd like to create one form allowing customers to check their order status, how could I suppose to use your software to reach that?

    Customers they only have to enter their email address and the data will be sent to google spreadsheet and find the correspondent answer back to the customer.

    In google spreadsheets, row one is all the email address of my customers and row two is the order status correspondent to their email address also. So it is like Q&A, the system will send back the exact answer back to customers for review after finishing the form.

    Please tell what app or widget I could use to reach that. Thank you for your help.

    Sincerely,

    Jim

     

    and sheet retrieve let
  • Profile Image
    JotForm Support

    Answered by owen on October 10, 2016 at 09:29 AM

    Hi Jim,

    You can definitely do that by using JotForm. Please check our guide here:

    https://www.jotform.com/help/71-Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters

    To get your URLs you can use our application: http://prepopulate.jotform.io/

    You can have a much better idea about this process when you look at this example Google Spreadsheet document which populates fields in JotForm: 

    https://docs.google.com/spreadsheets/d/1zSJ-rHcsGAeSOPJFlPt8opuLYaa18RkS18vVVg4sfCQ/edit#gid=0

    This was created by TitusN who is on our support team.

    Please contact us again if you need any further assistance.