Script to subtract new value from old value

[Jtown]

Hi, i'm new to scripting...well new to FM...anyway, I have a database with a quantity field and a form on the web that allows the user to remove X amount. Now, I don't want the quantity to be edited, but instead the result of a subtraction. Would calling a script be the right direction?

[Kurt Knippel]

quote:

---

Originally posted by Jtown:

Hi, i'm new to scripting...well new to FM...anyway, I have a database with a quantity field and a form on the web that allows the user to remove X amount. Now, I don't want the quantity to be edited, but instead the result of a subtraction. Would calling a script be the right direction?

---

Hmm, possibly. However I assume that you are trying to give a VALUE, then allow the user to type in a ADJUSTMENT, and then you will arrive at a TOTAL.

Simply make your TOTAL field a calculation, like the following: TOTAL = VALUE - ADJUSTMENT.

[Jtown]

hmm...I think the math part is easy, I just don't really understand what syntax to use in scriptmaker. In my webpage, I have the old recordid found and I have a quantity the user can enter to remover from the DB. I'm guessing the submit button will call a script, but how do I send it the both those values and write to the DB?

thanks for any help

[Kurt Knippel]

quote:

---

Originally posted by Jtown:

hmm...I think the math part is easy, I just don't really understand what syntax to use in scriptmaker. In my webpage, I have the old recordid found and I have a quantity the user can enter to remover from the DB. I'm guessing the submit button will call a script, but how do I send it the both those values and write to the DB?

---

You should really be asking these questions in one of the web forums, if this question is how to get and manipulate data off of a web page.