1. Script Trigger & Sorted Portal Issue

    October 21, 2009 by admin

    Conditions – A portal with: -at least 2 fields in it -ability to create new records from the relationship -sorted either in the relationship or portal -a script trigger on one of the data entry fields that commits the record in any way and then returns to a specific row in the portal When an On Save script trigger on a field in a sorted portal (the sort can be in the relation or portal itself), if the script commits records, the portal will always be sorted when you return to the original layout. That’s to be expected. But there’s [...]

  2. Script Trigger & Sorted Portal Issue

    by admin

    Conditions – A portal with: -at least 2 fields in it -ability to create new records from the relationship -sorted either in the relationship or portal -a script trigger on one of the data entry fields that commits the record in any way and then returns to a specific row in the portal When an On Save script trigger on a field in a sorted portal (the sort can be in the relation or portal itself), if the script commits records, the portal will always be sorted when you return to the original layout. That’s to be expected. But there’s [...]

  3. Reflections on a Global FileMaker Project

    October 13, 2009 by Chuck

    The extraordinary, devoted people of CURE International change the lives of children all over the world by providing them with medical care they would otherwise not have access to. I am fortunate to have the opportunity to assist their work with my talents as a FileMaker developer. In the last six months CURE volunteer Trevor Bunch and I have deployed CURE’s new Electronic Medical records to Hospital s in San Pedro Sula, Honduras and most recently Addis Ababa, Ethiopia. Knowing that we would be facing any number of unanticipated challenges during deployments the system itself had to be designed, built [...]

  4. Layout Based Script Triggers Part 1.5

    October 5, 2009 by admin

    In the last blog, we talked about some basic script triggers you can apply for preview mode to sort and to navigate to the last page of the printout, and then back to the first (giving the user a total number of pages in the printout). One thing we might want to do to take this even further, is applying navigation to the printouts, as well as some options for emailing, PDF’ing, etc… In the last blog we talked only about the script trigger for On Mode Enter. In this part, we will apply an additional script trigger for a [...]

  5. Associating Custom Menus with Privilege Sets

    October 3, 2009 by phin

    FileMaker has its obvious security features such as the Manage Accounts & Privileges feature. From here you can basically restrict users’ access to records, layouts, value lists, and scripts. FileMaker users may have encountered these security issues by trying to run a script from the default Scripts Menu and not succeeding. Depending on how the script is written or how you have accessed the file, the user may receive different results. These results could be a default FileMaker error message, a custom message, or no message at all. Users can be easily annoyed from any of these results and a [...]

  6. Basics of FileMaker Debugging Part 1 – Fields

    October 2, 2009 by admin

    When you’re developing in FileMaker Pro and are receiving incorrect or missing values, you’ll need to find the source of the problem. However, from my experience, many part-time developers aren’t exactly sure where to start diagnosing the issue. When I talk to some of my clients, the word “debugging” elicits looks of dread but actually, it’s simply a case of trial-and-error along the same list of issues each time. You won’t always find the problem early on, but it’s in there somewhere if you just know where to look. Here, I’ll try to explain the basic debugging process in FileMaker, [...]

  7. FileMaker Skins

    October 1, 2009 by Marshall

    Last March, the managed service side of our company moved from a in house designed system to a off the shelf SQL based system. This simple move, which increased the productivity and accountability of that group ten fold, left the sales staff with a less than stellar way to work with our clients. Specifically, when trying to develop lists for invitations to events that we were planning, the .Net and SQL system left a lot to be desired. One option would be to start developing specialty pages within the .Net framework or we could use what we knew, FileMaker. One [...]