Reference Column Does not Display in View

[rufusp]

All tables in this app are in an AppSheet database. I have a table named ‘Projects’ with a column called ‘Owner’ of type ref that references table ‘Team’. Table ‘Owner’ has two columns called ‘Photo’ of type Image and Name of type ‘Name’.

In the ‘Projects’ table I have two Virtual columns

• Owner Photo, Type Image, Formula = [Owner].[Photo]
• Owner Name. Type Name. Formula = [Owner].[Name]

My view of Card Type for table ‘Projects’ does not display ‘Owner Photo’ or ‘Owner Name’.

Any help would be greatly appreciated.

[Steve]

Is the card view configured to use those columns?

Are the columns configured with Show? on or with an expression that evaluates to TRUE?

Do the columns have values?

Please post some screenshots showing the problem and related configuration.

[rufusp]

This is the Team table

This is the project table

This is the Team table data

Thanks!

[rufusp]

Steve, Please ignore this thread. I found the error!!!. The email address, which is also the key, in the team’s table had an extra character. I fiexed the email address and it now works.

Thanks!

[Steve]

Nice!