Mission: Promote excellence and ethics in database development, management and consulting

              through education, training and professional resources.

As a free service to prospective clients, sample and demonstration files showing JWES FileMaker Pro development techniques are periodically made available for download.

These demos are locked, but are indicative of the techniques we make available to our clients and of the techniques we teach our students.

However, these files are completely open and without password for our students.

Please contact JWES Solutions by mail to:

        - request an accesscode if you want access to the studentdownloads(*).

        - request a file.

(*) Make sure to give us the reason why you, as non JWES student, should have access.

Especially in countries where two area units are used together or as mix, it is usually very difficult to pass the exact right dimensions to calculate areas.

Therefore this little conversion file where you can bring in the Widths and Heights with multiple input and output units.

Width and Height can be expressed in millimeters, centimeters, meters, inches and/or feet.

The calculated area can be expressed in square millimeters, square centimeters, square meters, square inches and square feet.

You can use any combinations of these units in the Width, Height and Area.

The Custom Function, that is the core of the calculations, will calculate the final area accordingly.

Sometimes you do not have enough screenestate to put a checkboxfield with possible multiple values on a layout.

Although we do not encourage the use of a checkboxfield with more than 8 or 10 choices, it can happen that you have to provide more than 10 choices.

This can result in a huge checkboxfield.

It would be nice to have the possibility to make the checkbox choices 'scrollable'.

Here is a technique to accomplish that.

We just use a recursive Custom Function and a relationship based upon serialnumbers.

A complete Document Management System in FileMaker Pro.

Other little files:

        - TennisChamp

                Keep track of your tennis performance against any number of players.

        - TCO Calculator SaaS

                To let you quickly compare the total cost of ownership (TCO) of a software-as-a-service

                (SaaS) solution to the TCO of an on-premise solution.

        - Commuting Calculator

                To provide a quick approximation of savings opportunity with telecommuting.

                Based on a businessmodel where employees who previously worked at a facility

                now work at home on a full-time base, with only accasional visits.

        - Audit Trail with Rollback

           

                 With this technique you can even roll back deleted records at any time.

        - Parse Return Separated lists.

        - How to connect to an Oracle database.

                A tutorial to avoid the code 126 error.

        - View your files with the Web Browser (Windows only).

                Eliminate all those shortcuts on your desktop.

        - AutoEnter Default values.

        - Custom Menu

        - Dynamic Email