As a bespoke development company we often utilise FileMaker as a development platform to design software systems for our clients that are locked down to allow for a robust environment. The disadvantage of this is that end users are locked away from the great reporting power of Filemaker Pro.
Recently I have been building a system that required some interaction with Google Maps in terms of creating multiple custom markers to a map. There are many different approaches to solving this problem but I thought I would share my particular twist on this in this post.
There are a few optimisation strategies for Case. At a simple level consider the Let statement…
Let([
f1 = field1;
f2 = field2
];
Case (
f1 = 0 and f2 = 0 ; <result1> ;
f1 = 0 and f2 = 1 ; <result2> ;
f1 = 1 and f2 = 0 ; <result3> ;
f1 = 1 and f2 = 1 ; <result4> ;
<default result> )
)
There are a few ways to achieve a ‘sub summary’ look with in a portal. The simplest is to hide repeating data with conditional formatting. Using the getnthrecord to work out if you are on the first or last record and showing relevant data. If you wish to show a sum then you will need to use a self join the using the parent key and whatever field you are sorting by.
We are pleased to announce that one of our Senior FileMaker Developers has just passed the Oracle MySQL Developers exam with flying colours.
Today, FileMaker announced the full schedule for the FileMaker Developer Conference 2011.
I should start the year by wishing you all a prosperous and successful 2011!
It’s nice to be back at work after a much needed break! All of us here at Linear Blue are looking forward to what 2011 shall bring. What new products and innovations the industry will launch, particularly FileMaker and Apple!
We have all been busy here at Linear Blue helping to save the world! In case you didn’t already know, we have created the Linear Green strategy to try and do our part as a business and cut our carbon footprint. At first we weren’t too sure how effective the campaign would become, however, we are pleased to say all staff at Linear Blue jumped on the Linear Green mission and the outcome has been fantastic.
The Futures Company have recently undertook a study looking at the characteristics of a leading brand.
It’s getting cold again now. I know that because my heating bill has gone through the roof and my car needs about half an hour each morning before I can see through the windscreen. It’s also dark all the time. I leave my house when it’s dark and I get home when it’s dark. I don’t suffer from SAD though… People tell me I’m grumpy all year round… Which is nice.
