Exception Formula in Label does not work

Dear friends,

I create Virtual Label column to display flexible information depends on View and Viewtype on other screens but it's not work as expressions in attached image

2023-09-13_113438.png

Note: Lable of the table include Image column and Virtual label column.

Please help me with this issue. Many thanks!

 
 
 
 
 
Solved Solved
0 4 78
1 ACCEPTED SOLUTION

If you are using a virtual column for virtual label, then please note that the CONTEXT() functions do not work reliably  in the virtual columns.

CONTEXT() - AppSheet Help

Suvrutt_Gurjar_0-1694582658540.png

 

View solution in original post

4 REPLIES 4

If you are using a virtual column for virtual label, then please note that the CONTEXT() functions do not work reliably  in the virtual columns.

CONTEXT() - AppSheet Help

Suvrutt_Gurjar_0-1694582658540.png

 

Dear Suvrutt_Gurjar

Many thanks for your note. I think the issue is caused by the system misunderstanding my expression as in the example in the image below. The result returns [Price] while the view is "Produce details_Form". The data is still there but the logic is wrong.

2023-09-13_140826.png

As mentioned, the CONTEXT() will not work in the virtual columns. Please verify if you are using virtual column as the Virtual Label column. The reason why it will not work in virtual columns is explained well in the article.

Many thanks, Suvrutt_Gurjar, this is a virtual column. I understand your reply.

Top Labels in this Space