hoja de calculo a formulario

Buenos días, estoy trabajando con un formulario en el que inserto una "hoja de cálculo a formulario".

Se trata de que cuando yo ingrese el valor "grupo" en el widget se me pueda desplegar automáticamente otro campo de selección, múltiple o única, con todo el listado de personas que hay en ese grupo.

Logro poner que me salga el primer integrante del grupo, pero necesitaría que me salieran todos los integrantes de ese grupo que están en la excel vinculada. Gracias. Saludos

Hi iesramonycajalvalladolid,

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'll have to wait until they're available again.

Now, let me help you with your question. Are you referring to this form ID: 233335876986070? If so, could you share with us your Excel spreadsheet so that we could test it on our end? When I cloned your form and tested it, the spreadsheet to form is not autopopulating the number field when the code is entered. The first row will be used as a column header for your access code. It would help us to understand what’s happening if you could take a screenshot and send it to us. We have a guide here explaining how to do that. Check out this guide on How to Use the Spreadsheet to Form Widget.

Once we hear back from you, we'll be able to help you with this.

Buenos días, creo que no ha entendido bien mi pregunta, yo ahora mismo tengo un formulario que es este https://eu.jotform.com/build/233335876986070

Es un formulario muy sencillo, ya que se trata de una prueba, si usted lo observa, de una lista desplegable se selecciona el grupo, que inmediatamente se traslada al  widget hoja de cálculo a formulario y se autocompleta la casilla de nombre.

Esta casilla de nombre, solo se autocompleta con el primer nombre de todos los que integran el grupo y yo necesitaría que me salieran todos los integrantes de ese grupo que están en la excel vinculada. Gracias. Saludos

Le adjunto la excel vinculada

No me deja adjuntar el archivo, no funciona el botón de adjuntar

Hi iesramonycajalvalladolid,

Thanks for using Jotform. If you're looking to autofill the Spreadsheet to Form widget with the name selected from the dropdown field, you need to set the AutoFill By Condition setting to 'Yes' on the widget's Settings panel. Let me show you how:

1. In Form Builder, click on the Wand icon of the spreadsheet to form widget.
2. Enable the AutoFill By Condition by selecting Yes.

Can you share with us the spreadsheet you uploaded to the widget so we can check? You can upload it to a file-sharing site like Google Drive and share the link with us. Just make sure the link is set to public so we can easily access it without asking for your permission.

Once we hear back from you, we'll be able to help you with this.