Swith expression Beetween tables

Hi, i am in need of some asistance, hehe!

I have a table called MOVIMIENTOS, in wich i have a column named PAGO, wich is set as color tipe (red, green, yellow).
On the othe hand i have a table called COLOR, in wich i have a column called IMG_COLOR, in wich i have the images of those colours (it is set like that to take it for a Deck view of MOVIMIENTOS table)

What i want to achive is that when the PAGO column in MOVIMIENTOS table is set in green, a virtual column, wich i could called COLOR DECK and set as image type, takes the colour of the table COLOR referred to green, wich in this case would be the valor of id=6bb5249d
I found some info about this aproach in the next post, but i cant figured it out...

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Is-there-any-way-to-show-a-Progress-column-as-t...

Solved: Select Unique Values From Child Table with Switch - Google Cloud Community




JPAN_0-1694790881279.png

JPAN_2-1694790982540.png

 

 

 

0 3 103
3 REPLIES 3

Why not make the PAGO column a Ref to the COLOR table?

I allready did, and i didnt realize to utilize a lookup() expression. Thanks for avery answer Marc!

You don't need LOOKUP() if you have a reference.

https://help.appsheet.com/en/articles/1090811-dereference-expressions

Top Labels in this Space