News, tips, advice, ideas, experience…
Showing 21 Results for "intermediate"
Show all articles

Automated Greenhouse Climate Control

Automated Greenhouse Climate Control - Preview Image

As a little boy I grew tomatoes and some herbs in pots on balcony (because we didn’t have a garden at that time). Over time my hobby evolved into growing vegetables in a greenhouse. Since I also like technology and automation, now many of the repeating processes are controlled by Claris FileMaker, Raspberry Pi, Hardwario, LoRa, Node-RED, etc.

FileMaker 19 Performance Lab and Compatibility

FileMaker 19 Performance Lab and Compatibility - Preview Image

Claris has released FileMaker 19. We have tested all our products and are happy to confirm that they all work fine with the new version, only iOS versions of our plug-ins need to be updated for the new iOS App SDK. Now we are preparing our performance lab to test FileMaker 19 performance and compare it to the previous versions.

Claris Connect integrates CRM with Mailchimp

Claris Connect integrates CRM with Mailchimp - Preview Image

Claris has recently released Claris Connect. It’s an integration platform provided as a cloud-based service, letting you easily connect many different apps and make the data smoothly flow between them. To show you how it works, I have prepared a short demo using Claris Connect to integrate a FileMaker based CRM with Maichimp.

RFID and NFC are on the Rise

RFID and NFC are on the Rise - Preview Image

You may have already seen my hardware integration demo where I combined iPads, iPhones, motors, barcodes, RFID, digital scale, mobile receipt printer, and payment cards. Although everyone loved the automated moving parts built from LEGO, the after-session questions and discussions were actually mostly focused on RFID and NFC.

Life before and after Xgode

Life before and after Xgode - Preview Image

We can build native iOS apps with the FileMaker platform but we struggled doing that too often. Xgode has changed this for us, and now it is not an exception when we build a FileMaker based native app more than five times on the same day. Why is the life after Xgode so different from the life before it?

Google Maps become affordable

Google Maps become affordable - Preview Image

Since the introduction of WebViewer, Google Maps were quite popular in FileMaker solutions. What many FileMaker developers may have missed though is that in most cases they were using Google Maps API illegally and Google could ban their API key or IP address from accessing the feature at any time.

Perform Script On Server

Perform Script On Server - Preview Image

The idea of being able to off-load time consuming tasks from FileMaker Pro to FileMaker Server is as old as the scripting abilities of FileMaker Pro, which were introduced with the FileMaker Pro 3 release. But it was the FileMaker Server 13 that finally made this idea easy to implement.

Text or Numbers - What's Faster

Text or Numbers - What's Faster - Preview Image

One of the questions I am getting from time to time since I testing FileMaker performance is whether there is any significant difference between performance of text and number fields, So I tested it and discovered that there is even a case when indexed field can be slower than an undindexed one.

Optimization Madness

Optimization Madness - Preview Image

In May, I participated in Pause[x]Berlin 2013, a European format of the popular unconference Pause On Error, organized for FileMaker developers by FileMaker developers.. There I presented a session called Optimization Madness focused on optimizing performance of FileMaker solutions.

Why is FileMaker 12 slow?

Why is FileMaker 12 slow? - Preview Image

A lot has been written and said since FileMaker 12 was released about its speed, compared to FileMaker 11. Emotions left aside, if I was supposed to compile all the recent findings into a single brief message, I would say that some people find FileMaker 12 slower than FileMaker 11 while others experience improved performance.

Marvelous Optimization #3 - Faster Imports

Marvelous Optimization #3 - Faster Imports - Preview Image

This example demonstrates that even a single-step script can be optimized. You just have to think a little bit out of the box... I was showing this as a surprise in my session Marvelous Optimizations at Pause On Error [x] London 2011. I used a sample file with 25 fields and 5,000 records and imported these records 5 times in a row in just 13s.

Marvelous Optimization #2

Marvelous Optimization #2 - Preview Image

The second example I was showing in my session Marvelous Optimizations at Pause On Error [x] London 2011 was the script for selecting Random Set of Records. I found this example in the FileMaker Knowledge Base and optimized it to run at least 158 times faster when selecting 10 random records out of 50,000.

Debugging Scripts by Writing to Event.log

Debugging Scripts by Writing to Event.log - Preview Image

This is a fresh story of me spending hours trying to fix a technical issue and accidentally revealing a gold nugget. A few days ago one of my nightly server-side scripts stopped working without any apparent reason. But when I tried to run the script in FileMaker Pro it worked just fine. I really needed a way to debug the script on the server.

Random Set of Records (optimized)

Random Set of Records (optimized) - Preview Image

I noticed that one of the articles updated in the official FileMaker Knowledge Base on September 23, 2011 was explaining how to select a random set of records in a FileMaker database. I was wondering how fast the currently recommended technique is and whether I can make it faster with the help of FM Bench.

Infinite Hierarchy

Infinite Hierarchy - Preview Image

Last week Hal Gumbert mentioned on Twitter that he was “working on a FileMaker quote to display and edit a BOM ( Build of Materials ) that can go 9 levels deep.” Probably the most efficient and user friendly way to implement this is using a tree view with collapsible/expandable items.

By completing and sending the form you agree that 24U s.r.o., a company established under the laws of the Czech Republic, with its registered office: Zvole u Prahy, Skochovická 88, CZ-25245, registered in the Commercial Register with the Municipal Court in Prague, section C, inset 74920 will use your personal data contained in the form for the purpose of sending 24U’s news, updates and other commercial communications. Providing 24U with personal data for the said purpose is optional. Details on personal data processing and on your rights connected therewith are contained in 24U’s Privacy Policy.

Loader Image