If you’re using SQL in your FM12 work, you’re in luck. Jason has released a new version of SQLexplorer that writes queries which survive field renaming.
It will also apply this abstraction to queries you simply type in there (vs ones you build with the wizard). Big step forward.
Still free and unlocked, the new version is here.
Psyched that GoMaps is featured front and center on the FileMaker home page and in FileMaker’s iOS Showcase:
The public-facing website SeedCode created for Blueprint Capitol was recently featured on UrbnLivn as a way for savvy Seattle home buyers to find new construction projects before they’re listed on the MLS.
The site uses FileMaker Pro and PHP to publish new projects, renderings, and photos from Blueprint’s ERP system to a slick, searchable public site.
Pleased to announce that our latest template for FileMaker Go is nearly ready to ship… GoMaps lets you visualize found sets on a map, with full control over the pop-over contents, including showing photos from your records right in the map. Click on a pin to see the pop-over; click again to jump to that record in your own layout.
Unlocked and already plumbed for offline access with GoZync, our sync engine for FileMaker.
We’re proud to say that FileMaker has chosen GoMaps as one of their iOS Showcase Applications. Congrats to Tanner Ellen and Lisette Wilson for all their hard work!
Very psyched to see the schedule for Pause on Error coming together! Just recorded a podcast with Matt Navarre of FileMaker Talk about all we’re looking forward to.
Check it out: http://filemakertalk.com/
And stay in touch by following pauseonerror on twitter.
Working on a GoZync integration with Jason this morning and remembered this troubleshooting trick Todd and I came up with. This lets you quickly find where a given operation happens in GoZync scripts. (Worth a quick watch.)
We’ve added a new article to the GoZync docs describing how to turn off the automatic deletion of mobile records that no longer match the users’ pull criteria.
For users pulling very large found sets, this can radically speed up pulls down to their mobile device.
The article describes scenarios where this would help, and walks users though the (very simple) mods required. Again, thanks to Todd’s clean code, this can be as simple as changing a single line. (We should make a collection of our favorite one-line-mods.)
In our last few GoZync deployments we’ve noticed folks frequently need to pull some related data down to the mobile file, but don’t want (or need) to sync the whole related table. Let’s say you want to get a customer’s credit limit on your iPhone but don’t want to sync the (massive) invoices table that is needed to calculate it.
Well now GoZync will let you pull that field with a simple mod. This made several very cool use cases a real snap to sync. So keep in it mind for your next project.
TimeZync has finally shipped.
Most firms have a very hard time capturing billable time and TimeZync can help. It may be the fastest way to log time into a FileMaker solution. And it works offline, so folks can enter time wherever, whenever.
Here is an overview video (8 min)
Highlights:
TimeZync also highlights how GoZync is a framework, a platform, for syncing. Not only is the sync in TimeZync very customized (users pull down just their active projects) but users can get in there and customize the sync further, adding their own business rules. And, of course, folks who run TimeZync can use that GoZync instance to sync other tables and files in their FileMaker solution.
Just over a week away and Jason’s getting ready for his session at DevCon Tokyo. Big thanks to Shin at fmgateway for the timely translations and local support!
SeedCode: Next 