Learning Claris FileMaker
317.3K views | +9 today
Learning Claris FileMaker
Give life to your data with an easy to use database ... I'll share cool FileMaker stuff for you, avoiding the programming part of it as much as I can.                        #WorkplaceInnovationPlatform #Claris
Your new post is loading...
Your new post is loading...
Scooped by Didier Daglinckx
Scoop.it!

Javascript 101 in FileMaker with Leland Long - Day 1

For more info on this series - https://bit.ly/LLJavaS

From the perspective of FileMaker Dev's that know very little about JavaScript, come join us as we learn some simple, basic JavaScript concepts and how to implement JavaScript inside our FileMaker solutions. 


We will explore a few real-world scenarios of implementing some JavaScript to work with a sample table of 1 million records.

-Sample file for Series - https://bit.ly/JavascriptDemoSignup
-Watch the recordings here - https://fmstartingpoint.com/download_sample_file.php?file=CPN_01491


No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

A Simpler Backup Script –

A Simpler Backup Script – | Learning Claris FileMaker | Scoop.it
Demo file: backup-simplified.zip (requires FM 18 or later) Like many developers I go back and forth between developing locally and in a hosted environment, and many years ago I posted a couple articles featuring a simple backup script to create on-the-fly backups when working on local files. Recently a colleague pointed out that this backup routine,…
Didier Daglinckx's insight:

With Demo file

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Scraping Tables – Pulling Data Tables from Web Pages into FileMaker Pro

Scraping Tables – Pulling Data Tables from Web Pages into FileMaker Pro | Learning Claris FileMaker | Scoop.it

A friend of mine (Douglas Alder) has, for a number of years, been using an older version of FileMaker to grab grooming reports from the local ski hill’s web site.

 

The ski hill put out their grooming reports as PDFs, so she would download these, then Copy and Paste to get the text into FileMaker.

Once in the database, a script runs that parses the grooming information into fields and records.  

The final stage is to generate a text file summary of recent grooming days for her phone (and smart watch).

It is a very useful data set (the previous 7 days of grooming reports) to have when you are out on the ski hill, looking for some corduroy or for finding those last remaining stashes of powder a couple of days after the last snowfall. 

 

The ski hill also published their data to a web page.

In an ideal world, this data would also be posted to a publicly available JSON file and FileMaker could easily parse that data into records.

 

Read more on the blog post ...

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Multi-Column Portals in FileMaker

Multi-Column Portals in FileMaker | Learning Claris FileMaker | Scoop.it
A colleague recently posed this challenge: is it possible to show two columns in a portal, such that the first row displays records 1 and 2, the second row displays records 3 and 4, etc.?

With FileMaker, the answer is usually “Yes!”


Didier Daglinckx's insight:

Also look at https://blog.beezwax.net/2018/05/15/master-detail-layouts-in-filemaker/

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

FileMaker Audio Player Integration

FileMaker Audio Player Integration | Learning Claris FileMaker | Scoop.it
Using JavaScript in FileMaker brings great functionality.

 

In this post and video, we will review how to integrate a FIleMaker Audio Player.

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Building a Multilingual FileMaker App

Building a Multilingual FileMaker App | Learning Claris FileMaker | Scoop.it

New #FileMaker Weetbicks article on Building Multi-Lingual Applications, check it out, thanks for reading!

 

Demo file included.

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Learn FileMaker Pro : Build JSONGetElement Path (+ file)

Learn FileMaker Pro : Build JSONGetElement Path (+ file) | Learning Claris FileMaker | Scoop.it

A free database demonstrates how to format a path that references a nested JSON object value.

JSON functions were introduced in FileMaker 16 as a subset of Text Functions.

These functions create and manipulate JSON objects, which contain multiple pieces of data stored in a structured text format sometimes referred to as an array or record.

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

FileMaker 16 - Dynamic Data Source |FileMaker Community

FileMaker 16 - Dynamic Data Source |FileMaker Community | Learning Claris FileMaker | Scoop.it

Do you have a FileMaker solution that you want to sell to other people and are wondering how to maintain and update a solution like that?

 

