Distinct into values in a list

Get Help
1

Hi everyone,

I am trying to display a list of duplicate users. I need to do a Distinct(users) on the data, but I don’t see a function that allows me to do it, how can I develop it?

Thank you

2

Hello, can you please explain more, so I can give you the right solution for your issue?

Thank you!

3

Hi @gonza,

You mean the users that appears more in a collection? Could you explain more? :slightly_smiling_face:

Thank you

5

Hi Ali, thanks for the support. I have answered below with more details.

Thanks!

6

Hello Dilon!

I have duplicate records in the database (that are differentiated by a date and time field) which is correct, but I need to keep only the last associated record, it even helps me to do a MAX to the datetime field, but I can’t find the Distinct or MAX functions to remove those duplicates to display it in a list with no duplicates.

What do you recommend?

7

Hi Gonzalo,

Thanks for the information. As far as I’m aware there’s now way to filter the list to not show duplicates. But you can add a way to not make duplicates in the collection. Check these videos : Adalo Hints: how to prevent from creating duplicate records in the collection - YouTube , Adalo Prevent Duplicate Records & allow user to update existing record instead. - YouTube

And also you didn’t prevent duplicates because you need them? What’s this collection used for?

Thank you

1 Like
8

Thanks Dilon, I´ll see this solutions and I will give you feedback. thanks!

1 Like
9

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.