Hi I am trying to create VC list with a simple deference list expression. The expression is like so [Ref column][Deref column]
My expression parses the correct data but when I try to change the elemental type of the list to a ref it doesnโt take (it just reverts back to text).
I have also tried changing the column type to enumlist and the base type to a ref. The editor allows me to do so but the reference doesnโt go through.
Any suggestions?
What is the column type of Deref column?
cannot be a ref type, as
[Ref column] is itself (and the only possible for that table) ref type.
What is the column type of Deref column ?
It is a Ref type as well
Ok, it is possible that (a ref enumlist derived from a ref by dereferencing) may not be supported yet. I would send it to support or wait for someone from AppSheet to confirm if it is or if there is a workaround.
@Aleksi?
I am bringing @QREW_Ben because he is assisting me with this
I think this might be similar to:
Yep @Marc_Dillon. Your right I am trying to achieve the same thing as @teambelair and I am having the exact same issues. Does anyone know if this is a bug or expected behavior?
Just giving this a bump. I havenโt found a solution. Any luck @teambelair
Try as the App formula for a virtual column in table A:
SELECT(
table B[table C ref],
([_THISROW].[table A ref] = [table A ref])
)
Perfect! Thx Steve
I have not. Canโt find a way to create a ref list without a direct link.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |