Looking for the equivalent of UNIQUE

Wappler General Need Help
1

Hi,

I am working through some basic principals trying to get more familiar with wappler - hoping you can help me!

I have a list of car makes that is being pulled from my database. These appear to the user as a custom select dropdown. I have managed to make the dropdown display the makes from the DB but it is listing the make from every record. Normally (as in, using something like google sheets!) I can just use UNIQUE to turn that list into a list of unique values. How do i do this in Wappler? I tried clicking the wand button to look at the operations available but its not obvious to me what I do next - can someone point me in the right direction?

2

It’s called ‘Distinct’ in Wappler …

53%20AM
Screen Shot 2019-08-30 at 9.03.53 AM.png1186×764 53.5 KB

3

That worked - thanks! I didnt think about doing a separate query, was too busy trying to modify my existing one :slight_smile:

Cheers!

1 Like
4

You should probably have a table just for the car makes and pull it from there.

You probably want to check about database normalisation.

It might seem daunting at first but it’s quite easy to understand. And if you apply normalisation you will avoid yourself some headaches in the future.

https://support.microsoft.com/en-us/help/283878/description-of-the-database-normalization-basics

2 Likes