Insert New Form with Data Bridge

I am trying to create an enquiry form which will email us the enquiry as well as send the contents of the enquiry to a database.
I have suffered many crashes whilst trying to complete this task which don't always occur from the same point in the process. The times I have actually managed to complete the form it never seems to be complete. Consequently I am getting completely confused as to what else I need to do to complete the form such as Validation and email settings. One feature that seems to be missing is adding the 'go to page' after the form has been submitted? I have tried to consult your tutorials but they seem dated and do not seem to match up to the Data Bridge bundle and becomes confusing.

One thing that I have discovered is that Form Validation does not seem to work in Safari but seems fine in Chrome.

I am working with Dreamweaver cc with Data Bridge 1.1.8

Please help!

The steps i would use are:

1) Create the form using form builder. in the form builder wizard, don't use the Form action tab to set up the email

2) add the Universal Email behavior. go to WebAssist -> Create Email Message. set the redirect in the universal email behavior.

3) add the Insert record behavior. on the server behaviors panel, click the plus button and select WebAssist -> Data Bridge -> Insert record -> Insert Single record.

I will try your method Jason but I have just realised that the form validation works in Chrome but not in Safari. You can see my form as it currently is here:

http://www.rtmf.org.uk/test-site/contact.php

looking in the source code, this code:

<script>
var Enquiry_NewFromBlank_Default_Opts = {
focusout: true,
focusin: false,
change: false,
keyup: false,
popupClass: "Bloom",
pointedAt: "left",
fieldOffset: 10,
fieldMargin: 2,
position: "left",
direction: "left",
border: 1,
offset: 25,
closeText: "?",
percentWidth: 100,
orientation: "bottom",
};
function Enquiry_NewFromBlank_Default_Validate() {
$("#Enquiry_NewFromBlank_Default").h5Validate(Enquiry_NewFromBlank_Default_Opts);
}
$(document).ready(function () {
Enquiry_NewFromBlank_Default_Validate()
ConvertServerErrors(Enquiry_NewFromBlank_Default_Opts);
});
</script>

is near the top of the page, it should be near the bottom, after the form.

Thanks Jason i've corrected that, but still not working in Safari. I've tried deleting cache but still know joy.

conflicting versions of jquery:

<script src="http://code.jquery.com/jquery-1.10.2.min.js"></script>

this one is added by form builder:
<script src="//ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script>
<script src="//ajax.googleapis.com/ajax/libs/jqueryui/1/jquery-ui.min.js"></script>


try the same form on a blank page, you should not see the same problem.

Jason I am getting extremely frustrated with this now and just do not understand what I am doing wrong. I have tried your method but still no success. The validation is ok apart from now the captcha 'invalid state' shows from the start. I can not get the form to send email or insert record. I am going round in circles. What I don't understand is that if there is options that shouldn't be used in a process why have them their. It is utterly confusing andf have spent too much time on what should be a simple task.

My latest attempt is at http://www.rtmf.org.uk/test-site/contact-page.php

Please help!

OK this is where i'm at…
the form is now being submitted to database but still no email being sent.

Jason I finally got it working! But then I added my template and it stops working. You mentioned about the conflicting scripts before. What can I do about this?

you can only have one reference to the jquery library, you will need to remove one of them.