Use data in antoher table as label

[SyDyJo]

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

[Aurelien]

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

IF() - AppSheet Help

[SyDyJo]

But  [FirstName] & " " & [LastName] is data to another table

[Aurelien]

Then you may want to use a dereference expression: 

IF(
  [Family_yesno],
  [ColumnThatRefersToAnotherTable].[FirstName] & " " & [ColumnThatRefersToAnotherTable].[LastName],
  [Address
)

For reference:

Dereference expressions - AppSheet Help