Hello,

The Bean Shell Form Binder does not populate data to a grid in my form. I tried at the beginning the following standard script:

import org.joget.apps.form.model.*;
import org.joget.apps.form.service.*;
import java.sql.*;
import org.apache.commons.collections.SequencedHashMap;
import java.util.*;
 
public FormRowSet test() {
    FormRowSet f = new FormRowSet();
        f.setMultiRow(true);
        Class.forName("com.mysql.jdbc.Driver").newInstance();
    con = DriverManager.getConnection("jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF-8", "root", "");
 
    if(!con.isClosed()){
        
        String sql = "select id, dateCreated, dateModified, c_entryFormText from app_fd_tb_test_entry_form";
        PreparedStatement stmt = con.prepareStatement(sql);
        ResultSet rs = stmt.executeQuery();
        while (rs.next()) {
        FormRow r1 = new FormRow();
            r1.put("gridColumn1", rs.getString(1));
            r1.put("gridColumn2", rs.getString(2));
            r1.put("gridColumn3", rs.getString(3));
            r1.put("gridColumn4", rs.getString(4));
            f.add(r1);
       }
    }
    return f;
}
return test();

============================================================================

It did not work. Then I tried some static entries like the below:

import org.joget.apps.form.model.*;

import org.joget.apps.form.service.*;

import org.apache.commons.collections.SequencedHashMap;

import java.util.*;

public FormRowSet test() {

    FormRowSet f = new FormRowSet();

        f.setMultiRow(true);

         FormRow r1 = new FormRow();

            r1.put("gridColumn1", "Hello 1");

            r1.put("gridColumn2", "Hello 2");

            r1.put("gridColumn3", "Hello 3");

            r1.put("gridColumn4", "Hello 4");

            f.add(r1);

    return f;

}

return test();

=============================================================

In all cases the output is:

I don't see any errors in the logs even when I run the form as an activity in a process. What is wrong?

PS: The options of the grid is: