Is it possible to change Values into Categories when creating cards?

acammy
acammy
in Archive

Comments

  • AS
    AS Coach

    Referring to data types, categories are text or date fields and values are numbers.  You can turn a number into text by using a CONCAT() function in a Beast Mode.  Something along these lines:

     

    CONCAT(`Organization_ID`,'')

    Add blank text to the end of a number and the output will be that number as a string of text instead of a numeric value.  Good for situations where you have customer IDs or employee IDs that you want to use in a filter (by checking specific IDs), but you can't because a number type won't let you pick multiple numbers.  That's where I've seen this tactic used.

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Unknown
    Unknown

    @acammy, did @AS's reply help you out?

Categories