How to fill a form with data from a spreadsheet?

What is JotForm?

JotForm is a freeonline form builder which helps you create online forms without writing a single line of code.

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.

Why do you not want to answer this thread?(Your answer will be sent to Jeanette and Aytekin)

procesos

Asked on June 20, 2016 at 10:53 AM

JotForm team,

along with greeting wanted to know if there is any way to import a data from a cell sheets or google economic indicators page to a text field or number of a form JotForm? ...

If you have questions or need some help when trying to import your data to your form, please let us know, we will be glad to help.

procesos

Answered on June 20, 2016 at 12:07 PM

Dear,

What I need is a value as shown in this automated image to appear on the form when a customer opens. manuel leave an example of what I need you to automatically automate.

JotForm Support

Kevin_G

Answered on June 20, 2016 at 12:50 PM

Thank you for the additional details.

As I can understand you want the value from the spreadsheet to appear in the form by default, but this value needs to be taken from the spreadsheet.

There is no a way to integrate a form with a spreadsheet in that way, I mean, you can not populate data form a spreadsheet into a form by doing an integration.

But you can do it by passing the values in parameters via URL, to do it you will need to get the name of that field and then fill it via URL, here is a guide that will help you to get the name of a field: How-to-find-field-IDs-and-names

To add include the values from your cell in the link you may use this workaround, add a new cell with the link to the form, but the link should be added with the value from the spreadsheet added in the parameter, for example, in my spreadsheet I did it like this:

This will generate you different links depending on the value in the cell: