Reference showing number not the text

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?

0 3 257
3 REPLIES 3

TyAlevizos
Participant V

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.

Top Labels in this Space