My own table

 
2
1
0

Hello

Firstly, i already created a form(with a table name = app_fd_item_detail)
The question is can i create, manually, a table using sqlyog?
can i call it from joget v6?

thanks in advance

    CommentAdd your comment...

    2 answers

    1.  
      4
      3
      2

      Hey there Muhammad, 

      Yes, you can create your own tables using an SQL client and link it to your Forms later on.

      However, ensure that Joget have access to your created tables and the correct columns with the correct data types.

      Cheers.

        CommentAdd your comment...
      1.  
        2
        1
        0

        Thanks justin.

        Just a quick question about it. 

        How? Is it something like this JDBC Datalist Database Binder. 

        Which datasource should i use?

        1. Justin

          The JDBC binder is only used to read/write records, not to create table. You can use your SQL client to observe Joget tables with the prefix "app_fd_***" as your reference.

        2. Muhammad Nur'afif Isnin

          im sorry, my mistake. i meant that, when i already created the table, then i can call/read/write them using JDBC, and use it in the form. am i right?

        3. Justin

          Yes! That's correct. If you've created the table in the datasource that Joget uses, select "Default Datasource". Otherwise, if you've created the table in a different database, select "Custom Datasource" and fill in the information required. Hope this helps.

        4. Justin

          Or, while creating a new Form, in "Table Name" field, try typing in your newly created table name.

        5. Muhammad Nur'afif Isnin

          Extremely helpful. Thanks Justin :-)

        6. Justin

          You're welcome! Gentle reminder to mark the answer above as the official answer, to assist other users in this community. Have a good day.

        7. Muhammad Nur'afif Isnin

          Hello again justin. if, i want to use hash variable to call (from my manually created table) instead of using JDBC, which variable should i use? i tried #binder.APP_ID.FORM_DEF_ID.FIELD_ID# but it seem not quite worked. also tried #form. tableName . fieldId # but not working. any advice?

        8. Justin

          The Form Data Hash Variable is used to obtain field values from a table that is linked to an existing Form. Not meant to substitute the JDBC binder.

        9. Muhammad Nur'afif Isnin

          Ok noted about that. so, can u suggest the hash variable that is suitable for it? i wanted to call the data from my table(manually created) at the form builder.

        CommentAdd your comment...