Using User Hash Variable in Calendar Menu

Confluence User - 22 Feb, 2023

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.


hash-variables

1


24 Feb, 2023
confluenceUser
1
confluenceUser

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.

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print