Learning Claris FileMaker

In August 2019, FileMaker Inc., announced their rebrand as Claris International Inc. This included a new logo and new products such as Claris Connect. Existing products were renamed — FileMaker Pro…

Experienced FileMaker developers have picked up a lot of tips and tricks for working efficiently and effectively with their FileMaker solutions.

In this eBook, we detail some features and techniques that you should find useful for your own FileMaker development.

We would be surprised if you didn’t know any of these but likewise surprised if you knew them all.

API Primer for FileMaker

What is an API and why should you care?

APIs are the means by which your FileMaker solution can access all kinds of services and interface with other data stores.

When you get a little understanding of this, the world of systems integration really opens up for you.

API stands for Application Program Interface.

It is the interface by which an application accesses a service.

It essentially provides an interpreter service translating requests into language the service can understand and returns the results requested.

It means that the service can be treated as a black box – requests go in, unseen magic happens, and results come out.

Read more on Unlearnit blog post ...

At uLearnIT, we love solving your problems.

Entering partial dates in #FileMaker.

How do you enter a month and a year and then use that as a date in a calculation?

Read about uLearnIT solution for a customer.

Continue reading "FileMaker Solution: entering partial dates"

Get FileMaker 16 Developer Certification

• Are you a FileMaker Certified Developer?
• Why should you care?

• Why should your customers care?
• How do you study for the Certification exam?

FileMaker Inc., has released the Developer Certification exam for the FileMaker 16 Platform. In their words:

“This credential demonstrates to clients, peers and management that you have achieved an essential level of knowledge, experience, and skills in developing on the FileMaker Platform.”

Candidates who pass the exam receive the FileMaker 16 Certified Developer credential.

Read more on Ulearnit blog

17 Practical FileMaker Secrets Learn some of the secrets of professional FileMaker developers for more efficiency in your development. The 17 secrets are from layout design, scripting, calculations and more.

When spreadsheets don’t work

For many people, a spreadsheet is the “go to” tool for quickly storing data for a process or part of the business.

It is so simple to open up a new Excel workbook, name your columns and start entering data.

Before long, you have a whole swag of records entered and can safely save and file it away for later reference.

But spreadsheets are not really meant to be used as a database. Sure, they have functions like sorting and filtering but the basic record structure and integrity is just not there.

Many people think that spreadsheets are good for ‘crunching’ numbers.

And they are.

But a database can do that too.

There are clear cases where spreadsheets fail, and a database is the more appropriate tool.

While there are many more, here are five cases where a spreadsheet will fail to perform as needed for a business.

...

In an existing FileMaker solution, we would like to know if certain scripts and layouts are being used.

Over the years, the solution has been added to and updated in a haphazard manner and we would like to clean it up.

How can we find out which scripts and layouts are in use?

Are you new to FileMaker or new to relational databases? Are you struggling to understand how to create and use relationships?

Grab a copy of our new eBook – FileMaker Relationships 101 In this short eBook, we cover relational structure, using keys, defining relationships and using relationships.

It is a great introduction to relationships in FileMaker Pro ...