Extending Functionality of an Email form

[Hagopm]

Hiya guys

I've written an email form for a website. Its a timesheet form so students for a tutoring agency can fill in timesheets on line. its up at
http://www.oc-ec.com/pages/tut_tmform7.htm

I've got a few queries, I've tried finding the info online but I've yet to find a comprehensive guide to writing forms, all the attributes etc. so if anyone knows of one please give me the address. Else I'll have to buy a book.

On my form I'd like to do the following:

The hours columns to be added up and the number placed in the 'Total Hours' box

this number to be multiplied by 26.5 (the hourly rate tutors are paid) and placed in the 'Tutor Fee' Box

this number added to whatever number is placed in the travel fees box and the result placed in the Grand Total Box.

Also, when the email generated by the form is received, the textfield vales are in a different order every time. Is there any way to constrain the order, to guarantee that the textfield values in the email are the same order as they are on the form?

thanks

---------------

btw attachment is an unrelated cool image!

[Gamini]

I attempted this with javacript with no luck (I was never very good with it though). Can the totals and everything come on the screen after the submit button is pressed? Or does it hve to come before that?

If its after, then I can easily do the script for you using php. Your host will have to support it though.

The text field orders come that way because they all have the same name. You must name them diferently for them to come in order.

[Hagopm]

I suck at coding full stop! Thats why I stick to HTML!

How about a calculate button instead of the submit button? I'd be grateful for the script, pretty sure my host supports PHP.

pretty sure I named the textfields, will have another look tomorrow.

thanx

Hagop

[Gamini]

Ok, I will post that script maybe tomorrow.

[Hagopm]

yo dude

any chance you could post that script?? I'd much appreciate it, and if I use it I can pay you something for your time!;)

[123456789]

I'll take a look too.

[Hagopm]

sweet! the more the merrier

[123456789]

You know where it says "Lesson Times" (hours and minutes) and the "hours"? What does each represent?

[Hagopm]

'Lesson times' is the time of day of the lesson e.g.
14:00.

'Hours' is the length of the lesson e.g. 2

hours is the only value that needs to be affected by the script.

[123456789]

Also, for the travel costs and the Grand Total and stuff like that, you can fill those in later. And I think I'll have to put a Calculate button on the form and then have the grand totals and stuff on another page, or make an I-Frame.

[123456789]

Also, I'm not a genius, so I might take a while.

[123456789]

How do you calculate the Tutor Fee, the Travel Costs, and Grand Total?

[123456789]

And if Ian is here, I'm sorry for the multiple posts, because I didn't read my PM's until right now.

[Hagopm]

tutor fee is 'total hours' x 32.96

dont worry about travel costs or total fee as these are discretionary.

I just need the hours added up, and then the tutor fee

Ideally the answers would appear in the appropriate textfield boxes on the page when the 'calculate' button is pressed... 2nd best would be an i-frame

cheers

[123456789]

I should be done soon. Are you urgent?

[Gamini]

The hours added up and everything using php cannot be placed inside the textbox, they can just be plain text.

If that is ok then I can post the script within a few hours.

[123456789]

What? You can post numbers inside text boxes using PHP.

[123456789]

Well, I guess if Gamini is going to post it, I'll stop, because his script is probably going to be better than mine anyway.

You can put PHP variables in text fields:

like this:

<?
$testing = 3;
?>
<form>
<input type="text" value="<? $testing ?>">
</form>

[Gamini]

I have done the majority of the script, I will post it with all errors corrected sometimes within the next 24 hours.

[123456789]

Do you have an i-frame or does it automatically update when you type something into a text box?

[123456789]

Hey! I just figured it out with JavaScript:

<script language="javascript" type="text/javascript">
<!--
function calculate(f){
total = eval(f.amount1.value) + eval(f.amount2.value) + eval(f.amount3.value) + eval(f.amount4.value);
document.getElementById('total').innerHTML=total;
document.getElementById('total2').value=total;
}
//-->
</script>

Name the input boxes with the correct names and change the script as you would like it.

[123456789]

Does anyone know how I can get Hagopm to come back to this thread?