Category: Uncategorized

FileMaker, Office365 and OAuth 2.0

FileMaker, Office365 and OAuth 2.0

30/8/2019 | Jeroen Aarts Introduction Do you want to access a User’s calendar? Or maybe send e-mails from within FileMaker that appear in the Sent Items folder, without using an e-mail client? With the Microsoft Graph API you can connect to resources on Office 365, its Azure Portal and Windows. This allows powerful integrations from […]

Monitoring FileMaker Server with Zabbix

Monitoring FileMaker Server with Zabbix

11/2/2020 | Jeroen Aarts Cloud, On premises and hybrid installations of FileMaker Server Claris is moving towards towards a Saas (Software as a Service) model. The strategy is Cloud first – but not Cloud only. Here at ClickWorks we fully support this. Although we also believe on-premises or “own-cloud” solutions are not going to disappear […]

Conditional Formatting on radio buttons

Conditional Formatting on radio buttons

Conditional Formatting is an often used technique in FileMaker. It allows to distinquish types of data very easily. One case where it is often used is to review a list of invoices. By conditional formatting you can easily set the text color of invoices that are late in red, the ones that are paid in […]

Sliding menus in FileMaker

07/06/2019 | JanZelenka Introduction While FileMaker allows for some pretty decent interface design, web based applications are a few steps ahead when it comes to providing visually attractive user interface. Sometimes though, FileMaker solution developers can push the boundaries a bit further themselves. In this blog I will show you how to create sliding hamburger […]

Transactions Without Portals

Transactions Without Portals

18/09/2015 | Jan Zelenka SQL Transactions First, let’s have a quick overview of what SQL Transactions are. In a standard SQL based database system a Transaction is an Atomic Data Modification. This means that a Transaction is a guarantee of either all your changes being stored in the database, either none of them. Typically you […]

New interface elements in FileMaker 14

New interface elements in FileMaker 14

22/05/2015 | Michel Beyaert As FileMaker 14 was released, developers have a lot of new tools at their disposal. Since version 12 a lot of great improvements regarding the interface have been released. New objects such as popover-buttons or slide-controls, for example, but also the implementation of themes and styles create new opportunities. There are […]

FileMaker: Export to Excel with custom column names

FileMaker: Export to Excel with custom column names

19/12/2014 | Jeroen Aarts Is there a problem? How often did your customer or your boss come to you with this question: “I want an Excel export from FileMaker, but I want readable column names and not the mess you usually put in there!”. As long as the export is not of too much of […]

Rename container files

02/12/2014 | Jan Stieperaere What? Rename your container files without exporting/importing. Fully native FM13. Works in WebDirect, Server, Go, … How It Works? This technique makes use of FM13’s new Base64Encode() & Base64Decode() functions. When decoding a base64 string, filemaker gives you an optional parameter to specify a filename. This is the key to rename […]