Bonita multiple fields autofill

Q&A
1

Hello,

I have a suggest box field who’s values are fetched from a database, as follows:

Sql sql = BonitaSql.newInstance(url, username, password, jdbcdriver) def result = []; sql.eachRow ( "select * from supplier" ) { row -> result.add(row.supplier_pin_number ); } return result;

I have other form fields for supplier_company, names etc . If the supplier_pin_number in the suggest box is in the database, I would like for all the remaining fields to be auto-filled. What might be the best approach for this?

Your help is very much appreciated, thank you!

Bonita version: Community Edition 6.5

2

JavaScript on change event calling an ajax webservice is how I’ve done it. Works very well.

Regards

3

Thanks Sean McP, I’ll try this.