COUNT total fields that have entires

[melissa_3593]

I have looked through all the community posts and tried to edit examples to work on my document - but they do not work.  Please HELP 🙂

I have 40 fields that will have both numbers and text entered. 

The fillable text fields are named:

Room0

Room1

Room2

Room3

continuing and ending with Room39

In the field "Room Total" I need it to count the number of fields above that have an entry in it (not calculate the total, but count.)

[PDF Automation Station · Accepted solution]

Enter the following custom calculation script in Room Total field:

var count=0;
for(var i=0;i<40;i++)
{
if(this.getField("Room"+i).value)
{count++;}
}

event.value=count;

[melissa_3593]

I have never been so grateful for anything in my life 🙂

I have been fighting this for DAYS!

THANK YOUUUU!