Forums

jQuery Multiple DatePicker - separating the dates

xetra21 18 May, 2018
Hi,

First off, I'm not actually sure if this is the correct place to ask this question but after extensive searching I can't find anything, so apologies if I'm out of order.

Situation is that I've built my V6 form and need to add multiple dates as per the DatePicker. That's all gone fine and populates the field as it should. The problem is that I then need to be able to separate each date on save so they can be used as proper date fields to show the selected dates in a calendar. I've looked for MySQL info but no luck and I'm not very well versed in Javascript to even contemplate whether it's doable.

Any help would be greatly appreciated.

Thanks
GreyHead 18 May, 2018
hi xetra21,

What do you see as data values for the Dates in the CF Debugger output?

What exactly do you need to do with them?

I'm guessing that you get an array of dates - in that case you can loop through the array (using a Loop action) and save each of them to a database record if that is what is needed.

Bob
xetra21 22 May, 2018
Hi Bob

Thanks for replying and yes you're right in terms of what I'm trying to achieve, just actually achieving it is a challenge.

I followed your advice and added a Loop Event and referred to the CFv6 manual instructions as well.

So, my form that uses the MultiDatePicker is the first pic and I couldn't get it to work. So, I then cut all the other fields out (apart from Date) and have been trying with that one as well - again without luck.
I've posted the images of both the debug screen and also the setup screen. I've obviously screwed up somewhere but no idea where though.

Things like the Data Provider which I've assumed is the ID of the date field and also things like where in setup should the Loop and Loop Save go.; but I could be totally off with it.

Also, on the main form, would you still be able to keep the Date field on the same page as the singular data fields or should that go onto another page? And also, how is the aid, primary key field of the Chronoform ID table passed to another table? Sorry, if I'm being thick, just alot of this stuff is outside my skill level.

Hope it makes some sense and thanks again.

Paul








This topic is locked and no more replies can be posted.