I created a dereference to a table, containin...

[M_Engel]

I created a dereference to a table, containing - among others - names and photos. The names are supposed to be shown in the dropdown of the ‘ref’ field, but for some reason I only get photos. How do I fix this?

[M_Engel]

I added a UniqueID value. Now it’s this value that shows up. Still no name? What’s going on? I don’t understand

[Henry_Scott]

Tick the box named “Label” against the Column containing the Names

[M_Engel]

Sorry, but that makes no difference. Still getting only ID

[M_Engel]

Finally, got it. Thanks for the advice. I had to remove the spreadsheet formula and replace it with an appsheet formula and THEN tick the box named ‘label’, but now it’s working. I even get photos AND names!!

[Henry_Scott]

Good news