Conditional formatting for many fields

[jo]

I have a series of buttons that serve as navigation between views in a
form. I want to set up conditional formatting so that if a set of
fields are blank, the button is red, indicating the section is not
complete. However, I need to reference more than the 5 or 6 fields that
the conditional formatting dialog allows. How can I make the formatting
dependent on a higher number of fields?

Thanks.

 

[Kalyan Reddy]

Hello Jo,

Suppose you have six fields in the form, open the button proerties Display->
Conditional Formatting. In The conditional Format window select The
expression in the First Window and then Put this formula
(my:field1 = "") or (my:field2 = "")or (my:field3 = "") or (my:field4 = "")
or (my:field5 = "") or (my:field6 = "")

You can put any number of fields in the formula

I hope this helps you.

 

[jo]

Let's say I need to reference 20 fields. That window has an upper limit

 

[Kalyan Reddy]

Hello Jo,

Suppose you have 20 fields in the form, open the button proerties Display->
Conditional Formatting. In The conditional Format window select The
expression in the First dropdown and then Put this formula

(my:field1 = "") or (my:field2 = "")or (my:field3 = "") or (my:field4 = "")
or (my:field5 = "") or (my:field6 = "") or (my:field7 = "") or (my:field8 =
"")or (my:field9 = "") or (my:field10 = "") or (my:field11 = "") or
(my:field12 = "") or (my:field13 = "") or (my:field14 = "")or (my:field15 =
"") or (my:field16 = "") or (my:field17 = "") or (my:field18 = "") or
(my:field19 = "") or (my:field20 = "")

You can put any number of fields in the formula

I hope this will help You.