Hello guys! I have a table "Produtos" with tw...

(Pedro Paulo Sant'Anna) #1

Hello guys! I have a table “Produtos” with two EnumLists and one Text column types. When I refer these columns in “Serviços X Produtos” I have problems of types, only Text column works fine if I refer as EnunList. Someone can help me?

(Aleksi Alkio) #2

We can’t use List field type in normal columns. In the other hand you can’t read multi values like that either. You can do that if you read values first in the virtual column and then call that list in Valud_If.

(Pedro Paulo Sant'Anna) #3

Is there any example about this?

(Aleksi Alkio) #4

I don’t believe… or at least I haven’t seen any.

In virtual column use SELECT(Table[Column],[ColA]=[_THISROW].[ColB]) and then call that virtual column just like [VirtualColumnName] in Valid_If.

(Pedro Paulo Sant'Anna) #5

Thank you @Aleksi_Alkio! Translate

(Pedro Paulo Sant'Anna) #6

@Aleksi_Alkio, I used SELECT() and a list was created, but if I use a Table UX grouping by these virtual columns, I do not have the right effect.