Bonita multiple fields autofill

1
0
-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

1 answer

1
0
-1

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

Regards

Comments

Submitted by jeremykent2726_1 on Thu, 06/11/2015 - 08:35

Thanks Sean McP, I'll try this.

Notifications