Resolver array con tabla oculta - Anular datos sin contenido

Estimados

Buenas tardes

De acuerdo a lo sugerido para resolver datos array en el siguiente enlace:

https://www.jotform.com/answers/10037341-table-data-reflecting-as-array-in-hubspot

Quisiera solicitar ayuda para configurar que la condición también elimine los datos que no tengan resultado.

Ejemplo:

A continuación la configuración de la condición:

Y el resultado es el siguiente:

Solo deseo que aparezcan las tallas que SI contienen datos.

Por lo tanto los datos que deseo que lleguen a la TABLA OCULTA debiesen ser:

Hombre S:3/ Hombre XXL:5/ Mujer L:1/

El formulario es el siguiente: https://form.jotform.com/240446419524658

Quedo atenta

Desde ya muchas gracias

Saludos

Carmen

Hi Cyoyac,

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. What you are trying to achieve is not possible, You can only pass the input value to a long text element. The reason why it shows all the string values, once the input table is filled it will automatically show all the string values. It is because of these conditions:

Rest assured that we keep on adding features to our integrations to improve our service.

Let us know if you have any other questions.

Hola Wilson

Muchas gracias por tu respuesta.

Esta consulta nace porque los datos que recibimos de la tabla de tallas es ARRAY, y el equipo de soporte JOTFORM nos ha sugerido agregar una tabla oculta para que se llene con los datos de tallas. Pero lamentablemente no nos sirve porque según nos comentas, no es posible eliminar los datos sin información.

Tu tendrías otra opción para que podamos obtener las tallas correctas en vez de "ARRAY"?

Hi Cyoyac,

Thanks for getting back to us. I cloned your form and tested it to see if I could replicate the issue, but everything was working properly. I tried to submit your form as well. Check out the screenshot below to see my results:

Is the screenshot you provided coming to a notification email? I tested your form and it is not showing the ARRAY.

As soon as we hear back from you, we can move forward with a solution.

Wilson, lamento no haber podido explicar bien mi situación.

No te aparece ARRAY porque lo resolví configurando la TABLA OCULTA, pero si la eliminamos, aparecerá el ARRAY.

La tabla oculta NO ME SIRVE porque recibe TODOS los datos de las tallas y yo solo necesito los que se completan.

Por as razones anteriores quisiera saber si existe alguna otra opción de que me llegue las tallas sin tener que configurar una TABLA OCULTA.

Quedo atenta

Hi Cyoyac,

Thanks for getting back to us. I'm sorry you're having difficulties with this. We're unable to find what you're trying to do. Would you like to upload a Loom video on what you're trying to do that appears the ARRAY issue?

As soon as we hear back from you, we can move forward with a solution.

Estimado Wilson

Dejo a continuación ejemplo en loom donde aparece ARRAY en la sección tallas.

https://www.loom.com/share/873b794ca7e14fdbb74f276c6b033f40?sid=e1781911-8ff6-40a7-aabc-fdc486e69a6d

Formulario utilizado https://form.jotform.com/233234954480660

Quedo atenta

Gracias

Saludos

Carmen

Hi Carmen,

Due to the strings that you have added to the conditional logic, even if the fields are empty, the strings will still exist on the result as shown in the screenshot.

There is no option or workaround to remove these strings. I would suggest you add multiple hidden Short Text form element for each Input Table cell and use it instead of the Long Text form element that you are currently using. Here's how to do it:

How to add Short Text form element:

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

2. Scroll down to Short Text form element.

3. Click/Drag to add it into the form.

How to hide a Short Text form element:

1. In Form Builder, click on the Short Text form element.

2. On the right side of the Short Text form element, click on the Gear icon.

3. On the right panel, go to Advanced.

4. Turn on Hide field.

How to create Update/Calculate Field conditional logic:

1. In Form Builder, in the orange navigation bar at the top of the screen, click on Settings.

2. Click on Conditions on the left side of the screen.

3. Click on Add condition.

4. Select Update/Calculate Field.

5. Configure the conditional logic as shown in the screenshot.

6. Click on Save.

Result:

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