Variable to map values

Useful to show user friendly label instead of technical value (for example a field name store in variable).

set v_MapLabel =
Pick(Match('$1', 'FromValue1', 'FromValue2', 'FromValue3')+1
  ,'DefaultToValue'
  ,'ToValue1'
  ,'ToValue2'
  ,'ToValue3'
);
=$(v_MapLabel($(v_RawValue)))

Be the first to comment

Leave a Reply

Your email address will not be published.


*