I have tables Participants, Roles
Participants has VC of type List(Ref(Roles)) โThis User Role Dataโ = FILTER(Roles, [Email] = USEREMAIL())
Participants has VC of type List(Text) โThis User Orgsโ = [This User Role Data][Org]
Roles:
Email Org
a@a.com orgX
a@a.com orgY
b@b.com orgX
b@b.com orgZ
When I show these two VCs previewing the app as a@a.com:
โThis User Role Dataโ =
a@a.com orgX
a@a.com orgY
โThis User Orgsโ =
orgX,orgX
What is going wrong that โThis User Orgsโ isnโt orgX,orgY?
Solved! Go to Solution.
I had not included the Org column as part of the key in the Roles table, that solved it
I had not included the Org column as part of the key in the Roles table, that solved it
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |