Bonita multiple fields autofill
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;
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
Comments
Thanks Sean McP, I'll try this.