FROMTAG
Extracts a field value from a single JSON tag object produced by TAG or TAGS spillover.
Syntax
FROMTAG(tag, fieldName)
Arguments
| Argument |
Description |
Required |
tag |
A JSON object string representing one tag. |
Required |
fieldName |
Field name to extract (case-insensitive). |
Required |
Examples
Extract a field from a tag object
=FROMTAG(A1, B1)
Result ⇒
John
| {"Name":"John","Age":"25"} |
Name |
Related Functions
Other Special Functions & Keywords functions:
- CELL - Current cell value in criteria formulas
- COL - Column value using COL[A] or COL[1] syntax
- CSV - Serializes a table to a high-precision CSV string (CRLF between rows). Trailing empty rows and columns are cropped; internal blanks are kept. Wrap the cell or increase row height to see every line.
- FROMCSV - Parses a high-precision CSV string into a spilled table. Inverse of CSV.
- ONCE - Returns the value of the inner formula and only executes once, turning the cell into a value
- ONCHANGE - Returns initial_value until the range changes, then returns value_after_change and converts the cell to a static value
- RECORDID - Salesforce record ID for this workbook
- TAG - Converts a 2-column key|value table (default) or 2-row key|value table into a single JSON tag object.
- TAGS - Converts a table with headers and rows into a JSON object array. There should be a "label" column and each row is rendered as a hoverable tag with that label.
- USERID - Current logged-in user's ID
← Back to Formula Reference