Solved: Reference Column Does not Display in View - Page 2

rufusp · 09-12-2024 01:44 PM

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.

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!

View solution in original post