Any tips for debugging scripts in the calendar?
Everyone has their own debugging techniques but here are a few tips specific to this calendar.
1. Use script debugger. The script debugger in FileMaker Advanced is really essential for following along with scripts as they're executing, you can tell if your script is on the layout you think it is, and importantly, what variables are available to you at any point in a script (via the data viewer).
2. Run the script "Dev ON". This will set a flag preventing the calendar from clearing the (many) variables used to parse events, leaving all this in the data viewer. You'll also be able to see the SQL queries used. The key variables used are: