When extracting structured data from tables where record names, object names, or other string values are known, you can build cell references using the content of cells. These functions also work with other types.
Locate("a", #b)Find a cell with the unique value "a" within region #b. It will report an error if "a" appears multiple times in #b. Note that the first argument must be a value or be convertible to a 1x1 table.
LocateFirst("a", #b)If multiple cells contain the value "a" return the first one. Planarly searches for the cell by scanning the table from left-to-right and top-to-bottom.
LocateLast("a", #b)If multiple cells contain the value "a" return the last one.
The backtick operator, \\, also implemented as the Backtick() function, provides string quoting for cell contents containing spaces. For example, Monthly Payment or Std deviation.
Backtick works by encoding arbitrary strings into a simpler format. The simpler format is limited to alphanumeric characters and underscore ([_a-zA-Z0-9]). Spaces are replaced with underscores. Encoding is terminated when any symbol outside the limited character set is found.
The backtick operator and function are used for referencing data via strings such as in column headers and using them in Planarly formulas.
LookupKey(table,key)This is the functional implementation of the square bracket operator value accessor #a[key]. You can read more about it here.