sreese

Using a calculation field to show alternative field based on global field

Discussion created by sreese on Jun 30, 2016
Latest reply on Jun 30, 2016 by sreese

Sorry, I know the Title is a mouthful.

 

I'm pondering an idea, and I'm not 100% sold on doing it because I fear performance issues.

 

I am pondering having 3 calculated fields to display a name in different ways

 

Field 1 - No Filter applied = Clothing - Shirt - Fatigue

Field 2 - Filter (Clothing) Applied = Shirt - Fatigue

Field 3 - Filter Clothing - Shirt Applied  = Fatigue

 

What I am thinking for field 4 is for a portal -

Field 4 -

If ( isempty ( filter1) ; Show field 1 ;

  if ( isempty (filter2) ; show field 2 ; show field 3 ))

 

The reason I am thinking of doing it this way is so I only have to put 1 field in the portal rather than hiding the other fields.

 

Any thoughts? If you don't like it please tell me why and give me your thoughts. I am not married to this idea at all.

 

Thanks!

 

Scott

Outcomes