Forum Discussion

KimCameron2's avatar
KimCameron2
Qrew Trainee
5 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 Fields:
If(Year([Maximum Current Contract Date] )>=Year(Today()),"ACTIVE","INACTIVE")
and
If([Maximum Current Contract Date]<AdjustYear([Maximum Current Contract Date],1),"ACTIVE","INACTIVE")

And what I would like is something "like"- I know the following is NOT written correctly:
If([CRUISE CLUB]="HL","ASC","ANC)and(Year([Maximum Current Contract Date] )>=Year(Today()),"ACTIVE","INACTIVE")
If([CRUISE CLUB]="TT","CruzVTT","TAN")and([Maximum Current Contract Date]<AdjustYear([Maximum Current Contract Date],1),"ACTIVE","INACTIVE")

Also, what would really make my day even better :) is if it could also have this (which again is NOT written correctly):
If([CRUISE CLUB]="GRT","RWP","VSA"),"CXL-ENROLL IN CRUZVTT"

There may be a better way of doing all of this and I am very open to any suggestions.  

Thank you,

​

------------------------------
Kim Cameron
Admin/Sales
Vacation Tour & Travel
Conway AR
15013295434
------------------------------
Formulas and functions
  • PaulPeterson1's avatar
    PaulPeterson1
    Qrew Assistant Captain
    5 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's avatar
      KimCameron2
      Qrew Trainee
      5 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's avatar
        PaulPeterson1
        Qrew Assistant Captain
        5 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
        ------------------------------