Complete los campos del formulario con datos de una fuente externa.

  • angelicagarcia499
    Fecha de consulta 31 de octubre de 2024, 11:44

    Buenos dias


    Estoy buscando realizar un formulario en donde, se almacene y genere informacion de un formulario. El formulario consiste en mantenimientos. Necesito que ellos seleccionen el nombre de la empresa y les traiga las camaras que existen en esa empresa.


    En los campos necesito que ellos suban una foto del antes del mantenimiento y despues. Pero como dependiendo de la empresa que seleccionen, seran los campos que les aparezca.


    Me gustaria saber si tienen algun o algunos widgets en mente para realizar esto.


    Muchas gracias por el soporte.

  • Eliza Jotform Support
    Fecha de respuesta 31 de octubre de 2024, 13:58

    Hi Angelica,

    Thanks for reaching out to Jotform Support. Our Spanish Support agents are busy helping other Jotform users right now, so I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Spanish, let us know and we can have them do that. But, it might take a while until they're available again.

    Now, coming back to your question, are you hoping to populate your form fields from an external source? Are you hoping to populate your form fields from an external source? If yes, you can check out our Spreadsheet to Form widget. This widget allows users to pull existing records and display them on your form. These are the form fields that can be populated with details from your external sheet with the help of the said widget:

    • Full Name
    • Email
    • Time
    • Short Text
    • Long Text
    • Dropdown
    • Single Choice
    • Multiple Choice
    • Scale Rating
    • Star Rating

    If this widget will work for you, let me show you how to add the Spreadsheet to Form widget to your form:

    1. In Form Builder, click on Add Form Element in the upper-left corner.
    2. Go to Widgets, and search for Spreadsheet to Form.
    3. Drag and drop it onto your form, and upload the Excel file by clicking on Upload File in Widget Settings.
    4. Once uploaded, set the Access Code Column. It should be the data that your form fillers should enter into the Spreadsheet to widget field that would trigger the populating of data.

    Complete los campos del formulario con datos de una fuente externa Screenshot 30 Check out the screencast below to see my results:

    Complete los campos del formulario con datos de una fuente externa Screenshot 41 Note that the column names in your spreadsheet should be the same with the labels on your form.

    If that’s not exactly what you’re looking for, can you explain a bit more, so I can help you better? As for your other question, I've moved that to a new thread. You can check that out here.

    Let us know if you have any other questions.

Su respuesta