How to make cascading dropdowns with database values?

Hi all!

I want to add three cascading dropdowns in one of my forms. Each dropdown values are dependent to the one above it. The values are mapped in a mysql database.

Based on what I read, one possible approach is to use the HTML widget, manually code the dropdowns, and use jquery and ajax to handle the events/queries on each dropdown. I can then use bonita's rest API to pass the values from each dropdowns into predefined bonita variables which can be used in succeeding tasks/forms.

I am fairly new to Bonita and I am still inexperienced in using the web rest API. I'm wondering if there are more practical or better ways to do this. Is it possible to do this using the dropdown widget?

Cheers, Joshua