Custom Worksheet FormulasLegacy platform
SpreadsheetWEBUserInfo
This function displays SpreadsheetWEB user info such as email or role, as they were set during account creation, or from the My Account page.
Works in Converted Applications and Designer Applications
This function displays user information of an application. Information type is determined by the FieldName parameter. FieldName parameter should match the field name in the database.
Predefined field names:
- UserName
- SiteId
- FirstName
- LastName
- Active
- Role
- Group
SystemAdmin user can add custom fields, such as “Phone Number”. Please note that you need to use an opening quote mark on the beginning and the end ("Field"). For example,
To return the user’s first name:
=SpreadsheetWEBUserInfo("FirstName")
To return the user’s phone number:
=SpreadsheetWEBUserInfo("Phone Number")