Reference Column Does not Display in View

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.

 

 

Solved Solved
0 4 196
1 ACCEPTED SOLUTION

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

4 REPLIES 4

Steve
Platinum 5
Platinum 5

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.

This is the Team table
rufusp_0-1726174376572.png

This is the project table

rufusp_1-1726174462279.png

This is the Team table data

rufusp_2-1726174571404.pngrufusp_3-1726174588792.pngrufusp_4-1726174692172.png

Thanks!

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!

Nice!

Top Labels in this Space