How to Set Up Cascading Dropdown Fields in SugarCRM

When you want the options on a dropdown list (list B) to change based on the way a different dropdown field (list A) is set, you must set up cascading dropdown fields in SugarCRM. Here’s how to do it:

  1. Setup dropdown field for list A as normal
  2. Create dropdown field for list B
  3. In the list builder, add ALL options that will be available no matter what the corresponding list A option is
  4. Check the box for dependent
  5. Select the Parent Dropdown type, and select the list A field as the Parent Dropdown
  6. Click the Visibility Editor button
    1. You will see a ‘menu’ on the left of the options you created for list B. On the right, you will see a box for each list A option.
    2. Drag the correct options for list B into each of the list A options.

Tip: You can leave some list A option boxes empty to hide list B for those list A options.

Add both fields to your record view layout and any other layouts where you want to use them.

Visibility Editor

Megan Sheehan
Trainer & Business Analyst

Megan is a SugarCRM expert who helps clients design and build their CRM systems. She’s been part of the Technology Advisors team since 2012 and has written three books on SugarCRM in that time. In addition to training clients, Megan co-hosts a SugarCRM focused podcast with Justin called “Sugar Cubed CRM Talk”. She also teaches SugarCRM classes each month. Details about these courses can be found on the Sugar University webpage.

Related Articles

February 13, 2019

Our Microsoft Office Exchange server is hosted by Microsoft on their Office 365 Cloud and our SugarCRM instance is setup to send emails from notifications@techadv.com. If we want to allow our Sugar users to send emails from within Sugar without having to setup their own SMTP credentials individually, we must grant the notifications@techadv.com user access to send emails as each user. If this is not setup properly, we receive an error like: SMTP -> ERROR: DATA END command failed. Reply: STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message.

February 4, 2019

Did you know that less than 40% of businesses have a CRM adoption rate above 90%? That means 60% of all businesses have poor CRM adoption. If this sounds like your current situation, the good news is you’re not alone. The bad news? No one is using the CRM your company invested thousands of dollars in.