How do I select which column to reference with the ref type?

[Danielsntgd]

I keep trying to reference a specific column in another table and it automatically pics a column for me, (which I don't want). How do I manually  choose which column? (I'm new to appsheet)

[SkrOYC]

---

@Danielsntgd wrote:

it automatically pics a column for me

---

How?

[Danielsntgd]

The column in my table which gets referenced is always my Item name. I want it to reference my item barcode instead.

[SkrOYC · Accepted solution]

Are you talking about labels?

Add row labels - AppSheet Help

[Danielsntgd]

I had no Idea what the label meant. I thought ref was referencing one column since my label was set to the column I originally wanted to reference.

[SkrOYC]

Ref columns hold the whole row of another table by saving the key value of that row, so you can then dereference any of their columns via dereference expressions like this: [Ref].[Value]

References between tables - AppSheet Help
Dereference expressions - AppSheet Help