Agregar base de datos a formulario

  • agrosilossjn
    Fecha de consulta 23 de octubre de 2024, 6:57
    Buen día, necesitaría saber si hay alguna forma de agregarle a un formulario una base de datos de mis clientes?
  • Chris_L Jotform Support
    Fecha de respuesta 23 de octubre de 2024, 7:05

    Hi agrosilossjn,

    We have a Spreadsheet to Form Widget that you can use to import your data. Let me show you how to use it:

    1. Create a spreadsheet with your data structured like you see below. Make sure that the column names in the spreadsheet match the field names on the form, and include a unique column, like an ID, so the data can be distinguished.

    Agregar base de datos a formulario Image 1 Screenshot 50

    2. In Form Builder, click on the Add Form Element menu on the left side of the page.

    3. Click on the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.

    4. In the menu on the right side of the page, upload your data file. (You can simply drag & drop your Excel file to the Upload File area.) 

    Agregar base de datos a formulario Image 2 Screenshot 61

    5. Then, click on the Downward Arrow icon in the Access Code Column option and select the unique column.

    6. You can also customize texts used in the widget. After you complete everything, click on the Update Widget button at the bottom right of the menu.

    Agregar base de datos a formulario Image 3 Screenshot 72 Now, when people fill out your form and enter the unique code from the spreadsheet, the corresponding fields will automatically populate when they click Auto Complete Fields. Check out my screencast below to see how it works:

    Agregar base de datos a formulario Image 4 Screenshot 83 Give it a try and let us know if you need any help.

  • agrosilossjn
    Fecha de respuesta 23 de octubre de 2024, 7:29

    Buenicimo, te pregunto, no hay un tutorial en español (ejemplo "

    que me explique el paso a paso?


  • Chris_L Jotform Support
    Fecha de respuesta 23 de octubre de 2024, 7:51

    Hi agrosilossjn,

    We also have a guide to help you learn how to user Spreadsheet to Form widget. If your Jotform account language is set to Spanish, the guide should be in Spanish as well.

    Let us know if you need any more help.

  • agrosilossjn
    Fecha de respuesta 23 de octubre de 2024, 14:03

    Buenísimo, te pregunto, no hay un tutorial en español (ejemplo "


    que me explique el paso a paso?

  • Paolo Jotform Support
    Fecha de respuesta 23 de octubre de 2024, 17:16

    Hi agrosilossjn,

    You can use this video tutorial created by Jotform which is available in Youtube. Although the video is in English, you can set the subtitles to Spanish. Let me show you how:

    1. Once your signed in to your Google account, Open the link of the tutorial.
    2. Click on your Avatar Profile at the top Right side of the page, change the Language to Español.
    3. Now, hover your mouse on the video and click the Gear Icon to open Settings.
    4. Go to Subtitles, if it is currently off choose English first. It will then show the option Auto Translate. Make sure to choose Spanish.

    Agregar base de datos a formulario Image 1 Screenshot 20

    Give it a try and let us know how it goes.