Thu, 24 Sep 2026
Login

DB structure for subform

Confluence User - 30 Oct, 2016

Dear Expert,

I have a form which contain sub form for read only. However when I save that form the field inside the subform will be created in the database. 

How can we attached the subform without creating any db fields ?

Best Regards

Tony Chu

forms;subform;database

3

Confluence User •
30 Oct, 2016 •
confluenceUser •
•
confluenceUser •

Hi Tony Chu

Is the field/table_column which you don't want created in DB table, already exist in another table? If yes, make that subform to point to your DB table with the existing table_column, then no new table_column will be created.

Confluence User •
01 Nov, 2016 •
confluenceUser •
•
confluenceUser •

Dear Matthew,

After more investigation, the unwanted field actually is created by JDBC Load Binder for a grid and not subform. 

I have this SQL in JDBC Load binder:

Select id, c_partCode, c_description from app_fd_testTable;

and the form table will create the following extra fields

c_c_partCode, c_c_description.

Best Regards

Tony Chu

Confluence User •
02 Nov, 2016 •
confluenceUser •
•
confluenceUser •

very interesting - I have run into this problem myself before but I couldn't find out where it comes from or how to reproduce it. I assumed my SQL script was faulty....

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
How can I set dedicated datasource for each app ?
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Issue Saving AJAX Subform Data to Datalist in Joget
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print