Consulta - Tabla

  • maximiliano.hernandez
    Fecha de consulta 19 de febrero de 2025, 12:37

    Buen día equipo de Jotform,

    Cómo están?


    Estamos creando un nuevo formulario y precisábamos ayuda con el mismo.

    El formulario es el siguiente “Archivos de canales” https://www.jotform.com/es/build/250494668162666 , queremos crear un cuadro como el de la siguiente imagen.

    Es decir que en la columna minoristas podamos completar ciertas opciones que ya venga por default y que luego se puedan debajo de todas estas opciones, dejar espacios en blanco por si el cliente precisa agregar otras más a parte de estas que ya estarían en la tabla.


    Consulta   Tabla Image 1 Screenshot 20

    Por favor avísenme si no me explico.


    Muchas gracias,

    Saludos 

  • Jefferson Jotform Support
    Fecha de respuesta 19 de febrero de 2025, 16:23

    Hi Maximiliano,

    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, I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

    In the meantime, let us know if you need any other help.

  • Jefferson Jotform Support
    Fecha de respuesta 20 de febrero de 2025, 8:41

    Hi Maximiliano,

    I checked your form, and it looks like you're already using the Spreadsheet widget, which is a great way to achieve the setup you described. If you're looking to allow users to select predefined options while also having blank spaces for additional entries, you can pre-fill certain cells with default values and leave others blank for customization.

    If you prefer not to use the Spreadsheet widget, another option is to use the Input Table element. You can set predefined options in a dropdown or radio button format for certain rows and leave other rows as text fields for users to enter custom options. Here’s how:

    1. In Form Builder, click on the Add Element on the left side of the page.
    2. Add an Input Table element to your form. Consulta   Tabla Image 1 Screenshot 60
    3. In the Input Table element, click on the gear icon to open Input Table Properties window.
    4. In the Input Table Properties window, click on the Fields tab.
    5. In the Fields tab, click on the Textbox option. Consulta   Tabla Image 2 Screenshot 71
    6. Scroll down and look for Rows then map the fields based on the image. Consulta   Tabla Image 3 Screenshot 82
    7. Scroll down and look for Columns then map the fields based on the image. Consulta   Tabla Image 4 Screenshot 93

    Here's the sample output:

    Consulta   Tabla Image 5 Screenshot 104

    Give it a try and let us know if you have any other questions.

  • maximiliano.hernandez
    Fecha de respuesta 20 de febrero de 2025, 11:58

    Hi Jefferson,

    How are you?

    Thanks for your answer and information.

    Regarding the spreadsheed widget that we are already using, how can we set predefined options while also having blank spaces for additional entries? Could you please help with this?

    We need to have a table like the image below, with predefined values and then in the highlighted yellow spaces have the option (customer) to add new options.

    Consulta   Tabla Image 1 Screenshot 20


    Thanks in advance for your help!


    Best regards,

  • Jefferson Jotform Support
    Fecha de respuesta 20 de febrero de 2025, 13:00

    Hi Maximiliano,

    I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

    In the meantime, let us know if there’s anything else we can do for you.

  • maximiliano.hernandez
    Fecha de respuesta 20 de febrero de 2025, 13:19

    HI Jefferson,

    Thanks for your answer! Keep us updated.

    Best regards,

  • Jefferson Jotform Support
    Fecha de respuesta 20 de febrero de 2025, 14:36

    Hi Maximiliano,

    I’ll still need a bit of time to look into this. I’ll get back to you as soon as I can.

    In the meantime, let us know if you need any other help.

  • Reban Jotform Support
    Fecha de respuesta 21 de febrero de 2025, 11:23

    Hi Maximiliano,

    Unfortunately, it's not possible to set predefined values or dynamically add a new row when using the Spreadsheet widget. As an alternative, you can use the Configurable List widget or Matrix Dynamique widget to allow users to add rows dynamically, but these widgets do not support predefined values.

    If you set the first column in the Configurable List widget as a predefined text field, it will apply the same type to any newly added rows. Check out the screencast below:

    Consulta   Tabla Image 1 Screenshot 30 For the best solution, consider using an Input Table for the existing rows and a Configurable List widget to add new ones. This setup provides more flexibility. Check out the screencast below:

    Consulta   Tabla Image 2 Screenshot 41 If you'd like to use this workaround, you can check out my demo form for reference. This guide will show you how to clone the form.

    Give it a try and let us know how it goes.

  • maximiliano.hernandez
    Fecha de respuesta 21 de febrero de 2025, 11:58

    Thanks Jefferson for your answer and information!

    Best regards,

Su respuesta