Script Trigger

[gullfounder]

Hi,

I have this bizarre problem. I have portal in which there is a Product, Qty, Unit Price, total price. I have made a script that triggers on Unit Price modification. It should put 1 in qty field then multiply qty with unit price and put it in Total price.

The Script.

"

Set Field[Qty :1]

set Field [Total Price = QTY* unit Price]

"

But nothing happens?. The unit price field is look-up field. So, it picks up the unit price as product value is entered. I need to know what i am doing wrong? Or there is another why to do it?

[No_access]

it would seem to me if I understand you, that the table with the total price should be a calculation and a not done with a script unless you have some reason for using a script here? can you post the file so we can see your script?

[gullfounder]

i got it fixed myself. As you have suggested that i should make it calculation field.