If Negative number then move to another field?

[stann]

Hi

I have a spreadsheet where presently if the customer owes something it becomes a negative number in the field "service". I would like to have a calculation or a script that sends that number to another field called "owed" only when there is a negative number in the "service" field.

So if the service field says -$220 then the negative sign somehow signals that the number should be placed in the "owed" field for $220 . that is what I am trying to do but I just don't know how to do it.

Thanks

Stan

[Leb i Sol]

make a calcs field:

c_SignalField= Case(SericeField < 0,"OWED")

and place it next to the service field on your layout to 'display'

the same goes for validation of field Serive to 'warn'

and if u want all this 'automatic'

then make a script that is run on "submition" or finsihed entry in service field:

IF SericeField < 0

SetField[owed_field,service_field]

SetField[service_field,""]

EndIF

Take care!