Widget de lista configurable: rellena automáticamente los campos mediante lógica condicional

  • fer
    Fecha de consulta 18 de octubre de 2024, 17:00

    estoy utilizando el "Widget de Lista Configurable" , en un formulario, quisiera si es posible que al escribir un codigo ya existente en lo q' llevo guardado en el formulario, si coincide el numero me llene los demas campos...!! una especie de autocompletar,!! si un dato coincide.

    ej. la lista configurable tiene campo de codigo, nombre, tel, email

    si ya llevo varios archivos guardados, y escribo el codigo, me lo identifique que ya existe y me rellene los campos con lo ya archivado.

    Es posible hacerlo ?

  • Gian_D Jotform Support
    Fecha de respuesta 18 de octubre de 2024, 19:37

    Hi fer,

    Thanks for reaching out to Jotform Support. Unfortunately, our Spanish Support agents are busy helping other Jotform users at the moment. 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, keep in mind that you'd have to wait until they're available again.

    As for your issue, I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

  • Gian_D Jotform Support
    Fecha de respuesta 19 de octubre de 2024, 10:23

    Hi fer,

    Although we don't have an option to automatically fill out your Configurable List widget fields, as a workaround, you can use a Short Text field to collect the name, phone, and email address of the user. Then, using the Spreadsheet to Form widget, your users can verify a code on your form, and if it matches one of the codes on file, the Short Text field's will be automatically filled out. I've created a sample form to demonstrate it. Check out the screencast below:

    Widget de lista configurable: rellena automáticamente los campos mediante lógica condicional Image 1 Screenshot 80

    As you can see, the field is getting filled out when the code entered in verified. Let me show you how to do it:

    First, let's add a Short Text field to your form:

    1. In Form Builder, click on Add Element on the upper left side of the page.

    Widget de lista configurable: rellena automáticamente los campos mediante lógica condicional Image 2 Screenshot 91

    2. Drag and drop a Short Text field on your form.

    Widget de lista configurable: rellena automáticamente los campos mediante lógica condicional Image 3 Screenshot 102

    Now, let's create a spreadsheet document:

    1. In your spreadsheet builder, create a column for codes.
    2. Create a column for your form field.

    Widget de lista configurable: rellena automáticamente los campos mediante lógica condicional Image 4 Screenshot 113

    3. Save and download your spreadsheet document.

    Finally, let's add a Spreadsheet to Form widget to your form:

    1. In Form Builder, click on Add Element on the upper left side of the page.

    Widget de lista configurable: rellena automáticamente los campos mediante lógica condicional Image 5 Screenshot 124

    2. Click on the Widgets tab.
    3. Search for Spreadsheet to Form.
    4. Drag and drop a Spreadsheet to Form widget on your form.
    5. On the right side panel, click on Upload File.
    6. Upload your spreadsheet document.

    Widget de lista configurable: rellena automáticamente los campos mediante lógica condicional Image 6 Screenshot 135

    7. In Access Code Column, select your codes column.

    Widget de lista configurable: rellena automáticamente los campos mediante lógica condicional Image 7 Screenshot 146

    That's it. Let us know if you have any other questions.