Custom Worksheet FormulasLegacy platform
SpreadsheetWebRecordInfo
The SpreadsheetWEBRecordInfo formula allows user to pull in data about the current record into their spreadsheet for reference.
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:
=SpreadsheetWEBRecordInfo(“AssignedUserName”)
To return the date-time information for when the record was last updated:
=SpreadsheetWEBRecordInfo(“LastUpdate”)