Forums

Multipage db save after each form page

mrbiso 30 Nov, 2016
Hi All,
I have a multipage form (6 pages) that works fine but I would like to add a DB Save after every submitted page. Problem is that if I simply add a DB Save action on each page, it creates a new db entry after every sbumit. What I want to do is to create a new entry on the first save but then to edit this entry without creating new entries. Any suggestion?
Thank you All
Enrico
GreyHead 30 Nov, 2016
Answer
1 Likes
Hi Enrico,

After the first DB Save get the record ID of the new record - ChronoForms will add that to the Form Data after the save; then pass that forward to the succeeding pages and the remaining DB Saves will update the record with that ID.

Bob
mrbiso 30 Nov, 2016
Hi Bob,
now it works in the right way! Thank you for your kind help!
Is it now possible to choose to send via mail the form entries from the database instead of the entries stored in the multipage session data?
Thank you
Enrico
GreyHead 30 Nov, 2016
1 Likes
Hi Enrico,

Yes if you need to - they should be the same. If you add a DB Read action and add a Model ID then you can re-load the saved data and use {model_id.column_name} in the template.

Bob
mrbiso 30 Nov, 2016
1 Likes
Got it!
Everything works now!
Thank you so much for your kind help!
dearmassoto@gmail.com 24 Jan, 2018
Hi Grey, can you help me with this subject. I'm triying to do this but dont know how.
Max_admin 30 Jan, 2018
Hi dearmassoto,
It depends on your form version, if you have v6 then you will need to store the saved record id some where after the first save, maybe in the user session using the "save to session" action then call the value in later save actions inside the "where conditions" box.
Best regards
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.