One of my quick question folks asked me a great question the other day:
I’m working on the structure of a contact management system for my university. It’s a rewrite of a successful system that’s been running for almost 10 years. I’m having thoughts about how People relate to Roles and Organisations and how Communications [...]
Unlike a typical SQL database, FileMaker’s PHP API doesn’t support anything like:
DELETE FROM myTable WHERE status = ‘Inactive’
This means that if you wanted to delete a bunch of records with PHP, you’d have to do a find and then loop through the records deleting them one by one. This would take forever and probably overwhelm [...]
If you have a long list of changes to make in the relationship graph of a complicated FileMaker file, QuicKeys can really save your bacon. I’ve posted a screencast of this simple technique if you’d like to learn more. Of course, this is just one trivial example; if you are doing a lot of FileMaker [...]
One of my QQ folks raised a good one today about the interaction between AppleScript and conditional formatting in FileMaker. Click here to see the screencast.
One of my Quick Question clients was wondering how to set up a cross tab report for her chimp tracking database. Yes, you read that right; she tracks chimps for a living.
Here are some excerpts from her original email:
So, I study wild female chimps. What I will need to do is summarize certain [...]