What is meant by a field "Being completed"? what does that mean?
a: ship date
the ship date is often left empty for months and the status is 'In Production'. when the unit ships, the ship date field is completed with the actual date shipped. at that time, i would like the status field to change to 'Shipped' triggered by the ship date field being completed.
so...in looking at attached image. when the date is filled in for the Ship Date field, i want the Status field to change to 'SHIPPED' from 'IN PRODUCTION'.
Status could be defined to use this calculation:
If ( IsEmpty ( Ship Date ) ; "IN PRODUCTION" ; "SHIPPED" )
this can be for a calculation field or a text field with an auto-entered calculation--provided that also you clear the "do not replace existing value" check box.
thank you phil. that worked and i learned something. have never used IsEmpty, but now it is in the arsenal. also always, your assistance is so appreciated.