The @ symbol used in email addresses has a use in FileMaker that predates email. FileMaker started using this symbol as a wildcard to search for missing characters. For instance if you were looking for something that ends in ‘smith’, you could search for @smith, which would bring up silversmith and goldsmith etc. Apparently, database… [Read more…]
February 17, 2012
2012-04-20 Updated Demo file. A reader from Brazil pointed out a couple of issues that may come up. First if there are commas in the addresses, you may have problem getting the Longitude and Latitude coordinates. I put in a ‘Substitute’ function around the main address fields before sending the request to the Web Viewer.… [Read more…]
October 7, 2010
2D Bar Codes are all the rage these days. These new style bar codes can store considerably more data than a standard bar code. Combined with the wide spread availability of iPhones and other smart phones with a built-in camera, capable of scanning these codes, there is an opportunity to employ these codes for a… [Read more…]
September 6, 2010
Update: 2011-01-25 – Added a standalone script to the demo database, designed to easily copy and paste into your own solution. Details are here. Shortening long URLs is all the rage these days, driven by the use of Twitter. The 140 character limit that Twitter has imposed means that every character in a message is… [Read more…]
August 31, 2010
UPDATE Sept. 9th, 2010. Apple: We have listened to our developers and taken much of their feedback to heart. Based on their input, today we are making some important changes to our iOS Developer Program license in sections 3.3.1, 3.3.2 and 3.3.9 to relax some restrictions we put in place earlier this year. In particular,… [Read more…]
August 23, 2010
Saved your password and can’t get to it? Here is how to get it ‘unsaved’ “Remember this password in my keychain” clicked accidentally? Sometimes, whether accidentally or intentionally, users will click the ‘Remember this password in my keychain. I usually recommend, especially for laptop users, that they not check this option, because then password control… [Read more…]
August 17, 2010
Last year at the FileMaker Developer’s Conference, this technique for doing drag and drop wtihin FileMaker, was demonstrated. At the time it seemed like it might be a dubious hack, as no one was sure whether FileMaker would continue to work this way. From what I have read FileMaker has approved the technique and it… [Read more…]
August 12, 2010
FileMaker dialog boxes can be informative, but sometimes they are just annoying. You have to click them to get them to go away. Lots of times, you just want to give a little bit of feedback to the user, so they they get a clue as to what your scripts are doing, without requiring them… [Read more…]
August 5, 2010
FileMaker 10 and 11 Script triggers allow you to clean up your interface by condensing a number of script buttons into a single popup. Here is how to get rid of unsightly buttons on your main layout by condensing a bunch of scripts into a single Action button. Source: FileMaker Advisor: http://my.advisor.com/doc/19582 1) Create a… [Read more…]
July 29, 2010
FileMaker’s new Script Triggers allow you to achieve a Google-like type ahead search in FileMaker, searching through a Portal. Here is how to set something like this up based on a person’s first and last name. The more letters you type… The more the portal gets filtered… Define a Search Field Later we will tie… [Read more…]
April 12, 2012
0