We’ve made two extensions to TeamDesk.

First, formula runtime has been extended with Role() function. Role() function returns the role name for the user specified as its argument. Called with no arguments, current user is assumed. This allows to provide conditional calculations based on user’s role. One of the applicances is providing different default column values for different roles.

Second, summary column has been extended with concatenate function. Concatenate, as the name implies, joins the values of the text columns in detail records, separating them with comma. Please note, however, that the length of the result string should not exceed 4000 charachters otherwise error occurs.