how the app work:
i have an app that scan somes QR’s
SO, a row (POS SPT) Scan the QR’s and another row (POS entregues) Concatenate these.
but if some one scan the same QR, my app concatenate it too.
i need a way to not concatenate if the value already exist.
Solved! Go to Solution.
Whoops! My mistake. Make it an EnumList type. Keep the column a normal (not virtual) column.
I suggest changing POS entregues to a List type instead of Text, then you could do this:
[POS entregues]
+ IFS(
NOT(
IN(
[POS SPT],
[POS entregues]
)
),
LIST([POS SPT])
)
when i change the type to list, it’s tell me that only virtual column can be list type.
So i need to create a virtual colum to get your appformula and set POS entregues to get the virtual colum value?
Whoops! My mistake. Make it an EnumList type. Keep the column a normal (not virtual) column.
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |