11 Comments

  1. johnjohn123

    Dear Sirs

    Can i build my own asp.net web application forms using visual studio instead of using the Joget Form builder , especially that i already have the required experience to build forms with the intended validations.  but my concern if it is possible to integrate my asp.net forms with the joget workflow,, and will it add extra time comparing to using the Joget form builder?

    Best Regards

    1. Hugo

      Hi John,

      Yes, you can. You can use Joget to manage the process automation part and with your own custom form handler. Please see Integration.

      On the development time, it depends on how well you understand the architecture and APIs offered by Joget and how fast you can integrate Joget with your custom application. In my opinion, you should try out Joget's form builder first.

      Good luck!

  2. Eduardo Cabrera

    HI.

    How can I upload a file and insert it in a tabla of database

    Thanks

    1. Hugo

      Hi Eduardo,

      Please use the File Upload. File uploaded will be stored and handled automatically by Joget. You can just add it into your form and it will just works.

      Cheers.

  3. Supisara Kannadhep

    Hi, I’m  a trainee. I have problem about beanshell in Grid.

    I want to load grid data using beanshell  in form a and form b and get data  form a to form b .

    Form a can working but Form b can’t show Variable in grid  ( from b )

    Code form b

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

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

    import java.sql.*;

    import java.util.*;

    Connection con = null;

    con = DriverManager.getConnection("jdbc:mysql://localhost:3307/jwdb? characterEncoding=UTF-8", "root", "");

    FormRowSet tools = new FormRowSet();

    tools .setMultiRow(true);

    if(!con.isClosed()){

                    PreparedStatement stmt = con.prepareStatement("SELECT c_details ,c_sum FROM app_fd_tp7 where c_tools ='"+request.getParameter("c_tools")+"'");

                    ResultSet rs = stmt.executeQuery();

                    while (rs.next())

    Unknown macro: {                                 FormRow tools_row = new FormRow();                                  tools_row.put("details", rs.getString("c_details"));                  tools_row.put("impact", rs.getString("c_sum"));                                  tools.add(tools_row); }

            }

    return tools ;



     How  resolve the problem ?

    ***    request.getParameter("c_tools")   is error 

    Yours sincerely








    1. Hugo

      Hi there,

      Here's some reference to get your started.

      1. Load & Store Form Grid Data Using Bean Shell Form Binder
      2. Bean Shell Programming

      Good luck.

  4. Supisara Kannadhep

    Thank for the advice.

  5. Danny Macias

    Hi.

    I have a form whit 1 textBox and 1 selectBox. In the selectBox i try request the text but included in the query of selectbox. I don´t know.

    Ejm.

    1.- TextBox valor (0913908836)

    2.- selectBox >>>>> Configure Bean Shell Form Binder

    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);

    String caja = cedula_empleado.getText();

    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();

                con = DriverManager.getConnection("jdbc:sqlserver://xxx.xxx.xx.xx:XXXX;databaseName=XXX", "******", "******");

                if(!con.isClosed()){

                            String sql = "SELECT distinct(proyecto) FROM ACC_personal WHERE  personal= '" + caja + "' AND proyecto  is not null ORDER BY 1"; 

                            PreparedStatement stmt = con.prepareStatement(sql);

                            

                            ResultSet rs = stmt.executeQuery();

                            while (rs.next()) {

                                       FormRow r1 = new FormRow();

                                       r1.put(FormUtil.PROPERTY_VALUE, rs.getString(1));

                                       r1.put(FormUtil.PROPERTY_LABEL, rs.getString(1));

                                       f.add(r1);

                   }

                }

                return f;

    {color:#000000}}

    return test();

    3 .the operation does not work  :(

    PD: All de operation is the same form.

    Regards.

  6. Benyamin T. Yousif Tawadros

    I want to know how to embed an image to my form?

    I added a custom HTML element and added the following line:

    <img src=”http://192.168.50.4:8080/jw/AGB.png” />

    But the image does not show up

    1. Benyamin T. Yousif Tawadros

      hi

  7. addagulla

    Hi to All,

                I want one Bean Shell Load Binder sample for multi paged form

    I hope some one will help me

    thanks