1
0
-1
1 answer
- 10-1
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
- M Tarek Hamwi
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
- Ian
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
- M Tarek Hamwi
I already made it into c_machine_name
but still not showing
it is not creating a new form and showing in the list - M Tarek Hamwi
this is currently the updated sql
but still not working
Add your comment...
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