Using User Hash Variable in Calendar Menu

 
1
0
-1

Hi,

In my calendar form there is a field called 'Staff Name' (c_staff_name) that stores the username value.

How do I use hash variable to display the Staff Name in First Name and Last Name format in the event title?

I tried the following format but it's not showing properly in the calendar ('#user.{staff_name}.firstName# #user.{staff_name}.lastName#') 

Please help to advice.


    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      I don't think the hash variable will work in an expression column.

      Instead JOIN your table on username to the "dir_user" DB table to get the first/last name into the selection, and use "CONCAT(d.firstName, ' ', lastName) as title" function to build the title description. See Advanced Form Data Binder#ExpressionColumns.

        CommentAdd your comment...