AnsweredAssumed Answered

Calculation for DeployedStatus Field

Question asked by ChrisSmythe on Oct 27, 2012
Latest reply on Oct 28, 2012 by ChrisSmythe


Calculation for DeployedStatus Field


     Hello, I am using FileMaker Pro 12 on Windows XP.

     I am hoping someone would please be kind enough to help me with the following FileMaker Calculation:

     I have a link to my Test 11.fmp12 database (Account Name: Admin & Password: "there is no password" just click OK.

     I need a calculation that changes the DeployedStatus field from Pending to Deployed --- in the following table:

     DbUserEdits table --- DeployedStatus field; and
     DbUserEdits table --- DeployedDate field.

     If there is a DeployedStatus field that = Pending and has a DeployedDate field that = "Today's date",

     then the DeployedStatus field needs to change to: Deployed.

     This calculation needs to be applied to all records in the DbUserEdits table.

     Any help would be greatly appreciated.

     Kind regards,

     Chris :)