Validating data filemaker
Late in development, the client realized there was a need to see if two related date ranges overlap each other, and if they do, include the parent record in the report (see Figure 1).
Read about using the visual list technique: Part 1 and Part 2.
Demonstrate how to send a verification code via SMS (text message) to a user's mobile phone during Sign In.
Cache your container fields in a web server directory for increased performance.
One brief answer pointed to the best solution: Instead of trying to query for all the possible ways in which two date ranges could overlap, think of the scenarios in which they do not overlap.
The Stack Overflow community provided some useful answers, but they too involved a complicated SQL query.
Whether you’re creating catalogs, managing inventory and billing, or planning a wedding, you’ll learn how to customize your database to run on a PC, Mac, web browser, or i OS device.
The special sauce, fm PDA: A replacement for the File Maker's API For PHP File Maker class using the Data API.
This is a handy way to isolate all the hard-coded strings in your code in one location.
Working in a team or even alone, it's a great way to self-document your database usage with your web application.
Demonstrates how to pull data from File Maker and display on the calendar, handle drag and drop, event resizing, etc.