Combining formulas on one field
Is there a way to combine or have the following 2 formulas on one field? I am currently using 2 fields with Dynamic Form Rules on when to show one over the other. Current Formulas in 2 Separate Fi...
Forum Discussion
I think I am understanding you...the CRUISE CLUB field is a required field and it will be filled with one of the values listed. I can make it not required because I am the only one with access to the table...I just pull data from that table into the customer table.
Thanks,
Kim
------------------------------
Kim Cameron
Admin/Sales
Vacation Tour & Travel
Conway AR
15013295434
------------------------------
Thanks,
Kim
------------------------------
Kim Cameron
Admin/Sales
Vacation Tour & Travel
Conway AR
15013295434
------------------------------
Try these:
If(Contains(List("HL","ASC","ANC","TT","CruzVTT","TAN"), [CRUISE CLUB]),"ACTIVE","INACTIVE")
If(Contains(List("GRT","RWP","VSA"), [CRUISE CLUB]),"CXL-ENROLL IN CRUZVTT")
------------------------------
Paul Peterson
------------------------------
If(Contains(List("HL","ASC","ANC","TT","CruzVTT","TAN"), [CRUISE CLUB]),"ACTIVE","INACTIVE")
If(Contains(List("GRT","RWP","VSA"), [CRUISE CLUB]),"CXL-ENROLL IN CRUZVTT")
------------------------------
Paul Peterson
------------------------------
- MarkShnier__You
Qrew Legend
I think that the formulas should be
If(Contains(List(",", "HL","ASC","ANC","TT","CruzVTT","TAN"), [CRUISE CLUB]),"ACTIVE","INACTIVE")
If(Contains(List(",", "GRT","RWP","VSA"), [CRUISE CLUB]),"CXL-ENROLL IN CRUZVTT")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
