Figure 1 below shows an example of a form whose first 3 fields are to be pre-populated.
Figure 1: Form with Fields to Pre-populate
The quick and easy approach in addressing this requirement is to make use of the Beanshell Form Data Store in the section's Load Data Store. Edit the section.
Figure 2: Configuring Section Properties to Determine How Data Will Be Handled
In Load Data Store, select "Bean Shell Form Data Store" as the Load Data Store.
Figure 3: Choose Beanshell Form Data Store as the Load Data Store
Configure the Bean Shell Form Data Store with your own coding to populate relevant fields, as shown in the figure below.
Code used in this example:
import org.joget.apps.app.service.*;
import org.joget.apps.form.model.*;
import org.joget.apps.form.service.*;
import java.sql.*;
import java.util.*;
public FormRowSet getData() {
//-----------------------------------------------------------------------------------
//In this part of code, it trying to load the original data from form data table.
FormRowSet results = null;
if (primaryKey != null && primaryKey.trim().length() > 0) {
AppService appService = (AppService) FormUtil.getApplicationContext().getBean("appService");
Form form = FormUtil.findRootForm(element);
if (form.equals(element) && form.getParent() != null) {
form = FormUtil.findRootForm(form.getParent());
}
if (form != null) {
results = appService.loadFormDataWithoutTransaction(form, primaryKey);
}
}
//------------------------------------------------------------------------------------
//------------------------------------------------------------------------------------
//In this second part of code, it will load the data from external source by using
//JDBC. It will run only when the first part of code fail to retrieve data from
//form data table. This example use dir_user table of Joget as external source.
if (results == null) {
results = new FormRowSet();
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/jwdb2?characterEncoding=UTF-8", "root", "root");
if(!con.isClosed()){
String pId = "#currentUser.username#";
String sql = "SELECT firstName, lastName, email FROM dir_user WHERE username=?";
PreparedStatement stmt = con.prepareStatement(sql);
stmt.setString(1, pId);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
FormRow row = new FormRow();
row.put("firstName", (rs.getString(1) != null)?rs.getString(1):"");
row.put("lastName", (rs.getString(2) != null)?rs.getString(2):"");
row.put("email", (rs.getString(3) != null)?rs.getString(3):"");
results.add(row);
}
}
} catch(Exception ex) {
System.err.println("Exception: " + ex.getMessage());
} finally {
try {
if(con != null)
con.close();
} catch(SQLException e) {}
}
}
//------------------------------------------------------------------------------------
return results;
}
return getData();
Figure 4: Populate Beanshell Form Data Store with the Necessary Codes
If the coding is properly written and tested, you should get this result:
Figure 5: The 3 Pre-populated Fields After a New Form is Loaded