Slice virtual column with show up if not empty

Hi all I have a table master note, and create a table view for it

Phong_Lam1_0-1645005557381.png

 

For the  3 column [ID Customer],[ID log],[ID Members] (they are ref column of table customer, table Log and Table Members) how could I create a virtual column with the expression that will show one of these three column if they have value (the logic is only 1 of them on the row have value). So I don't have to create 3 columns [ID Customer],[ID log],[ID Members] on the table view but just 1 virtual column only.

Thanks !

0 8 541
  • UX
8 REPLIES 8
Top Labels in this Space