counting fields which contain specific letter

Question

HiI have a form which has a series of different fields called "1st", "2nd", "3rd" etc all the way to "31st". The user is prompted to add either "ab" or "s" or a number to reflect the number of hours worked on the day or whether an employee was sick (s) or absent (ab).The calculation for adding up the number of hours worked across the month is simple.How do i add a custom calculation to add up the number of fields which either contain "s" or "ab"?Cheers

try67 · Accepted Answer

Sure. You can use this code in that case:

var fields = ["1st", "2nd", ... , "31st"]; // replace "..." with the rest of the field names
var total = 0; 
for (var i in fields) { 
    var f = this.getField(fields); 
    if (f.valueAsString=="s" || f.valueAsString=="ab") 
          total++; 
} 
event.value = total;

try67 · Answer

This kind of naming scheme is not so good, because it's not very consistent. If you change it to something like "Hours1", "Hours2", "Hours31" then the code to do it will be much simpler.If that's the case then you can use this code as the custom calculation script of the field where you want to show the result:var total = 0;for (var i=1; i<=31; i++) { var f = this.getField("Hours"+i); if (f.valueAsString=="s" || f.valueAsString=="ab") total++;}event.value = total;If you leave it as you have it now then you'll need to hard-code the names of all of those fields in your code.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.