Ref column dropdown

AppSheet AppSheet Q&A
1

Hi all.
I have a table that has a Ref column that references a table with a key column that is a concatenation of:
Brew date-Brew name-Batch Number

When I use the dropdown to create a new record all I can see is the Brew Name to select from without the date or the batch number.

This is obviously a pain since there are multiple brews with the same name but what makes them unique is the date it was brewed and the batch number.

If I just select one, the result in my spreadsheet is the full computed key.
It just seems to be what is shown in the dropdown to select the referenced row.

2

I believe in your parent table the label column assigned is [Brew Name]

Please assign the concatenated column of Brew date-Brew name-Batch Number as label column and test.

1 Like
3

Yep that did it. So simple and I had tried that but on the wrong column previosuly.
Thanks for that.

1 Like
4

You are welcome!
You may wish to browse the following sample app and help article to know how labels get displayed in the reference dropdowns.

https://www.appsheet.com/samples/This-app-shows-the-difference-between-keys-and-row-labels?appGuidString=53280014-1d95-4d1f-93e5-a2a2e9be53a5

1 Like