How to create editable grid in Bonita community version 7.11
I am unable to create editable grid in task form in Bonita studio community version 7.11
I want to place edit function in the data table in task form. Now only the option of read only data to be displayed in form of table is available.
I want to update and delete data or the table linked to default H2 database.
Hello Pierre-yves Monnet,
how to import this in Bonita Studio ?
Thanks Pierre-yves Monnet ,
I have imported custom widget successfully. Now I want to mention database table, which option should I select?
Thank you very much Pierre-yves Monnet . I wanted to display existing database data on bonita form in a tabular format with edit and delete functions
You can create a custom widget for that since there is no such widget available in Bonita UI Designer (there is also an article about custom widgets here if it is the first one you need to create).
You can also have a look in the contributions if someone developed such a widget and shared it with the community.
I have created many editable grids in Bonita. Its very easy.
Step 1 - Drag a container. Add Text boxes in the container.
Step 2 - Set a value for the container like formInput.customValue. Set each Textbox with $item.column name
Step 3 - create a API that pulls data from Database. Bind the JSON with formInput.customValue.Now your grid will be populated with rows from Database. You can use CSS to modify the Look and feel of the Grid to match a Table.
Step 4 - Create a formOutput and map formInput.customValue with formOutput. This way you can resend values from Grid back to Database.