I created a dropdown with dynamic values and the type of choices is not text but it’s work instructions. In the dropdown, names of departments appear and if I select a department, it redirects me to another page.
The issue is, In the dropdown the same departments name is appearing multiple times. I need one departments name to appear in the dropdown only once.
Help from bubble community is much needed.
Add :unique elements after the Search.
I added unique elements after the search. In the dropdown, the department corresponding to a work instruction appears. Is there a way to make each department’s name appear only once in the dropdown?
@NigelG @emmanuel @TipLister
When you use a DB type, the unique ID is the way for Bubble to set unique element… this mean that all items are unique!
Instead, you need to choose Type of choices to be “Text” and use Search for work instructions’s department:unique elements
Thank you for the help
Thanks for your help.
When my users click on a department’s name in the dropdown, I need them to be redirected to the page corresponding to that department. This workflow is not happening if I keep type of choices to be text. This workflow is working if I keep type of choices to be work instructions but in this case I’m not getting unique elements in the dropdown.
Any clue how to solve this?
@NigelG @TipLister @emmanuel @Jici
You will need to use a Doa search and search using filter on the Department = Dropdown value.
However, I think you should review your DB setting to either use a DB Type for the Department or an Option set.
Thanks for the reply. But I can’t use an option set here because different users have different departments. I also tried making department as a DB type but even then it doesn’t work. Can you please help?
This topic was automatically closed after 70 days. New replies are no longer allowed.
