It is useful to know that the weekofyear( date) function in filemaker does not always return the correct week for the input date.
Going in a 4 year cycle the week can be reported as being 1 higher than it actually is.
One way to tackle this is to use weekofyearfiscal( date ; startingday) and make the starting day 2
(all examples should be taken as advice only and be fully tested if you intend to use them)
You may not have come across FileMaker Pro before and may be used to people talking about Microsoft Access, MySQL or SQL Server.
What is FileMaker?
FileMaker Pro is a powerful, multi user, relational database which can be used to build complex bespoke database systems, it can support unlimited users and can be accessed remotely over the internet from anywhere.
FileMaker also has a reasonably fast development rate due to its design compared to other database systems available, which in turn helps to keep development costs down.
So what type of things can it be used for?
Another big feature of FileMaker pro is that it can be used as the background datasource for websites.
This can be done into 2 ways:
So in short, FileMaker pro is only limited by your imagination.
If you have problems when connecting to FileMaker Server 11 via ODBC to display content to your website there is a known issue with text fields not displaying.
To solve the issue you need to go into the field options for all text fields you wish to publish on your website and set the maximum character validation to a value, don’t make the figure too high as you can exceed the limited.
Once you have done this you should be able to call and display text fields without further issues.
Many customers we talk to would like to have a custom database but feel they don’t know where to start when it comes writing a spec or what functionality they can make use of.
With our good understanding of business practices and a clear understanding of customers needs, we are able to guide people through the specification stage with very little pain.
You can tell us what you would like the database to be able to do and we will then advise on any additional functionality which you could make use of in your new system and discuss the work flow. From this information we can produce the specification document for you.
People think of database systems as being complicated to use for the end users, we understand this and design all are systems to be completely user friendly.
Filemaker Go for the iPhone and iPad brings much requested easy out of office database access for users on the go.
It can be used with existing FileMaker Pro databases or you can have a custom solution developed to make the most of Go.
