Javascript Count If Formula needed


i trying achieve following:

i have 4 fields.

 

the first 3 fields might have text entries in them (or blank).

 

in fourth field, need able add number field if string appears in first 3 fields.

 

e.g. 

field 1 = m

field 2 = la

field 3 =

 

field 4 should able add 1 it's value if fields 1-3 contain la. 

 

i cannot simple count here because field 4 going multiple times multiple sets of fields.  also, need able add 1 if la appears twice in set of fields.

 

if can me started, think can rest figured out.  thinking need countif statement produce number first 3 fields , if statement add number fourth field's value dependent on result of countif.  getting in weeds how value produced countif if statement.

 

would appreciate help!

you need write custom javascript calculation. how (not simple) form calculations thom parker.

 

you have issues lower case letters or mixed case letters, , need work out logic.

 

javascript mdc

acrobat javascript documentation



More discussions in PDF Forms


adobe

Comments

Popular posts from this blog

Warning, the Safe Path is not accessible vm3 - Joomla! Forum - community, help and support

uppercase letters in url - Joomla! Forum - community, help and support

Joomla! Update is not offering Joomla 3 - Joomla! Forum - community, help and support