I have an AppleScript that scans emails generated by an HTML form and populates a FM Pro 14 database entry with the info therein.
My problem is I have a number of Script Triggers than run OnObjectModify but when you fill a field via AS, the triggers don't activate. Even the Value Lists I have associated with certain fields get ignored. How can I get those triggers to run?
Example: in the State/Province field of my database, I have a script trigger that will determine if your country is US or Canada based on what you enter. The Value List also limits this field to only accepted 2-letter abbreviations, but an email came in with "New York" as the state and that's what the field got filled with.