Get record name from Ref Field for Document variable?
How can I extract the record name for an item id that was selected from
reference field to show in a document variable?
I had a ref field that is constrained by a select () valid if to show paints from a material table and the field shows the correct info and name in the app but when I use the document variable for that field, I get the Material ID (key) and not the name.
The only way around this was to create a virtual column that derefs the name of the record. Would love to avoid having to create a bunch of virtual columns to just get the names for the doc.
There is already a lot of columns and don’t want to slow the app any further.
Thank you very much for any help with this