FileMaker 16 and 17 tech documentation

General version check

Also a very good overview of the new/changed main-features in each version.

About differences from 6-7-8-9-10-11-12-13-14-15-16-17

FileMaker 17

In general: For 90% of 17 what you know in 16 is what you need.

FileMaker Pro 17

FileMaker Pro and FileMaker Advanced is merging into one

FileMaker Pro 17 including links to references, error codes and the changes/new features

FileMaker Server 17

FileMaker Go

WebDirect

FileMaker 16

FileMaker Pro 16 including links to references, error codes and the changes/new features

FileMaker Server 16 including all references

FileMaker Go 16

In general: For 90% of 16 what you know in 15 is what you need.

FileMaker WebDirect (pretty important)

DB Services list of new features in FileMaker 16

KEA Exercise

Choose between 3 possible scenarios

General info and follow up after seminar no. 2

You will need to make a lot of decisions on your own, we are only suggesting some of them. When the user uses your app, think of other information you would like to store automatically:

  • the date/time of the registration
  • the location
  • other important information

You are the architect …. use your imagination!

Notice: Only choose one of the exercises.

For all exercises we expect that you have downloaded FileMaker to your PC or Mac in advance. For some of the exercises an iOS unit like an iPhone or an iPad is needed. Choose one of the other exercises if you do not have an iOS device.

You can work alone, but it is also fine to work in groups of two students.

 

App 1: Gather receipts and other documentation

The story: Employees of the “Jackson Tools” are traveling a lot. They are paying for transport-related costs, accommodation  etc. They must register the receipts and the problem is that they tend to forget to deliver or loose them. You need to be able to create a user and to let the user register new reciepts. In this case the data model could look like this:

The short requirement specification
A simple desktop and/or mobile app for registration receipts etc.
For this exercise a desktop computer and perhaps a smartphone/tablet is handy if you will let the user use WebDirect to access it.

 

App 2: Mobile issue registration with photos

The story: “Blue Coil Inc.” needs a simple registration app for registration of issues with the ability to add a picture, a title and a description. The issues must be linked to a construction site where they do the delivery. At least two entities (tables) will be needed. One for [site] and one for [issue]. Also consider, if you want to be able to have more than one photo per issue to have a separate table for the photo, instead of just a photo field in [issue]. In this case the data model could be like this:

The short requirement specification
A simple registration app to be used by a craftsman or an architect for registration of issues and missing parts on a  construction site.
For this exercise an iPhone or an iPad with the free FileMaker Go is advisable.

 

App 3: Web application form with open positions/jobs at your company

The story: Your company wants to publish open positions/jobs on the web. A page with open positions (jobs to apply for) is required. The user should then select one of the jobs to apply for and fill in a form. We do at least want to know the basic information about the applicant and which job he/she applies for. Add extra data you find relevant and consider: Should he/she add a CV or other documentation, perhaps a picture?
In this case the data model could be like this:


The Short description
Create a simple form to create an application for a position at a company. It must be accessible on the web from desktop computers and tablets. Use WebDirect for publishing.

 

How to start

Important decision: Working alone or with another student?

At the bottom of this page you will find video instructions describing the next steps – if in doubt please see the movies

Download the exercise file here

As soon as you have downloaded the file please rename it to your name (lower ascii, a-z and 1-9 _ -). Please use “_” (underscore) instead of spaces in the name. Keep the name short, like “carstenlevin.fmp12” or “elisabeth_and_emerson.fmp12” etc.

Set the password for the admin account

Now you must set the password for the “admin” account (the one you are using for development)

  1. Menu-> File-> Manage-> Security
  2. Set a good password and do not forget it!
    Select the “Admin” account and set the password.
    Do not change the Codeo or Jens accounts.

 

Upload the file to FileMaker Server

