Hi, we are building a dictionary that using the Fund name will populate the Campaign name, see chart below but to avoid having to update this every fiscal year we would like to use a contain expression
Current Solution (need to update every year)
IF Fund is: FY15 Membership/FY16 Membership/FY15 Annual Fund/FY16 Annual Fund
THEN Campaign is: Membership
&
IF Fund is: Founding Member Camp
THEN Campaign is: Capital Campaign2015
Ideal Solution, no updates needed EVER!
IF Fund Contains: Founding
THEN Campaign is: Capital Campaign2015
&
IF Fund Contains: Mem
THEN Campaign is: Membership
IF Fund Contains: Ann
THEN Campaign is: Membership
SIMILAR CASE WITH LETTER CODES
Current Solution (need to update every year)
IF Fund is: FY15 Membership/FY16 Membership/Founding Member Camp
Ailen Pedraza
Hi, we are building a dictionary that using the Fund name will populate the Campaign name, see chart below but to avoid having to update this every fiscal year we would like to use a contain expression
Current Solution (need to update every year)
IF Fund is: FY15 Membership/FY16 Membership/FY15 Annual Fund/FY16 Annual Fund
THEN Campaign is: Membership
&
IF Fund is: Founding Member Camp
THEN Campaign is: Capital Campaign2015
Ideal Solution, no updates needed EVER!
IF Fund Contains: Founding
THEN Campaign is: Capital Campaign2015
&
IF Fund Contains: Mem
THEN Campaign is: Membership
IF Fund Contains: Ann
THEN Campaign is: Membership
SIMILAR CASE WITH LETTER CODES
Current Solution (need to update every year)
IF Fund is: FY15 Membership/FY16 Membership/Founding Member Camp
THEN Letter Code is: Mem
&
IF Fund is: FY15 Annual Fund/FY16 Annual Fund
THEN Letter Code is: Ann Fund
Ideal Solution, no updates needed EVER!
IF Fund Contains: Mem
THEN Letter Code is: Mem
&
IF Fund Contains: Ann
THEN Letter Code is: Ann Fund