This topic is locked

Adding calculations to 'ADD' page

12/11/2008 8:40:54 AM
ASPRunnerPro General questions
G
guroos author

I have 2 input fields 'standmeasurement1' & 'standmeasurement2' which the user enters. I would then like to show the calculated sq metres in the 'StandReqTotalSquareMetres' field. The user then selects 'standreqtype' from a drop-down (2 choices) and depending on choice the 'StandPricePerSqMetre' is shown.



Based on this formula


Please note: If it cannot be done ASPRunner but CAN be done in PHPRunner or ASP.net then I am willing to go that way

J
Jane 12/12/2008

Hi,
use Before record added/updated events on the Events tab for this purpose.

All entered values are in the dict collection.

Here is a sample:

if dict("StandReqTotalSquareMetres") <36 then

dict("StandReqCostPerSquareMetre") = 440

end if