Spreadsheet to form: Ability to connect to Jotform Tables

  • jdalo66
    Fecha de consulta 30 de abril de 2024, 9:32

    al agregar un desplegable en un formulario, puedo traer los valores de una tabla y desplegarlo para seleccionar sus datos?

  • Kyle Jotform Support
    Fecha de respuesta 30 de abril de 2024, 11:56

    Hi Juan,

    Thanks for reaching out to Jotform Support. Our Spanish Support agents are currently busy assisting other Jotform users. However, I'd be happy to help you in English using Google Translate and you can reply in whichever language you feel comfortable using. If you'd rather have support in Spanish, let us know, and we can have them do that. But keep in mind that you'll have to wait until they're available again.

    Now, let me help you with your question. Yes, you can populate a dropdown field using the Spreadsheet to form widget. Let me show you how to use it:

    1. Create a spreadsheet that includes your data in the structure you see below. It's important that the column names in the spreadsheet and field names on the form are the same.1643012753 61ee6291bccef  Screenshot 50
    2. In Form Builder, click on the Add Form Element menu on the left side of the page.
    3. Under the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.Spreadsheet to form: Ability to connect to Jotform Tables  Image 1 Screenshot 61
    4. In the Widget Settings window that opens up, upload your data file and customize the other options. 
    5. Then, click on Update Widget. Spreadsheet to form: Ability to connect to Jotform Tables  Image 2 Screenshot 72
    6. In the final stage, add the fields to view values and name them the same as on the spreadsheet.

    Spreadsheet to form: Ability to connect to Jotform Tables  Image 3 Screenshot 83

    Make sure to add your options to the Dropdown Properties: Spreadsheet to form: Ability to connect to Jotform Tables  Image 4 Screenshot 94

    Give it a try and let us know if you need any help.

  • jdalo66
    Fecha de respuesta 3 de mayo de 2024, 12:09

    Gracias muy amable, pero mi consulta era si al colocar en un formulario un elemento desplegable , al desplegar, valga la redundancia, puede traer valores de una tabla, por ejemplo del primer campo de la tabla

  • Kevin Support Team Lead
    Fecha de respuesta 3 de mayo de 2024, 19:04

    Hola Juan,

    Desafortunadamente, no es posible conectar el widget a la página de Tablas de tu formulario o algún documento en línea, por el momento solo es posible cargar un archivo con los registros a cargar. Me temo que por el momento no tenemos ningun widget que cumpla con el requisito que busca.

    Voy a proceder escalando esta solicitud a nuestro segundo nivel de soporte, aunque no podemos brindar un tiempo estimado para su disponibilidad, le mantendremos informado a través de este ticket tan pronto como recibamos noticias al respecto.

    No dudes en contactarnos si tienes alguna consulta adicional.


 
Su respuesta