CLEANING UP DATA, where ever the source, can be a frustrating and challenging job. Many times it takes personal attention, but you can minimize the amount of work to be done by using some of the tools provided in FileMaker. fullcityconsulting is posting a series of blog posts about functions, and you’ll find the posts about […]
I DOWNLOADED THE DEMO and played with it a bit–pretty impressive performance. It’s in beta now, and you can sign for the beta program at the link: The next version of SeedCode Calendar moves the calendar’s complexity out of layouts and into the WebViewer, creating a calendar that’s faster, and much easier to paste into your files. This also […]
IT ALWAYS SEEMS to me that some people just have the ability to grasp design principles effortlessly. Combined with the ability to draw and lay things out in proportion, these people seem to just make beautiful art. But it seems there is some science and math behind it, too, that will help the hopeless (like […]
HAVE YOU EVER revisited code you wrote months or years later and wondered “What the heck was I thinking when I wrote this?”. Most developers I have talked to have done so at least once, and that was because they did not comment their code properly. Emory Brown outlines a logical, clear method used at […]
Sadly, this article won’t help you with your personal relationships. Instead, Michael Rocharde tackles filtered relationships in FileMaker and does so in a major way: cascading relationships where the user is presented with a list of filtered selections at each step in the process, making it easier to find and select the record they need: […]
Hint: It has nothing to do with construction or buildings. Instead, it is rounding numbers with a twist. FullCityConsulting explores floor and ceiling functions in their weekly post: A few weeks ago we looked at the Min and Max functions. That got me wondering if there are any other FileMaker functions that travel in pairs. I […]
Using FileMaker Go and iPads or iPhones to reduce paper-based processes is an idea that has been around for a while. This video from FileMaker shows some of the success stories and illustrates the savings in both time and money: Published on Sep 10, 2014 More businesses today are seeking alternatives to legacy paper-based processes. […]
I was browsing Briandunning.com for custom functions and found a few good ones to link: GetQueryStringValue ( keyName ; sourceUrl ): Given a full URL and name of a key, returns the given key’s value out of the entire URL. CurrentTime_Less_Hours_Minutes (Hours ; Minutes): Gets time less hours and minutes entered CurrentTime_Plus_Hours_Minutes (Hours ; Minutes): To […]
I WAS JUST USING THE FILTER FUNCTION this past week to clean up a nasty looking phone number field from a web source. The field in question allowed the user to type in any alphanumeric data they wanted: Cell, Extension, ATTN, Attention, Mobile, etc. It also allowed too many digits, too few digits, parenthesis, dashes, and […]
AHH, DATE FIELDS. On the surface, one would think date fields are pretty strait-forward. But there are twists and turns when dealing with date fields, and it’s best to know FileMaker’s rules when working with them: The date field is designed to hold a data string representing a single date such as 11/22/2004. When you […]
So what it the Chromebook effect? You’ll need to listen to find out. It’s on my list while riding today. Thu, 11 September 2014 314_FM_Success_Tips Chromebook effect, It’s a data server, not a file server, Making a pdf and attaching to email Direct download: 314_FM_Success_Tips.mp3 Category:podcasts — posted at: 5:30 PM Filemaker Success Tips: 314_FM_Success_Tips.
BE PREPARED to spend some time on this article from Kevin Franks. But it will be worth it. The problem is simple: The popover object in FileMaker 13 presents developers with a wealth of new design opportunities (a number of which were discussed in this article: FileMaker 13 Popovers). But if you’ve tried to use a […]
MANIPULATING TEXT IS USUALLY a big stumbling block for beginning developers. Mastering those functions (LeftWords, RightWords, Position, PatternCount, etc.) will make your life much easier. FullCityConsulting’s explanation of the Substitute function starts with a simple example: Substitute simply examines some text for a specific set of characters (called a searchString) and replaces them with a new set of […]
A GREAT EXAMPLE of FileMaker success from UK Filemaker for current and prospective clients: Royal National Hospital for Rheumatic Diseases “We are always looking at ways to further improve patient care. Collecting information electronically makes tracking patient progress and care over time particularly simple. By automating the collection and scoring process, clinicians can quickly consult a […]
Jonathan Fletcher: Donald, wouldn't the last "4" be included after applying the filter to that field? So it would be "50412354324" instead?…
Don Clark: Good catch, Jonathan. I changed the example to match what I was showing. In the instance that there are too…
Jonathan Fletcher: Yes, there's always something in the data you hadn't thought of before. ::-(