Sugar Logic has a number of improvements coming in Sugar 6.5, but I think the biggest one for those who use the tool is the new ability to create dependent dropdowns now thru Studio and Module Builder. I can’t tell you how many times I’ve heard this feature requested, and until now it was only possible thru code level customizations. Now by adding the editor right into Studio, anyone can build and maintain a depend dropdown field in seconds.
So let’s take a look at how it works. To do this, we’ll need two dropdown fields in your module; one which is the parent field which drives the values available in the child field, and then the child field which has a list of all of the possible values. After creating the parent field first, we’ll create a new child field, taking note of a new option available…
You’ll see the familiar ‘Dependent Field’ now has two options. You’ll see the classic ‘Formula’ entry, which also you to enter in a normal Sugar Logic formula to determine visibility, and then a new option ‘Parent Dropdown’ which let’s you define a field to drive which options are available in the dropdown. If you select ‘Parent Dropdown’, you’ll have the option to pick the parent field which will work with this field.
Now click ‘Edit Visibility’ to pick which fields to show in this child field when a particular parent field value is selected, using the grid shown below.
The UI is pretty simple here; just drag fields from the ‘Available Options’ box in to one of the boxes under the options from the parent field. The list of options listed in the parent field boxes represents the options available in the child field when that option is selected in the parent field. In other words, if I select ‘Analyst’ in the parent field, the only options available in child field will be ‘Call’, ‘Task’, and Meeting’.
You can see this in the UI by saving this field and adding it to the EditView for the module. Then by going to the UI you can try this out.
Then by changing the ‘Type’ field to ‘Customer’ we get a different list of options in the Test Dropdown.
And if you select a field that doesn’t have any child field values assigned to it, the child field disappears.
This feature now extends what cool things Sugar Logic can already do, making it a very powerful feature for users that is easy to use and setup.
And that’s not all for Sugar Logic in 6.5. Stay tuned to this blog for a few more developer features that will help your use of Sugar Logic in your organization.