5 Replies Latest reply: Nov 26, 2014 2:38 AM by Dominik von Francois RSS

    How do I show a number as a Text counterpart ?


      Hello ,

       

      I have a simple list box and added one field from a SQL database. On display, the box shows 3 rows ;

       

      1

      3

      20

       

      I would like to display BIRD instead of 1, CAT instead of  3 and DOG instead of 20 . Maybe I can use an expression ? Like match('1' , Fieldname, 'BIRD') or something ?