I have added 2 references to 2 tables but when I get the report the references item has a number not the text that I need. How can I get the reference to output the text?
Hi,
Generically, if your report has something like [ReferenceField] and itโs the โnumberโ as you say, but you want another field on that ref/table like โdisplaynameโ then please change it to
[ReferenceField].[displayname]
and see if that works for you?
I am sorry I said report but it is actually on a form in AppSheet it shows number 20 instead of Job12.
User | Count |
---|---|
63 | |
25 | |
14 | |
11 | |
6 |