More than one label in Ref list

[casitasrd]

Hello there. Is it possible to use 2 columns as label? I have an issue where in a ref list sort by names, I cannot differentiate who is who. I would like to differentiate the two Elvis for intance. I would like to add either the last name or the license number along with the name.

[Suvrutt_Gurjar · Accepted solution]

In general you could create a concatenated VC such as

CONCATENATE([First Name], " ",[Last Name])

or

CONCATENATE([First Name], “-”,[License Number])

and assign the concatenated column as the label.

[casitasrd]

Thank you so much Suvrutt! It worked!

[casitasrd]

@Suvrutt_Gurjar … I just notice an issue that this has created in the app. When making CONCATENATE([First Name], " ",[Last Name]) as the label, now related stuff about the contacts do not show up. For intance, in the next picture it should show the related receipts for this contact, and now it’s now showing after making this changes.

[Suvrutt_Gurjar]

Not sure the label column should create the issue. Referenced and dereferenced ( children and parent) records are referenced by the keys on both sides - parent and child.

[casitasrd]

you are right. The only thing i needed to changed was the reference table to the client.

[SyDyJo]

is it possible to hide the concatenated column in the create and update of the form?

[Suvrutt_Gurjar]

Yes, you can do so using CONTEXT() expression, something like

CONTEXT("ViewType")<>"Form"

CONTEXT() - AppSheet Help