SpreadsheetWebRecordInfo

The SpreadsheetWebRecordInfo formula can be utilized to inject record-related information into your workbook, which can help you with tasks such as varying your logic based on new vs. existing record status, creation date, or even record status.

The syntax for the SpreadsheetWebRecordInfo formula is as follows:

=SpreadsheetWebRecordInfo("ParameterName")

The available parameters that can be retrieved into your workbook are defined below.

  • Id – This is the ID of the current record being accessed by the user. If there is no record, then this will evaluate to 0. Hint: This can be used to identify if the record has already been saved or not.
  • EditId – This is the iteration of the current record being accessed by the user. If there is no record, then this will evaluate to 0. If this is a new record and this is the first edit of the record, then the value will be 1. Subsequent edits will increase this value by 1 for each save.
  • EntryDate – This will provide the creation date of the record. If the record has not been created yet, this will return 0.
  • LastUpdate – This will provide the last update date of the record. If the record has not been created yet, this will return 0.
  • AssociatedTags – A list of tags that the data record is associated with. These will be provided in a format of {Text}: {Id};.
  • AssociatedTagNames – A list of tag names that the record is associated with. These will be provided in a format of {Text1}; {Text2}.
Previous DbConnect Function
Next SpreadsheetWebUserInfo