Form Processing - Page 8

User 184085 Photo


Ambassador
1,707 posts

Brenda Rossini wrote:
I checked on upgrading PHP, but I would have to upgrade to a new version of linux to do that. So, maybe you guys could consider supporting those of us who don't have the latest and greatest of everything?

Thanks.


Your running your form on a local server?

What flavor of linux are you running??

thx
Volunteering to help :)
http://www.tbaygeek.ca
My HTML play area
http://www.tbaygeek.ca/test/
User 103173 Photo


VP of Software Development
0 posts

Brenda Rossini wrote:
OK. So, I guess not. Sigh. Wish there were some wiggle room there for those of us who don't want to use S-Drive. So, unfortunately, after having big hopes for the new form builder, I will have to look elsewhere.

There is quite a bit of wriggle room Brenda. We are allowing you to use an outdated version of PHP which is now almost 6 years old. That is pretty amazing if you think about it. ;)
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
User 629005 Photo


Ambassador
2,174 posts

david - according to her first post here, yep

Brenda Rossini wrote:
...I own and operate my own Linux servers ...


I'd recommend updating the Linux & PHP on your servers then... Of course, I generally update my Linux OS within a short time of each new release.
Living the dream, stocking the cream :D
User 2330530 Photo


Registered User
4 posts

I'm having mixed results with 3 different forms as far as mysql is concerned. The first one, a simple contact form is hosted on S-drive, and works perfectly.

The second, a longer form that is still in the sandbox stage, appears to work fine as far as emails, and redirection to a thankyou page. The first time I tested it, it also automatically worked with mysql. But subsequent tests don't go into mysql, but they do go to csv.

The third, a long form I just uploaded a couple days ago, gives me fits. While I'm trying to publish it, I get an error message every 3 seconds telling me a script is causing my browser to run slow, and if I don't stop it, it may crash. If I stop it, my resulting publishing doesn't work at all. If I click "don't stop" every 3 sec., it takes about a half hour to publish my file. I would prefer that form was broken up into at least 4 different pages, but I can't find a way to do that. To top it off, I get that same message at least twice while the form is loading on my site. Once loaded, it may be completed. The emails work fine, but it goes to a blank page, and does not load data into either mysql, or csv. (It's a skills form for an employment site so has lots of checkboxes-- which allow more than one response even though I set it to allow only one.) There's about 140 fields. I'm attaching the error log which is Greek to me. I think it's trying to tell me that there were too many fields, and something about null values.

here is the link to the form in my sandbox: http://agwestpersonnel.com/skillsform.html

Am I trying to do something that CC forms is not meant to do? Any advice or help would be welcome.
Attachments:
User 187934 Photo


Senior Advisor
20,190 posts

If you have a really long form you could break your form up by forwarding the user to the next part of the form after submitting the previous part. There's also some JQuery tweaks that can be applied but it's not as easy as doing the forwarding.:)
Here's an example of what's possible if you use Jquery on a form.:cool:
http://www.jankoatwarpspeed.com/post/20 … query.aspx

There's several more here to get lost in.:lol:
http://www.webdesignshock.com/jquery-fo … tutorials/
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2330530 Photo


Registered User
4 posts

Thanks, Eric;
So, I would essentially be making a group of forms, which, like your example would be fine. But, when I publish, I wouldn't want to send a confirmation for each section-- only one confirmation after they're done. Trouble is, they would only get form results for the last page. There would be no going back to review or correct as a whole. Correct?

Also, I would have different tables in my database. How would I then connect them into a cohesive unit without asking for contact information on each page?. In addition to this skills form, there are 2 other forms each candidate needs to complete. AND, what am I doing wrong that it's not even going to database at this point. I set it up, and even manually created a DB with the name I used on the set-up and that didn't help. I used the same set-up information as I did for my two smaller forms.

It's starting to turn my head to mush!, because I'm also planning to run this out of Joomla eventually--by linking if I can't figure out how to make it run within Joomla's framework. I'm thinking that before I get too frustrated trying to force something, maybe I should look into Lime Survey. Does anyone have any experience with that? I'm pretty sure I would have to link to that as well. I just hate to waste my CC, because that's what I bought it for...

Thanks for your help, and in case it isn't already obvious, I'm pretty clueless when it comes to coding-- which is another reason I bought CC-- (which is by far the easiest, most intuitive form software I've tried when it come's to building a form.)
User 187934 Photo


Senior Advisor
20,190 posts

I haven't used any data bases with my forms yet so I would have to look at that for a while to see how to handle multiple forms to best gather the needed data. Maybe someone with some mysql experience will chime in.:)
The example I posted was one form but Jquery breaks it into what looks like three.:cool: I'm working on a form made from CC form Builder and applying that example of JQuery to it but I don't have all the bugs worked out yet.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 464893 Photo


Ambassador
1,611 posts

Using WFB.
Problem I see with multi page forms is that information has to be carried over saved and after the last page completed, all the data assembled and sent. The good news is that it is easy. The bad is that it would have to be done using the results of each of the forms. Extract the data from each and compose the emails to send. This is what php is for. Each form on each page except the last would be set to save data only. The last would divert to the processing script which would do the work of sending the accumulated data out.

Sue you said that you are clueless at coding. Actually php is easier to use that html in my opinion. There is so much information available and when you break down the bits required it is not that hard. I can help with the building blocks if you want to attempt it. I have some code to get you started using WFB as a payment option. Why would I help>> Ego, Challenge, Hobby, Retired
The Guy from OZ


User 2056177 Photo


Registered User
232 posts

After berating CoffeeCup and Scott that the new form builder was not as good as the old one ( the expression I used was "if it ain't broke, don't fix it"), I now feel that I have to retract that statement.

I now have six forms on our site and every one is working perfectly, submitting both the email submissions and the acknowledgement email to the person submitting the form.

Yes, the forms are more difficult to correctly set up but with a little (or a lot) of patience and time, the new form builder is brilliant, so much easier now that I have got it sussed, to add or alter fields.

To anyone having problems, do what I did, create a test page and upload a test form to play around with.I got there in the end.

Appologies to Scott and Coffeecup,

Pete.
User 187934 Photo


Senior Advisor
20,190 posts

Thanks for the update Pete. I think a lot of other users will find the same thing if they just sit down and mess with the program. Getting familiar with the interface is half the battle.:)
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.