Is there a quick way to get the value of a cell in a Reference column, instead of its id?
Currently, I need to add a function each time to do a lookup in the reference table by id to get the value.
Would be good if it would return the value instead by default, or simply by adding .value (or similar) to it.
Even better would be to be able to return the value from another cell for that record with the same approach.
So for example, if my reference table
Country (with list of countries) includes:
Contact table has a reference to it,
contact.country would return the id (current/default)
contact.country.name would return country name (display name)
contact.country.code would return country code