Check if no error then only show one field

rrhirani
Participant IV

I have 3 Column fields in the form. A, B and C.

I need to show C field if And B has valid value means no error message for A and B.

AND(ISNOTBLANK(A), ISNOTBLANK(B)) will not work in my case because I have customized valid if for both A and B. Itโ€™s not only blank check but entered value I am checking with DB also. There are many conditional expressions for both A and B so for field C, I do not want to combine it and write again for C.

I need expression like, AND(ISVALID(A), ISVALID(B))

So it will be good if I can just check if A has valid value and B has valid value then show field C.

Any suggestions would be great.

0 3 494
3 REPLIES 3

Bahbus
Participant V

I believe youโ€™ll need to write a Show If expression for this C column that basically reinforces A and B Valid If.

So, assuming your Valid Ifs produce lists, perhaps something along the lines ofโ€ฆ
AND(IN([A], **SAME AS A's VALID IF**), IN([B], **SAME AS B's VALID IF**))

@Bahbus
Valid If returns true false only. I wrote the below code and it works great for me.
AND(true = **SAME AS A's VALID IF**, true = **SAME AS B's VALID IF**)

Thanks a lot for giving me the perfect idea.

In that case, just AND(A VALID IF, B VALID IF)

Top Labels in this Space