Solicitud de Asesoramiento para Automatizar la Inserción y Eliminación de Valores en una Tabla con Casillas y Condiciones

  • yerkobug
    Perguntado em 5 de outubro de 2023 às 15:48

    "Saludos, he estado trabajando con una tabla que contiene casillas y condiciones, y me he encontrado con la siguiente situación. Mi objetivo es que al seleccionar una casilla de la tabla, se inserte automáticamente su número correspondiente, y si deseo seleccionar otra casilla, esta se acompañe con un ';' seguido de su número correspondiente, tal como se muestra a continuación.

    Solicitud de Asesoramiento para Automatizar la Inserción y Eliminación de Valores en una Tabla con Casillas y Condiciones Image 1 Screenshot 20

    Este proceso lo he realizado manualmente, pero deseo que al deseleccionar una casilla, tanto el valor como el ';' correspondiente se borren automáticamente. ¿Cómo puedo lograr esto de manera automatizada?"

  • KrisLei Jotform Support
    Respondido em 5 de outubro de 2023 às 20:59

    Hello Yerko,

    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.

    Now, let me help you with your question. I see you like to copy the value selected from the Input Table with a corresponding colon symbol to separate each number, correct? If so, you must assign values for each column in the Input Tables settings. Let me show you how.

    1. Select the Input Table element, then click on the cogwheel icon,
    2. Go to the Options tab.
    3. Then, enter the values to be used with a corresponding colon symbol (;) for each column with a comma to separate each value. So, each column will contain the value with a colon. For example, for column 1, the calculation value would be '1;'.

    Solicitud de Asesoramiento para Automatizar la Inserción y Eliminación de Valores en una Tabla con Casillas y Condiciones Image 1 Screenshot 60

    We also have a related guide on Performing Calculations With Input Table that you might want to check out. The next step would be creating an Update/Calculate Conditional Logic to pass the selected value to the Long Text field.

    Solicitud de Asesoramiento para Automatizar la Inserción y Eliminación de Valores en una Tabla con Casillas y Condiciones Image 2 Screenshot 71

    This conditional logic should pass the values from the Input Table element to the Long Text field based on the user's selection. So, the conditional logic should be set up like in the screenshot below.

    Solicitud de Asesoramiento para Automatizar la Inserción y Eliminación de Valores en una Tabla con Casillas y Condiciones Image 3 Screenshot 82

    Please also ensure that the 'A-Z' in the condition is highlighted in gray to read the value as a string, not as a number. Clicking on the added subfield in the condition will change the highlight. Please see the screencast below for a quick demo.

    Solicitud de Asesoramiento para Automatizar la Inserción y Eliminación de Valores en una Tabla con Casillas y Condiciones Image 4 Screenshot 93

    Here's the result:

    Solicitud de Asesoramiento para Automatizar la Inserción y Eliminación de Valores en una Tabla con Casillas y Condiciones Image 5 Screenshot 104

    Feel free to test the results here on the cloned version of your form. If that's not exactly what you're looking for, can you explain a bit more so I can help you better? 

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

  • yerkobug
    Respondido em 6 de outubro de 2023 às 08:11

    Is there a way that the last value does not end with ";" Because in the example the configuration takes 20 as the last number and there is no problem there, but what happens if the last number is not 20 and is not accompanied by the ";"
  • Sheena Jotform Support
    Respondido em 6 de outubro de 2023 às 10:34

    Hello Yerko,

    I moved your other question to a new thread and helped you with that here.