Does appsheet have unique() formula like google spreadsheet?

[alex_gibson0111]

Please help me, i want to create filter data type ‘list’, with formula unique(),
does appsheet have unique() formula like google spreadsheet?
example like in the picture

[Steve]

help.appsheet.com

UNIQUE()

Unique items in list

[alex_gibson0111]

can the unique() formula be combined with the if formula?
I want to filter by useremail or some other column

[Marc_Dillon]

Yes, you can use expression together. If you do it right. What does “combined” mean in this case? What exactly are you wanting to filter, and how?

[alex_gibson0111]

I want to filter the data so that it is not duplicated, I use the formula unique(filter(orders,[order id]=[bill id])) but nothing happens, what should I add in my formula ?

[Marc_Dillon]

alex_gibson011186:

I want to filter the data so that it is not duplicated

https://community.appsheet.com/search?q=prevent%20duplicate