After setting the password you can upload the file to the server.

  1. Go to the menu File-> Sharing-> Upload to FileMaker Server…
  2. Select “Favorite Hosts” at the top of the dialog
  3. In “Host Address” at the bottom add “fms21.codeo.dk”
  4. To the top right add your assigned “Name” and “Password”
  5. Click “Next”
  6. Click “Browse…”
  7. Select the file you have renamed and click “Open”:
  8. You are ready to upload – so click “Upload”
  9. When upload is finished you can open the file directly here and start your work:

Congratulations – you app is now live on the internet!

Video instructions

The first 4 movies will show you how to download the start file for your solution, renaming it, setting the password and uploading it to the server.

01_download_file

02_rename_file

03_set_password

04_upload_to_server

The next videos will show you how to start building a solution

 

Course plan

This is a “crash” course taking you from scratch to a functional custom app within two compressed modules.

Follow up after the course: From Friday April 6th
We will send you all an email on Friday with suplementary information.
If you want we will offer you p2p support via skype or by coming to our office at Frederiksberg. We will let you know how to ask for help-inspiration sessions in the email.

If some of you should want to continue using Filemaker for your KEA and other projects while being a KEA student, we will keep supporting you for the next months … or perhaps longer.

Module 1 – Intro to FileMaker and “Custom apps”

The objective of the first module is to provide an intro to the FileMaker platform and the “Custom App” concept.

FileMaker platform

This is your introduction to FileMaker as a development environment. We look into each part of FileMaker and try out the different tools which make up the “full stack” environment.

  • FileMaker Pro Advanced – your “full stack” environment
  • Investigate the tools and app structure
    • File
    • Tables
    • Fields and data types
    • Calculation Engine
    • Layouts
    • Scripts

Deployment

An important consideration when planning for a custom app for your team or workgroup is deciding which way you want to deploy the custom app and the pors and cons on each of the many ways you can deploy a FileMaker custom app.

  • FileMaker Server
    • On premise
    • Hosted
    • FileMaker Cloud
  • Desktop app
    • FileMaker Pro on Windows and OS X
  • Web app
    • Web Direct – immediately deploy for all modern browsers
    • Custom Web – connect to your custom app with PHP API and HTML5 tools
  • iOS app
    • FileMaker Go – immediately deploy on iPhone or iPad

Design principles

When developing a FileMaker Custom App you achieve the best results when following a thorough process, even if it is a small app. FileMaker provides a set of guides for their approach called “Plan-Create-Deploy”. You will find links to these below.

Module 2 – Create your first “Custom app”

In the second module we focus on hands-on and giving you the opportunity to try out the tools and design principles we promote for creating your first “custom app”.

Plan
Create
Deploy

Have a look at the exercise

KEA FileMaker Training – Background Material

Welcome to the FileMaker Seminars. We hope that you will enjoy this opportunity and will be able to benefit from the Rapid Deployment Development for Desktop, Web (all platforms including Android) and iOS.

Course plan

When you have questions or need support

Feel free to contact us

Bo Sigaard sigaard@codeo.dk

Carsten Levin levin@codeo.dk

General information about FileMaker

Guides and white papers

A very good introduction course in two phases: Basic and Advanced. Created for FileMaker 15 but very relevant for 98% of FileMaker 16. Strongly recommended.

FileMaker 16

Other sources for training

Download FileMaker Pro Advanced for this course

Follow this link for registration as a student at this course and to obtain the training sofware and serial number. Remember, you need to delete the installation after the course. Registration and training software.

 

Task for session 2 and onwards

 

Et Codeo Projekt

Et Codeo Projekt starter typisk med et kort uforpligtende forløb, hvor vi får første forståelse af det, der helt præcist er specielt for virksomheden. Hvad er det, der skal løses? Allerede her er det målet at isolere de processer, der tilføjer størst værdi. Hvor kan der gøres en forskel?

Læs

Haases forlagssystem

Haase & Søn er et af Danmarks ældste forlag, men absolut spillevende med tankevækkende udgivelser til forskning og undervisning samt fiktion. Det er altid spændende at kigge forbi www.haase.dk, og det er sjældent, man ikke finder spændende og læseværdige nyheder.

Læs