With FileMaker 16 introducing the ability to dynamically set external data sources with a variable, doing that has never been easier.

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Recipe database on FileMaker Go | YouTube (1'17")

I recently created a simple recipe database using FileMaker Pro 12, which is optimized for use on the iPad with FileMaker Go. This is a quick run-through of the database.


I wrote an article on the process:
http://peterhebert.com/articles/creat...


You can download the database on GitHub:
https://github.com/peterhebert/FileMa...

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

How to use arrow keys for navigation in FileMaker list layouts?

How to use arrow keys for navigation in FileMaker list layouts? | Learning Claris FileMaker | Scoop.it

Forget your mouse and work only with the keyboard


In FileMaker list layouts, the keyboard can be used to switch between fields, but not between different records. 

Thus, if you want to edit a certain field in several records of a list, you have to reach for the mouse for each change to a different record. 

This is cumbersome. Here is a technique to use the arrow keys on the keyboard to navigate in a list.

Didier Daglinckx's insight:
A great way to improve your FileMaker databases !
No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Like a Boss: The FileMaker Join table

Like a Boss: The FileMaker Join table | Learning Claris FileMaker | Scoop.it
Knowing how to use a FileMaker Join table ( though not exclusive to FileMaker) can solve many data-model related questions for us.

As we fiddle with the Entity Relationship Diagram to work out the exact relationship of entities for our custom apps, we can rely on this join table technique to properly structure seemingly complex data models.

 

Let’s take a look at how this concept is used in our work.

 

...

Didier Daglinckx's insight:

Also look at the video and the demo database.

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

8 Features required in a Workflow Management Software | FileMaker

8 Features required in a Workflow Management Software | FileMaker | Learning Claris FileMaker | Scoop.it
Managing daily business chores in an organized and efficient manner is no more an easy task.

So it becomes imperative for organizations to invest in customized workflow management systems which can help in scaling up production.

Also, since the kind of tasks involved in every organization differs, the one size fits all is now a legacy.

This article throws light on some of the most important features which should be a part of WMS (Workflow Management Software).

 

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Days to Go Countdown Timer App for iPhone Created with FileMaker

Days to Go Countdown Timer App for iPhone Created with FileMaker | Learning Claris FileMaker | Scoop.it
Part of the fun of going on a vacation, celebrating a birthday/anniversary, enjoying Christmas or any special event in your life is the anticipation of it and preparation for it.

Knowing how far it is away and counting down to the day you leave, see your friends, or open your gifts can be a lot of fun.

fmDaysToGo is a free app for your iPhone or iPad created using FileMaker.

FileMaker Go is an iOS mobile app that enables anyone with FileMaker to create and deploy apps easily.

FileMaker Go has been downloaded more than 4 million times on the Apple app store.

 

...

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Form Letters in Browse | The Philosophy of FileMaker

Form Letters in Browse | The Philosophy of FileMaker | Learning Claris FileMaker | Scoop.it
Empowering users of your solution to create their own form letters is life-changing.

 

No longer do they have to contact the developer, explain their needs and go through a back-and-forth testing stage.

The developer just designs a single interface that allows the user to create, save, edit and delete their own form letters.

It's really not that hard to program either.

You just need some global fields, a calculation and a couple of scripts for the foundation of this technique.

 

This approach seems like less income for the developer but that's shortsighted.

 

I always say happy clients equal more business!

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Create a JavaScript Timeline Web Page using FileMaker

Create a JavaScript Timeline Web Page using FileMaker | Learning Claris FileMaker | Scoop.it

... Doug Alder of HomeBase Software posted a FileMaker solution that allowed a FileMaker user to easily compile and export interactive timelines for use on the web ...

 

Read how to do it ... or just watch the video

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

3 Examples for a multilingual Filemaker solution | FM Starter

3 Examples for a multilingual Filemaker solution | FM Starter | Learning Claris FileMaker | Scoop.it

To create a multilingual Filemaker solution at first sight seems to trigger a lot of extra work.

 

But there are many benefits – even for single language solutions:

 

  • All texts are managed in a table
  • Any number of languages
  • Multilingual interfaces
  • Multilingual value lists

 

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

FullCalendarIO – a Javascript/HTML Calendar for FileMaker Pro

FullCalendarIO – a Javascript/HTML Calendar for FileMaker Pro | Learning Claris FileMaker | Scoop.it

I have been looking for a Web Viewer calendar module to add to my FileMaker solutions.

 

There are some great paid options out there including:

 

  • SoSimple Calendar
  • FMCalendar
  • SeedCode Calendar


Wonderful as these solutions are, they are often more than I need and can add to the cost of a solution.

 

I just wanted something simple, more than you can do in FileMaker only, but not as much as the paid modules cost, so when I saw that there was ...

 

Read more on base.net post

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

FileMaker Sample database (FREE)

FileMaker Sample database (FREE) | Learning Claris FileMaker | Scoop.it

We understand that to run a start-up company, you need a simple and cost effective solution which can help your growth and control your expenses. Start-up solution will help start your business in minutes.


Try a FREE Start-up Sample Database and if you like it just add the styled main business printing resources

We understand that to run a start-up company, you need a simple and cost effective solution which can help your growth and control your expenses.


Start-up solution will help start your business in minutes.


Try a FREE Start-up Sample Database and if you like it just add the styled main business printing resources.

No comment yet.