Forum Discussion

Qrew Trainee

6 years ago

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...

Formulas and functions

Qrew Assistant Captain

6 years ago

For your first case:

If(Year([Maximum Current Contract Date] )>=Year(Today() and
[Maximum Current Contract Date]<AdjustYear([Maximum Current Contract Date],1),"ACTIVE","INACTIVE")

For the other cases, are the values "HL","ASC","ANC", "TT","CruzVTT","TAN", and "GRT","RWP","VSA" all requires or any of the values is required?

------------------------------
Paul Peterson
------------------------------

KimCameron2
Qrew Trainee
6 years ago
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
------------------------------
- PaulPeterson1
  Qrew Assistant Captain
  6 years ago
  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
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    6 years ago
    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
    ------------------------------