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.

Thanks justin.

Just a quick question about it. 

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

Which datasource should i use?

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.

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?

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.

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

Extremely helpful. Thanks 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.

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?

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.

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.