Having a script run on it's own

[Chris Good]

I have written a script that looks at two fields and if they aren't empty then it it runs a set field step to check a check box. I would like this to run automatically. Perhaps when someone type something into a field, then it runs this script. Is that possible. Can I do that as part off a calculation?

[Chris Good]

I have a partial answer to my question. I changed the field to a calculation that is always validated. The formula is

If ( Remainder Due ; 0 ; "Completed" ) but the problem is I want it to also check a field called actual shipping to make sure it is greater than 0 and if both are true then it should mark the order completed. I know this can be done I'm just not sure how.

[comment]

Case (

not Remainder Due and actual shipping ;

"Completed"

)

Note that 0 is a number and "Completed" is text. These should not be mixed.

[Chris Good]

But that would only allow me to specify one variable. have two fields. Actual shipping and Remainder due. I want it to look at actual shipping and it the value is greater than 0 and if the value of remainder due is 0 then "Completed"

[comment]

Have you tried it?

[-Queue-]

As long as Actual Shipping cannot be less than zero, comment's calc will work. If it can be less than zero, add > 0 to the Actual Shipping test.

[Vaughan]

The IsEmpty() function is the best way of determining whether a field is empty. Alternatively, "IsEmpty() = 0" or "not IsEmpty()" can be used to test whether a field has data entered.

[Chris Good]

Sorry to have doubted your suggestion. It worked perfectly.