Filtering a database return with a dropdown

Need help Database
1

Hi, can anyone tell me how to filter a database returned to a repeating group using a drop down as the input?

If I use a standard input it works fine, but I dont want users typing the filter term. I want them to only be able to search a term currently stored in the database.

For example I have 8 suppliers products in the database, I want to see all products supplied by CompanyA, I can type ‘CompanyA’ in and it finds them. But now I want to change the Input method to a dropdown that will only show companies in the database. I have the dropdown menu working fine I just cant get the repeating group filtering working with that type of input.

Thanks All

2

It works with a dropdown exactly the same way as it does with with any other type of input… i.e. just use the dropdown’s value in the search constraint.

So I’m not sure what you mean when you say you can’t get it working.

What exactly are you having trouble with?

3

Thanks for your reply, the first image is with me using the input at the top left where I have to type what I want. This works…

Filter 1
Filter 12232×1150 163 KB

This next image is where I change the text input to the dropdown, the cell just below. all I am changing is where the workflow looks at for the criteria.

Filter with dropdown
Filter with dropdown2152×1220 154 KB

That doesn’t work.

Thanks

4

There’s obviously a type mismatch…

So make sure the type of the field matches the type of the input (dropdown)