Thu, 24 Sep 2026
Login

how can I create a form automatically

Confluence User - 25 Oct, 2024

so I am looking for a way to create a form automatically 
not create a form, more like automate the filling in the form details.

for example, let's say I have 2 form 

In the first form, I will key in all the necessary information in that field manually. Now, when I press save, I want Form 2 to also be created with some of the information I keyed in Form 1. However, it will have a be saved in a different table and Form ID


Basically, even if I update form 1 details form 2 should generate another form details but different ID, not update an old value
think of it as Form 2 is a history of Form 1 that holds some of the information, even the old values 


I am not sure if it is possible and if it is I have no idea how to do that
if possible, can I get a clear explanation and screenshot?

or maybe an app that does the same stuff i am looking for that can help me understand more

forms;process;autofill;autopopulate;generate

5

Confluence User •
25 Oct, 2024 •
confluenceUser •
•
confluenceUser •

in Form 1 , go to Form Builder > Settings > Advanced > Post Processing Tool 

and use

  • SQL Query Tool - do a query to insert data into form 2 table
  • Also check whether this tool should run only on creation of form 1, update of form 1 or both

tThis way, the moment you click on save, it will run the SQL Query to say insert selective or all data from Form 1 into Form 2

Confluence User •
25 Oct, 2024 •
confluenceUser •
•
confluenceUser •

i did that already but still it didn't work 


there is not data is actually being created in the list 

my list is also fetching from the database


Confluence User •
25 Oct, 2024 •
confluenceUser •
•
confluenceUser •

any user created fields will have a prefix of "c_" . so if your field is called "machine_name", in sql Query its "c_machine_name"

reference: Database SQL Query - Knowledge Base for DX 8 - Joget | COMMUNITY

Confluence User •
25 Oct, 2024 •
confluenceUser •
•
confluenceUser •

I already made it into c_machine_name 
but still not showing 

it is not creating a new form and showing in the list 

Confluence User •
25 Oct, 2024 •
confluenceUser •
•
confluenceUser •

this is currently the updated sql 

but still not working


1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Multiple Subflows in Joget
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 trigger workflow process when form data is submitted via API
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print