SpreadsheetWEBUserInfo

You are here:

SpreadsheetWEBUserInfo(FieldName)

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
  • Email
  • Active
  • Role
  • Group

SystemAdmin user can add custom fields, such as “Phone Number”.

To return the user’s first name:

=SpreadsheetWEBUserInfo(“FirstName”)

To return the user’s phone number:
=SpreadsheetWEBUserInfo(“Phone Number”)