Filemaker Time Registration for Freelancers

A complete beginners course to learn the basics of Filemaker and some cool extra tricks while creating a real solution.

4.65 (127 reviews)
Udemy
platform
English
language
Databases
category
instructor
531
students
7.5 hours
content
Oct 2018
last update
$54.99
regular price

What you will learn

Build their own Filemaker solution to manage time spent on various job for various clients.

Create basic filemaker tables, fields and relationships.

Make beautiful and practical Filemaker layouts and add all kinds of fun features.

Description

In this course you will learn how to make a Filemaker database system that can be used to register time spent on jobs. This is specifically meant for freelancers and people who work for multiple clients or employers.

In this case it will be a time registration database where you store your time spent, miles traveled and extra expenses for each job you do.

We will be storing employers and contacts and entering job details.

This is a course for people who own a small business and can’t afford to buy expensive software packages to manage their administration. For people who don’t want to spend hours each week doing boring, monotonous paperwork that can be automated and be made easy, fun and professional looking.

I included the Filemaker file in the course for download so you can easily look at my file if you get lost somewhere or if there is something you want to look at more closely in detail.

At the end of this course you will be able to start your own FIlemaker projects and build them exactly the way you want them so they work for your company and not the other way around.

Content

Introduction

Introduction and Filemaker Files

The Basics

Employers Table
Employers Layout
Menu
Employers List View
Extra fancy things on the employer's layout
Contact table and layout
Contacts list view and menu button
Create new contacts from the employers layout

Jobs

Jobs table and layout
More fields on Jobs Layout
Job Details table
Job Details Portal
Print Layout
Print Script
Pdf Script
Email the Pdf

Travel and Expenses

Job Details Relationship Structure
Travel Portal
Expenses Portal

More additions, tweaks and handy functions

Gross and Nett amounts
Reverse Travel
Frequently used travel locations
Jobs List
Job List Sub Summary Fields by Year and Month
Automated finds in the Jobs List
Fixing our Print layout
Fixing two potential problems with our dates.

Extra's

Security
Income Graph Basics
Income Graph based on Jobs List
Printing this graph
Sorting improvements
Graph per Quarter
Restricting the quarters in the graph
A new kind of graph
A new kind of report
Jobs listed per Employer on the employer layout

Screenshots

Filemaker Time Registration for Freelancers - Screenshot_01Filemaker Time Registration for Freelancers - Screenshot_02Filemaker Time Registration for Freelancers - Screenshot_03Filemaker Time Registration for Freelancers - Screenshot_04

Reviews

Adrian
June 1, 2020
I was wanting a pre-built time registration filemaker solution and the opportunity to learn a few 'tricks' in filemaker and this was the easiest solution. Well done (as always) Guy !
André
March 13, 2020
This is an excellent course. Even thought I have used Filemaker for some other projects, I still didn't understand things like Found Set and table relations, which are clear to me now. Very recommended course!
Bulent
April 19, 2019
Thank you Guy. You are an awesome teacher! I learned new things and I also practiced my earlier skills. I recommend the course everyone who wants to learn/get better about Filemaker
Martin
December 25, 2018
I like the course a lot. From a technical perspective, I have learned a lot. Of course, the course is not for people who have never seen FileMaker. There should be at least some experience with the tool. To have a small "in progress" project where you can apply the new knowledge helps a lot as well. What I a little bit miss is the preparation of the development of the application. Some kind of design section. Can be small, but would be helpful. The author knows very well what is where, but you can get lost. And BTW do not expect to go through the course within one day :-). I believe it is ideal to spend one/two hours per day with the course and one hour with your project trying to apply the ideas.
Jeffrey
December 2, 2018
This is a great course. It had a little bit of everything you need to learn to make your on FM Solutions.
Steve
September 16, 2018
C'est une personne qui explique très clairement et le résultat est extraordinaire Félicitation Merci
Bennani
December 6, 2017
Guy Stevens explique méthodiquement son développement et nous donne le pourquoi de sa démarche j'aime bien.
David
September 17, 2017
Getting a wee bit tricky BUT the explanations are really first class After a few days break - doing other work - I got back onto this course again starting from point 1 again and going through it all again - this time with a slower speed - It was very entertaining - very well thought out and very well presented by Mr Stevens - I will be looking forward to his next course on Udemy or even youtube ! What I would like to see is a complete CRM solution (I know it has lots on the internet) but one with and for Europe - like for instance Formatting the Telephone numbers to fit different lands and numbers ? I know one can do this using "Countries" and " CASE " things on FM BUT a good instructor like Mr Stevens could set one up in no time :) PLEASE !!!!! Slainthé Mhath - Slan Egat David
Mike
September 14, 2017
As always, excellent instruction.. Clear examples and detailed explanations. I have purchased most of Guys courses and have not regretted any of them yet. Funny thing is, I am still learning something new as well.
Armando
June 22, 2017
GUY is a good teacher and always detail exercises and looks pretty easy to solve and easy to work alone. hope to continue helping beginners
Hugh
March 12, 2017
Continue to enjoy the course and understand Filemaker better. I really like it that Guy makes mistakes! This happens in reality and it helps to show how you need to keep a cool head and work backwards in a logical pattern to search out the error. Please keep the mistakes in. Like learning to ride a bike it is learning to correct the wobble that you get most familiar with how Filemaker works.
Stefan
January 6, 2017
Sensational way of presentation. Absolutely perfect ! The theme, the way of presenting, the speech, the speed, really amazing.
Bert
October 2, 2016
Great course when you are absolutely new to Filemaker. Guy takes you through every step and tells you the reason behind them
Daniels
May 11, 2016
The quality of this cours is Great, what I see here is another way of working the tables in order to extract information when it comes for prepare Reports. it seem to be confusing, but the instructor knows how to get his way out! You really have to where you are and where you are going when it comes to built stuffs with filemaker.
Cameron
March 27, 2016
Anyone who wants to learn Filemaker and wants to make their own databases.. His Courses are great for reference and learning.. I Have taken them all and have learned so much... i hope he ends up uploading a course more about accounts because i would love too have a database where i can share work orders with other employees and those employee can only see specific data and can only add data that is needed, once that data is add from that employee then they send it back to the boss with the completed work that was needed

Charts

Price

Filemaker Time Registration for Freelancers - Price chart

Rating

Filemaker Time Registration for Freelancers - Ratings chart

Enrollment distribution

Filemaker Time Registration for Freelancers - Distribution chart
786224
udemy ID
3/8/2016
course created date
11/22/2019
course indexed date
Bot
course submited by