How does one count the number of filled fields in a table?

  • BrentR
    Asked on April 12, 2019 at 8:13 AM

    How does one count the number of filled fields in a table.  I am asking clients to enter details in a table, and would like to count the number of entries.  Would ne nice to be able to count filled and/or empty fields or cells.

    Thanks in advance!

  • Welvin Support Team Lead
    Replied on April 12, 2019 at 10:52 AM

    The input table in your form is currently set to Textbox type. Unfortunately, I find no way to count the field boxes this way. I'll find another way, but would you mind telling us first the table that you'd like to count? Is it for the form here https://www.jotform.com/90920932267561?

  • BrentR
    Replied on April 12, 2019 at 11:00 AM

    Hi


    Thanks!!  No, this one: https://form.myjotform.com/90922119277561


    I appreciate your assistance!



  • Welvin Support Team Lead
    Replied on April 12, 2019 at 12:33 PM

    I'm sorry, but I still cannot get it to work. A workaround here would be to ask people how many photos they would like to add, and show a corresponding table based on that number. In this case, you have to add 7 tables. 

    Here's a cloned version of your form with this method: https://form.jotform.com/91014553014949.

    The fields:

    15550867982019 04 13 003 Screenshot 10

    The condition:

    15550867772019 04 13 002 Screenshot 21

  • BrentR
    Replied on April 12, 2019 at 12:37 PM

    Thanks for the effort.  That is pretty much how I did it on the form.  Client inputs number, and I calculate the costs.

  • Welvin Support Team Lead
    Replied on April 12, 2019 at 1:39 PM

    You're welcome. 

    My form has a predefined number of tables, and each is shown based on the user input. 

    Please contact us again if we can help in any way.

  • BrentR
    Replied on April 12, 2019 at 2:00 PM

    Will do!  Thanks!