Referenced calculated key is displayed partially

AppSheet AppSheet Q&A
,
1

Hi,
I have the following issue on which I could not find the answer so far. I would really appreciate any ideas how to solve it.
Description:
I two tables: [Contacts] and [Log]. [Contacts] has a calculated key of two concatenated columns: “Name” and “Position” — CONCATENATE([Name], ": ", [Position]) —. I am referencing this from [Log] table (log of contacts for better understanding) with a column named “Name and position”.
Problem:
When displaying [Log] table in the app, “Name and position” is displayed only partially, more precisely: only “Name” seems to appear. Interesting that when adding new record to [Log] by an Appsheet form, it would be saved the desired way to the data source as “Name and position”, but afterwards still displays only “Name” in Appsheet when looking at values of “Name and position”. Also when using a form to add a new record to [Log], the dropdown list shows only “Name” attribute instead of “Name and position”, but shows multiple of them when positions are different.

Many thanks for any ideas,
Istvan

2

It sounds that currently [Name] column is assigned as label in “Contacts” table

If so, please make your concatenated key column in the " Contacts" table as Label column also apart from being the key column.

You will then see both name and position in the “Log” table as well.

2 Likes
3

Thank you so much, it worked!

1 Like
4

Thank you for the update.

Please go through relevant help articles

Basically in table references, in the app, for the reference columns, the user friendly labels are displayed in place of keys wich are many times cryptic such UNIQUEID()

sample app

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

2 Likes