Customizing an Editable Grid widget: changing the behavior of a section of an editable grid from displaying a simple data to displaying a list of data

Q&A
1

Hello everyone,
Currently I am working on Bonita Open source version of 6.4.2 for my project of end of study and I’m facing a big problem to wich i’m not finding any coming.
In fact I have a form with an editable Grid widget in which the user enter some data wich will be transported to a DB Mysql, at this stage everything works perfectly
Besides a new constraint occurred to me: I must populate the boxes of the first column with a list of values from my database so that when a user clicks on this boxes the list scrolls and the value will be picked from this list (the same behavior as the Select widget) but inside a table .

Thank you in advance for your ideas
cordially

2

I would do the following, as an example only,

create a dummy process add a form and add a Select List that is already populated with the list of items from the database.

Open the browser developer screens, if using chrome, F12, right click on the Select List and choose inspect element, do some magic and copy the right piece of code to a notepad. Throw away the dummy process.

In the creation of the data for your editable grid, you will need to prepare a script that creates the necessary HTML similar to that of the notepad copied version that will populate the cells for that column.

for example the data to the table will look something like, each piece is a list item for the editable grid:

["item1", "item2", "item3", "option1option2option3"] Hope this helps, regards