Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 11, 2022 03:15 AM
Hello, i’d read all discussions here to resolve my issue and nothing work, how i can get it done with this discussion :slightly_smiling_face:
for this i created two tables, one contain survey results and the second contain users entries, they add their profil and based on automation airable add via the linked field all similar profil, until this point all is good.
For one of the survey questions, i asked people for main daily missions they do (multiple select field), when i check the lookup or rollup field that get missions data from all result i see many missions many times, i would like to have unique values but seems impossible, i tried all tips that i found here :confused:
any advice please ?
Mar 11, 2022 03:37 AM
I’m not sure if I fully understand what you’re trying to do, but I think this will solve your problem:
In the users table, keep your lookup field that looks up the missions (i.e. the multiple select field). This lookup field might end up showing you many repeating missions for each user.
Then, while still in your users table, create a formula field that refers to that lookup field like this: ARRAYUNIQUE({Your Lookup Field})
That will show you only the unique missions for each user.
Mar 11, 2022 03:45 AM
thanks for the input here @ScottWorld !
i just add this formula but still showing me duplicated entries :confused:
Mar 11, 2022 03:46 AM
i am looking for the solution from last week :confused:
maybe i can share the table ‘inprivate’ to understand the structure ?
Mar 11, 2022 03:53 AM
Sure, or you can post screenshots here.
Mar 11, 2022 04:01 AM
I received your base via direct message.
As I mentioned above, you will need to create a formula field, and then use the formula that I wrote above, but substitute the name of your lookup field in the formula like this:
ARRAYUNIQUE({Missions lookup})
Mar 11, 2022 04:07 AM
tried too, i always see the duplicated values :confused:
check formula field value please =on same link
Mar 11, 2022 04:09 AM
its very strange, isnt a bug ?
Mar 11, 2022 04:10 AM
No, you haven’t created a formula field yet. You’ll need to delete your rollup field first, and then you’ll need to create a formula field.
Mar 11, 2022 04:11 AM
no i created a new field named “formula” please check !