Level: Intermediate, Version: FM 20.3 or later

January 2024 FM-DiSC Presentation

Here are resources re: my January 12th FM-DiSC presentation.

Layout Calculations

Generating Spreadsheets with LibXL

YouTube recording of meeting

Level: Intermediate, Version: FM 20.3 or later

Layout Calculations in FileMaker 20.3

Update 12 Dec 2023: this article has been updated as per my exchanges with Fabrice Nordmann in the comments section below. Thank you Fabrice for the reality check.

This is a follow up to last month’s article, Layout Calculations in FileMaker 20.2, and will assume the reader is familiar with that material. Today we will be taking a look at some changes to Layout Calculation behavior in the newly-released FileMaker 20.3.

#1. Calculation Result Type Can Now Be Specified

We can now specify the result type for a layout calculation…

…whereas in FM 20.2, the result type could only be text.

Initially I was under the impression that this would yield benefits when applying, for example, date specific formatting options, but as Fabrice points out, the formatting behavior is identical regardless of what you do with the result type. Continue reading “Layout Calculations in FileMaker 20.3”