DeployedStatus = "Pending" And DeployedDate = Get ( CurrentDate ) ; "Deployed" ;
"Whatever it should be if that is not the case"
You need to make it an unstored calculation or else it will only evaluate once.
Sorbsbuster is using a calculation, which is what you asked for. Calculation fields can't be modified. You would not be able to change from Deployed from your drop down list. You can use a script trigger on the DateDeployed Field. You would use onObjectModify then create a script which could use a case statement. I used a if statement
If[DbUserEdits::DateDeployed=Get(CurrentDate) and DbUserEdits::DeploymentStatus="Pending"
Set Field [DbUserEdits::DeploymentStatus;"Deployed"]
Commit Records/Requests [No dialog]
If you used a calculation to set this field, you would have to add on to your calculation to set the field to "Not Deployed" or to "Pending".
Hello Sorbsbuster & S Chamblee - thank you for your kind assistance and help - very much appreciated.
Thanks again Sorbsbuster & S Chamblee. I am now looking up FileMaker help on how to set up a trigger script and use onObjectModify.