I ran into a situation recently where a user would not or could not remember to commit their changes before exiting their FileMaker Go solution on their iPad.
The truth is it’s easy to complain that the user isn’t using the system as it was intended. Complaining about the user doesn’t really solve the problem, and we are problem solvers. This is custom software; it should work the way the user works, not the other way around.
In this case, the user was using an iPhone or iPad Mini. He pulls it from his pocket, opens a work order, adds some photos and notes, and then sticks the device back in his pocket. Then he does some work (like replacing a window in a building) and then takes some more photos of the completed repair. The way FileMaker Go reconnects to the server (and now in version 14 FileMaker Pro works this way also) makes this work seamlessly for the user. The problem in this case is that the user is sleeping his device without committing changes so when another user modifies that record while FileMaker Go is “sleeping”, the iPad user’s changes are lost.
When FileMaker Go is in a “sleeping/disconnected” state, uncommitted changes don’t get explicitly committed…and other users can modify the record.
Here at Skeleton Key we keep a “Developer’s Chat room” open on Slack throughout the day. The team kicked this issue around for a bit trying to come up with a good solution. We came up with several ideas:
- Show some sort of alert to the user when there were uncommitted changes
- Use a wizard style interface for making changes
- Use a web page approach (edit & submit) buttons
- Capture changes via global fields then write them with a transaction style script
All of these items came with their own set of issues and drawbacks. And we felt like they were really just treating the symptom rather than solving the problem. What was the problem? The problem was that the user wasn’t “saving” their changes. Or to say that differently, the data wasn’t being saved (again, not really the user’s fault). So we decided to take a different approach and see if we could save the changes without changing how the user was working. The solution was found by utilizing the way OnTimer script triggers work. To be honest, I usually don’t have much use for OnTimer scripts. Maybe it is because one of the first examples I saw of how they could be used was to show a dialog once an hour reminding users to submit their time sheets. In general, they have always been kind of a turn off for me. Despite its drawbacks the OnTimer trigger has some specific characteristics that play a big role in our solution.
- Any window can only have one OnTimer trigger at any moment
- Calling the Install OnTimer Script step will cancel any currently running trigger
- Calling the Install OnTimer Script step without a script specified will cancel all timer scripts
- Calling the Install OnTimer Script step with the interval set to 0 or blank will cancel all timer scripts
- Time-triggered events run during idle time
The solution for us was to use an OnObject Modify script trigger to call a script that invoked an OnTimer trigger that would commit the current record and restore our cursor to its original position. In its most basic form, that solution looked like this: Save It Commit & Restore Cursor (simple)
You’ll notice we are waiting 1 second in the script above. In the picker example referenced at the end of this article a .25 second wait time works best. We found that on an iPad the longer wait time was needed.
The basic idea is that each time a field is modified it initiates the “Save It” script. Subsequent calls cancel the previous calls and the timer script won’t start until there is idle time (the user stops typing). Once there is a lull in the action the timer will fire the “Commit & Restore Cursor” script. There are a few things you need to put in place to make this work:
- First, you’ll need to give each field on the layout a name because after we commit the record we use the Go To Object script step to get the cursor back to its original location.
- Next, you’ll need to attach an OnObject Modify trigger to each field on the layout.
- Don’t worry, they all call the same script and there are no parameters to pass, so it’s still pretty easy to implement
And there are a few “gotcha” items as well:
- When the user makes a change to a field in a portal the Go to Object step will put the cursor in the first portal row regardless of which row the user was originally in.
- We can overcome this issue by capturing the portal row before the commit, and then using a looping script to get back to the correct row.
- Container fields in FileMaker Go will show a dialog pop over whenever the cursor is put into the field. Therefore the “restore cursor” portion of our script causes an unwanted dialog.
- We can overcome this issue by using the “FieldType” function to capture whether the current field is a container field or not and if it is, exit the script before the “restore cursor” steps.
- Similar to the issue with container fields, fields that have any control style applied (drop-down list, pop-up menu, checkbox, radio button, drop-down calendar) will behave poorly when we go back to the field after the commit step.
- We can overcome this issue by using the “FieldStyle” function to capture whether the current field is using a control style or not and if it is, exit the script before the “restore cursor” steps.
When you put it all together the result looks like this: Commit & Restore Cursor I first came across a similar technique over at www.modularfilemaker.org. The issue there was running a picker over a WAN and trying to make it behave quickly. The solution was an OnTimer triggered script used in a similar way to what we have done here. Let me know in the comments if you’ve found this technique useful. Feel free to leave your own stories of users who don’t “use the system the way it was designed.” 😉 About Skeleton Key Skeleton Key helps turn complex, complicated, and outdated systems into true information platforms. Our team of consultants and developers do this by developing custom-fit software tools and reporting dashboards that help businesses find, use, and understand their data, freeing them to focus on and grow their core business. In addition to custom databases and applications, we also provide training and coaching for getting the most out of your existing systems and understanding your unruly data. Skeleton Key is an open-book management company and active player of the Great Game of Business.