Filemaker Time Registration for Freelancers
4.6 (48 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
182 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Filemaker Time Registration for Freelancers to your Wishlist.

Add to Wishlist

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.6 (48 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
182 students enrolled
Created by Guy Stevens
Last updated 3/2016
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
Requirements
  • You don't need any prior knowledge of any software or database design to follow this course.
  • Download the trial version of Filemaker without cost to see if this software is right for you.
  • This course is given in Filemaker Pro 14 but can also be done in versions 12 or 13.
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.

Who is the target audience?
  • This Filemaker course is made for those people who want to build their own Filemaker solutions.
  • For people who want to make their boring administrative work fun and easy.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 38 Lectures Collapse All 38 Lectures 07:39:21
+
Introduction
1 Lecture 03:37

We will have a look at the final file we are going to make. I will explain where you can download the Filemaker File. And pay attention to the remark on the language of calculated name fields, like month names, if you are going to use the downloaded file.

Preview 03:37
+
The Basics
8 Lectures 01:38:24

Here we will create the first table and fill it with fields to set up our first layout and enter some data.

Preview 07:48

To be able to enter data we will need to make a nice looking layout for data entry.

Preview 10:28

With a menu we can easily navigate through our solution.

Menu
10:50

To get a better overview of our employers we can make a list view so we can see them all.

Employers List View
18:34

We could add buttons and other items to make certain tasks a little easier.

Extra fancy things on the employer's layout
12:18

We want to put our contacts in a separate table. This way we can store their data separately.

Contact table and layout
13:21

Let's create the list view for the clients and give them a menu button so we can get to our new layout.

Contacts list view and menu button
07:49

It's not handy to have to change layouts a lot. So let's make it easy on ourselves.

Create new contacts from the employers layout
17:16
+
Jobs
8 Lectures 01:42:01

Let's figure out what fields we are going to need to enter our jobs.

Jobs table and layout
17:26

We have a few more fields to add to the jobs layout.

More fields on Jobs Layout
04:32

Let's create the table we are going to use to enter the details of each job.

Job Details table
09:02

The Job details part needs to be displayed inside a portal on the Jobs layout.

Job Details Portal
14:03

Let's make a layout that is used to print the job details. This will look a little different from an on screen display.

Print Layout
16:23

We will need a script that performs all the steps that need to be performed in order to actually print this page smoothly.

Print Script
18:21

Making a Pdf and dispalying that is usually a handier way to preview your print layout.

Pdf Script
12:06

Let's figure out how to attach the pdf to an email.

Email the Pdf
10:08
+
Travel and Expenses
3 Lectures 34:47

In order to keep all of the different Job Details in one table we will need to create a funky structure.

Job Details Relationship Structure
15:06

Let's add the new fields for the travel section to the JobDetails table.

Travel Portal
13:32

To add the expenses we will need one more extra field.

Expenses Portal
06:09
+
More additions, tweaks and handy functions
8 Lectures 01:45:41

There is a difference between the money you bill and the money you will eventually take home.

Gross and Nett amounts
07:52

If we drive one way, we usually also drive back. Entering that manually is boring. Let's not do boring!

Reverse Travel
09:02

If there are routes we often use we might want to store them. That way we can more easily add them to our travel list.

Frequently used travel locations
16:29

To get an overview of all the jobs we do we might want to put them in a list view that has some extra features.

Jobs List
09:36

Now let's group our jobs by year and by Month. That way we can see separate totals.

Job List Sub Summary Fields by Year and Month
15:25

We can use scripts to automatically find certain types of jobs in our list.

Automated finds in the Jobs List
14:20

Fixing our Print layout
20:19

There are two potential problems with our dates. Let's make our system as solid as possible.

Fixing two potential problems with our dates.
12:38
+
Extra's
10 Lectures 01:54:51

This file contains a lot of personal info. We will want to keep it all safe.

Security
15:06

A graph gives you the ability to display your income in a more visual manner.

Income Graph Basics
12:13

We can base our graph on our Jobs list so we can easily move back and forth between our list and our graph.

Income Graph based on Jobs List
04:56

Looking at this graph on the screen is fine. But sometimes it is handier to have a printed out version.

Printing this graph
06:17

Our list and our graph are better when they are not sorted in the same way. Let's change their sort order.

Sorting improvements
09:39

We have made a graph per month. But maybe for some people it is more interesting to have a graph per quarter.

Graph per Quarter
15:47

If our graph has too many quarters in it, we could restrict the date range we want to display.

Restricting the quarters in the graph
20:18

Let's learn more about graphs by making a different kind of graph.

A new kind of graph
11:11

A report doesn't need to contain a graph. Let's learn a trick with sub summary parts and sorting to get the list of top employers.

A new kind of report
11:26

It can be handy to get an overview of all the jobs of a particular employer on his own layout. Complete with a link to the job itself.

Jobs listed per Employer on the employer layout
07:58
About the Instructor
Guy Stevens
4.5 Average rating
856 Reviews
7,291 Students
5 Courses
Filemaker freak

For years I was trying to figure out a good system that would be flexible and allow me to do some proper invoicing and stock management. After years of messing around with Excel files I finally had had enough and went looking. I found Filemaker and discovered a great tool that was packed with great functionality. I dove right in, started to learn everything I could. What started as a simple invoicing database became two and I was always looking to add more and more. I kept running into problems which forced me to find solutions and slowly I started to get to know Filemaker like the back of my hand. Now years later I have taught loads of people how to work with Filemaker and how to solve difficult problems. I have created very complex setups which have taught me everything I need to know about Filemaker.