Script Triggers and Instant Web Publishing
I am very new to FileMaker Pro. I am using FileMaker Pro 11 on Windows OS.
I have designed a tracking database with 4 layouts. Of the 4 layouts, there are multiple Date fields which needed additional formatting for data-quality control. I set up scripts "on object save" such that if the date was below 01/01/2010 or above 01/01/2020, show a dialog box stating that the date is not within a reasonable range, please check source; and then to clear the field. You can see my script below:
If[IsEmpty(Enrollment Tracking::Consent Date )]
If [ Enrollment Tracking::Consent Date<Date (1;1;2010) or Enrollment Tracking::Consent Date>Date (1;1;2020)]
Show Custom Dialog["Date is out of range. Please check source."]
Clear[ Enrollment Tracking::Consent Date]
This runs fine in FileMaker Pro client version, but unfortunately we will be doing data entry in Instant Web Publishing (which I was not aware of while designing the database.) I know that custom dialog boxes are not supported under IWP, so that statement has been removed. In researching how to get scripts to run, I found this statement: