Buy Now
Sign in

Saving data in V6 for general and repeatable data

CKEtest , March 11 2019, 11:26
C
CKEtest 31
March 11 2019, 11:26 #384692
Hi
We have a form where up to 6 people can register to an event. The form contains a general part like organisation name, address etc. and a repeatable part, like name, surname etc. for each person to register. The repeatable part has been implemented as repeater area.

We would ike to store the form data into a database, one record per person containing all data, the general and individual/repeatable ones. We are struggling with the implementation.
How to insert both parts, general and individual/repeatable in a save data event ?
admin 27
March 11 2019, 18:04 #384710
 1
 Answer
Hello,
So one record for the whole organization record and the persons ? if yes then the demo repeater form included in the installer will do that if you add a "Save data" action to the form.
But if you want to save the persons in another table with one person per record then you need a Loop Event action with a "save data" inside, set the "Data provider" of the Loop Event to the persons repeater data set in the data array, it should be {data:Guest} if you are testing with the demo form!
Best regards
Max
If your main question got answered then please mark the answer using the button!
Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
C
CKEtest 31
March 11 2019, 19:22 #384716
Hi Max
Thank you for your support. I added a Loop Event Action with Sava Data inside. In there I disabled the Auto save fields. To have the general data added for each person to the database, I enhanced the fields in the Data override on Insert (e.g. organisation:{data:organisation}).
Best regards
healyhatman 7
March 12 2019, 02:31 #384727
Data override on insert would more likely be e.g. databasefieldname:{var:loop_event#.row.formfieldname}
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
admin 27
May 06 2019, 12:33 #386564
Hi,
For quick form data saving including the repeater data, use the new "Log data" setting in v6.1
Best regards
Max
If your main question got answered then please mark the answer using the button!
Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
C
CKEtest 31
May 06 2019, 14:31 #386573
Hi Max

Thank you for letting me know. I will try the new feature in the next form.

Best regards