Newbie Questions

Re: Submit a form to both a database and e-mail

kminor — Fri, 03 Apr 2009 20:06:16 GMT

Pretty sure I have the code to do this now. I'll post it for reference after I'm certain it works.

Re: Submit a form to both a database and e-mail

kminor — Fri, 03 Apr 2009 14:06:54 GMT

Hi, Madhuri. Thanks for your response! I don't think I can perform all of my validation in the onChange events. Most of my validation involves examining the values of several different fields together -- for example, if the user doesn't provide a customer number, then the customer name, city, and state must be provided. I couldn't figure out how to put that in the onChange events without making the user enter stuff in a specified order. And I didn't want to do that. The code works great if I just run it before the e-mail code (the current version of the form works this way).

I couldn't figure out how to create an onClick event for the button. Since it's set to be a submit button, it doesn't show the name of the control anywhere. Is there a way to find that out?

Re: Submit a form to both a database and e-mail

madhuri — Fri, 03 Apr 2009 06:10:54 GMT

Try validating the fields in OnAfterChange event and the email code on OnClick event of Submit button.

Submit a form to both a database and e-mail

kminor — Thu, 02 Apr 2009 20:49:44 GMT

Hello, I'm having trouble figuring out how to do this, and I didn't find an answer when I searched the forum.

I've got a form that's connected to a database. I can submit to it fine. I've got another form that contains code to submit via e-mail. I put this code in a button's onClick event.

What I can't figure out is where to put that e-mail code in my database-connected form. The button is an actual submit button. It doesn't use rules/codes or anything. I want the e-mail code to execute BEFORE the database submit because it contains validation scripts for the input data.

Thanks in advance for any help!