-
ferFecha 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 SupportFecha 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 SupportFecha 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:
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.
2. Drag and drop a Short Text field on your form.
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.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.
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.7. In Access Code Column, select your codes column.
That's it. Let us know if you have any other questions.