CONTAR LAS FILAS LLENADA DE UNA TABLA

  • jesusbitter
    Fecha 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 Support
    Fecha 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:

    1. In Form Builder, click on Dropdown icon beside the Jotform Logo.
    2. Select Tables and go to last column.
    3. Click on +Add, and click on Formula tab.
    4. Select Advanced Formula, and click on Next.
    5. Now, enter Column Name and click on Next.

    CONTAR LAS FILAS LLENADA DE UNA TABLA Image 1 Screenshot 40

    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.

    CONTAR LAS FILAS LLENADA DE UNA TABLA Image 2 Screenshot 51

    CONTAR LAS FILAS LLENADA DE UNA TABLA Image 3 Screenshot 62

    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.