Hey Guys!
I’m autobinding a dropdown to a field in the DB.
Within the field there are a number of entries that I’d like to :Group by but I’m unable to achieve this as it kicks the autobind funtionality out when I select :Group by at the end of the string.
Any ideas how I can get around this another way?
Appreciate any help
Update - also tried :unique elements but doesn’t work
@J805 thanks for the reply but no unfortunately it’s not 
The type of choices shown on the following snip contains some duplicated entries:
This is the DB entries containing duplicates I need to group:
This is the dropdown that when clicked will show the duplicated entries I need to be grouped:
(In this instance, I’ve tried using unique elements to group them but it doesn’t work when testing)
What I need is to group all entries that are duplicates - instead of them showing independantley within the user’s dropdown choices, I need there to be only one of each displayed.
(So instead of there being 3 x Internal’s, there will only be one)
Hey @ryan23 
Sorry for the confusion. Grouped by is what you need for display purposes. Not unique items. Unique items will display all of them since each one has a unique id, unless you are changing the type to ‘text’ then unique items might work.
Try switching out to a grouped by and see if that gets us any closer. 
@J805 understood although using grouped by prevents the autobinding feature…
I’m using the entries from one type and field to autobind another
Correct. But you can right click on your dropdown and use ‘edit workflow’ instead of autobinding. Would that work? 
If I were building this out myself, I would create an option set called grade and have these three choices. Then attach the option set to the data type instead of using text. But it should work just fine with the way you have it too.
@J805 I see your logic! 
I’ll give it a go and let you know.
The reason I’ve done it this way is because a different user type to the current user creates the dropdown contents for the other user to choose from but only if they have added that user as a supplier. It’s pretty intense and intertwined.
No worries. Let me know if you get stuck on the next step or not.
@J805
Right click, Edit w’flow, do when value changes worked after some tweaking…thanks!
I’ve made each dropdown in the series dependant on the value of the previous ones.
Problem I have now though is that when I make a selection on a dropdown that has already been populated, the following dropdowns don’t reset like they would with autobinding.
Any ideas how this might be done?
Hey @ryan23
Can you share a few screenshots of how you have it set up? I am thinking that you might not have the initial/default value set up. Just my first thought. Screenshots will help further troubleshoot the issue.
No problem @J805.
You’re right, default value is not set up.
I’m using a conditional on the place holder for displaying the parent groups field when not empty.
Ahhh. Ok. Instead of doing the placeholder, set the default value instead. That might solve your issue.
I can’t do parent group’s thing or Do a search for in the default value because it’s not the same thing as the dropdown choices 
Dropdown choices thing is created by another user type
Hmm 
I would have to dig deeper into how you have your database set up to help with it I think. 
Maybe try changing a state or value at the same time you change the other input. Maybe that will push it to work like autobinding was.
Thinking outside the box, I like it - Might play with that idea - thanks
Hope it helps! Thinking outside of the box is just part of the job.
