SpreadsheetWEBUserInfo

You are here:

 

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”. 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")