SpreadsheetWebRecordInfo

You are here:
Works inĀ Designer Applications only

 

The SpreadsheetWEBRecordInfo formula allows pulling data from the active record into the underlying spreadsheet. The information type is determined by the FieldName parameter. This parameter should match the column name for that field in the database.

Predefined field names:

  • Id
  • EditId
  • AssignedUserId
  • AssignedUserName
  • ActionUserId
  • ActionUserName
  • AssignedGroupId
  • AssignedGroupName
  • EntryDate
  • LastUpdate
  • StatusIndex
  • StatusName
  • Notes

Examples

To return the name of the owner of the active record:

=SpreadsheetWEBUserInfo(“AssignedUserName”)

To return the date-time information for when the record was last updated:

=SpreadsheetWEBUserInfo(“LastUpdate”)