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.