Hello,
I would like to display data from my reference table :
I would like to display the first and last name of a family member as a label if the column representing family = yes instead of the address.
members is my referent table
Hi @SyDyJo
You may want to create a virtual column and use this one as a label.
Such expression could be:
IF(
[Family_yesno],
[FirstName] & " " & [LastName],
[Address
)
For reference:
Use virtual columns - AppSheet Help
But [FirstName] & " " & [LastName] is data to another table
Then you may want to use a dereference expression:
IF(
[Family_yesno],
[ColumnThatRefersToAnotherTable].[FirstName] & " " & [ColumnThatRefersToAnotherTable].[LastName],
[Address
)
For reference:
Dereference expressions - AppSheet Help
User | Count |
---|---|
35 | |
31 | |
28 | |
23 | |
18 |