I haven’t heard of it being sunsetted — it’s just an experimental hidden function I found a while ago. It may go away at some point though.
_DEREF(input, column) means take the input and extract the column from it as specified by
Table.Column notation. If not found, return blank. Think of it as forced query you have to resort to when Coda is acting up.
_DEREF(@SomeRow, Users.Name) is the same as simply writing
@SomeRow.Name in a formula, where @SomeRow is a row from the table Users. However, the function comes in handy when the first parameter does not resolve to a row from a correct table for some reason. This is exactly what happens above with
CurrentValue when the formula editor mistakenly reports
CurrentValue as a row from
Result and not
Shopify Backend table, and suggests you the wrong set of columns for autocomplete.
See here how formula editor says
CurrentValue is a row from the table
Result, while in fact it’s a row from
Shopify Backend, coming from
_DEREF(CurrentValue, [Shopify Backend].Price) still reports a warning, but it works.
Also, if a path (as defined by the 2nd param) isn’t found in the input object (1st param), the result won’t be a broken formula but simply blank.