-
jesusbitterFecha de consulta 28 de junio de 2024, 10:51
hola estiamdos por favor necesito contar las filas llenadas en una tabla , solo veo que se pueden sumar los valores, deberia existir uan formla que CUENTE las filas llenas indistintamente del valor, si es texto o numerico, lo unico que he encontrados en sus foros es como hacer un work aorund haciendo cientos de de campos calculados con campon ocultos para contarlos , eso es demasiado engorroso , tengo demasiadas preguntas para hacer eso por cadea una
-
Arghya Jotform SupportFecha de respuesta 28 de junio de 2024, 12:17
Hi Jesus,
Thanks for reaching out to Jotform Support. 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.
Let me get back to your question. If I understand you correctly, you want to calculate cells in your table. You can do that by creating an Advanced formula in your table. Let me show you how:
- In Form Builder, click on Dropdown icon beside the Jotform Logo.
- Select Tables and go to last column.
- Click on +Add, and click on Formula tab.
- Select Advanced Formula, and click on Next.
- Now, enter Column Name and click on Next.
6. Now select IF function, and set up your formula. You can add an IF function for each field.
7. After that you can easily identify if there is a missing field in that row or not.
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 how it goes.