Hello,
First of all: Thank you very much for Chronoforms, it has been a great help on many occassions.
I have seen tutorials about how to make a form submit data into a database table, but this was done using the easy form wizard. Could someone please explain how to do this with the normal form wizard and events?
Help would be much appreciated!
Hi Viridi,
1) From the Forms manager use the Create Table icon to create a table if you need to.
2) In the Easy Wizard, click the Store Data tab and configure the DB Save action in the same way as the other tutorials.
Bob
Hi Bob,
Thanks for your reply.
Unfortunately, I still do not quite understand.
I use the Wizard form, not the easy wizard form. So I have tabs like 'events', not 'store data'.
I hope to hear from you soon.
Kind Regards
[Edit: I got it to work by adding DB Save to the events and linking it to the correct table, unfortunately my form has 4 pages and the results will be printed in the database 4 times, if page 2 includes 'name' but page 1 does not then 'name' will be assigned a NULL value in the page 1 column, is there a way to fix this?]
Hi Viridi,
You need to capture the primary key value from the first record you create and carry that forward into the later form pages as a hidden input. If there is a primary key value present then ChronoForms will update the existing record instead of creating a new one.
Bob
Hi Bob,
Apologies for my late response.
And thank you for taking the time to help me, I will give it a try.