cascading dependent lookups in bpm'online

How to Build Cascading/Dependent Lookups in bpm'online

If you have a situation where you must have one lookup offer only a limited set of values based on what is selected in another lookup, then you must setup lookups with dependencies on one another. This article explains how to do that.

Let's pretend we have a need to track an opportunity to sell a car. In this case you might want to have the car make and model recorded on the opportunity. Since there is the possibility of selling multiple makes and models, we want to have the user select the Make of the car and then the list of Models should be displayed based on the selected Make.

First use the page designer (View->Open page designer menu) and create the two lookup fields - Make and Model

entering make

entering model

Then, put them on the Opportunity screen in the appropriate place and you should see the fields show up and working. If you decide to put in the values for Makes and Models at this point, you will notice that all Models show up no matter what Make is selected. So, the next step is to go to the object in the system designer and add the Make field to the Model object.

lookup example for car model

lookup example for car make

Once this is done, publish your changes and the Model lookup should now have the ability to link each Model to a specific Make. If you haven’t already, populate the values in the lookup for Make.

bpm lookups

Then, when you populate the lookup values for Models, you will have a new field that enables you to select the Make that each Model applies to.

bpm'online lookups

The final step is to tell your Opportunity screen to filter the Models whenever a user changes the value of the Make field. This can be done via a Business Rule in the page designer.


business rule in bpm'online

Once all the changes are saved. Refresh your screen and you should see that selecting the Make automatically makes the Model values get filtered down to only those that apply to the specific Make of the car selected.

business rule result in bpm'online

Bonus Tip: You will notice that once you select a Model and then go back and change the Make, the previous Model selection still stays around, but you may want the Model value to be cleared so that the user knows to reselect the Model based on the newly selected Make. For this, a tiny bit of code is needed to make sure the old value is cleared out. Add the highlighted code below to add the autocomplete and autoclean settings which will clear out the Model selection when a new Make value is selected.

bpm'online coding

Allen D'Souza's picture
Allen D'Souza
Senior CRM Consultant

Allen is a senior CRM consultant at Technology Advisors Inc. He spends most of his time designing solutions using InforCRM, StarfishETL, and SQLServer. He also specializes in data migrations from-and-to Microsoft Dynamics CRM and Allen has been involved in large implementations for prominent players in the real estate, telecom, manufacturing, and publishing industries. Prior to working at Technology Advisors, Allen worked as a Microsoft application developer in the Accounting space. Outside of work, he likes to meditate, play his guitar, and eat chocolate.

Related Articles

June 27, 2019

Did you know the subscription level of your Sugar Cloud instance dictates your data storage capacity? If you didn’t know, you probably haven’t hit your data limit; but you may be closer than you think! If you exceed capacity, you could be charged fees. No one likes fees.

So, let’s consider some key aspects of your Sugar storage:

June 18, 2019

When you make the choice to utilize email marketing campaigns to boost your ROI, the easiest method involves two simple steps:

  • Ensure that your emails reach your customers’ inboxes.
  • Provide high-quality content that is mobile-ready and a good read.

The power of email messaging goes much deeper than you might think. Statistics show that 90 percent of emails make it to a customer’s inbox, while only two percent of ads make their way onto an individual’s Facebook newsfeed.