How concatenate list column fields to a display field for a popup select box

 
1
0
-1

I would like to concatenate three fields to one display field in a popup select box. I'm not experienced with beanschell scripting and hash variables.

    CommentAdd your comment...

    2 answers

    1.  
      2
      1
      0

      You can use SQL script to do that

      E.g

      Concat script
      SELECT t.id, CONCAT(t.firstname, ' ', t.lastname)FROM table1 t


      1. Fronsky

        Can you advise where to place this?

      2. Anas Misbah Shami

        You can use SQL query to load the selectbox

      CommentAdd your comment...
    2.  
      1
      0
      -1

      Thank you. Where do I place that script? In the beanshell of the new displayfield in de list?

      Sorry I'm not that experienced

        CommentAdd your comment...