SpreadsheetWebRecordInfo

Created On
byIlker Burhan
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:

=SpreadsheetWEBRecordInfo(“AssignedUserName”)

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

=SpreadsheetWEBRecordInfo(“LastUpdate”)