# \#calculations **URL:** https://the.fmsoup.org/tag/calculations/198.md [Latest](https://the.fmsoup.org/latest.md) · [Categories](https://the.fmsoup.org/categories.md) · [Tags](https://the.fmsoup.org/tags.md) --- ## [Genesis story - FMScriptBridge plugin](https://the.fmsoup.org/t/genesis-story-fmscriptbridge-plugin/5724)
**Author:** [@FMScriptBridge](https://the.fmsoup.org/u/FMScriptBridge)\ **Replies:** 0\ **Last updated:** [August 31, 2026, 3:31pm UTC](https://the.fmsoup.org/t/genesis-story-fmscriptbridge-plugin/5724 "2026-08-31T15:31:06Z")
Hi everyone, I'd like to request a channel for FMScriptBridge plugin I developed. Happy to answer any questions or share a preview first if that's useful. I'm in private aviation, running FileMaker in-house solutions f… --- ## [Why would a calculated field be FASTER than an indexed number field?](https://the.fmsoup.org/t/why-would-a-calculated-field-be-faster-than-an-indexed-number-field/5177)
**Author:** [@JasonMark](https://the.fmsoup.org/u/JasonMark)\ **Replies:** 3\ **Last updated:** [December 19, 2025, 4:27pm UTC](https://the.fmsoup.org/t/why-would-a-calculated-field-be-faster-than-an-indexed-number-field/5177 "2025-12-19T16:27:33Z")
I have this one calculation that is based off another calculation. I’m trying to speed it up, so I cached the first calculation manually, but for some reason when I run it on the indexed number field it’s SLOWER than the… --- ## [Control keys to move lines up and down](https://the.fmsoup.org/t/control-keys-to-move-lines-up-and-down/4962)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 4\ **Last updated:** [July 23, 2025, 7:54am UTC](https://the.fmsoup.org/t/control-keys-to-move-lines-up-and-down/4962 "2025-07-23T07:54:57Z")
Did you know, that FileMaker allows you to move lines up and down in ScriptWorkspace with cursor keys while control key is pressed? Pick a line and press down the control key and simultaneously press up or down cursor k… --- ## [Bizarre Auto-Enter Calculation Behavior for Numeric Global Fields Where Field Validation Calcs are Also Used](https://the.fmsoup.org/t/bizarre-auto-enter-calculation-behavior-for-numeric-global-fields-where-field-validation-calcs-are-also-used/4575)
**Author:** [@Dutchman](https://the.fmsoup.org/u/Dutchman)\ **Replies:** 16\ **Last updated:** [January 15, 2025, 4:43pm UTC](https://the.fmsoup.org/t/bizarre-auto-enter-calculation-behavior-for-numeric-global-fields-where-field-validation-calcs-are-also-used/4575 "2025-01-15T16:43:53Z")
Hi to everyone, I’ve been trying to figure out some really bizarre behavior for a set of global fields I’ve set up for purposes of taking user inputs that are then translated into parameters for eSQL functions and Execu… --- ## [Errors for decimal formats: data import, decimal comma](https://the.fmsoup.org/t/errors-for-decimal-formats-data-import-decimal-comma/4492)
**Author:** [@traut](https://the.fmsoup.org/u/traut)\ **Replies:** 7\ **Last updated:** [November 24, 2024, 2:09pm UTC](https://the.fmsoup.org/t/errors-for-decimal-formats-data-import-decimal-comma/4492 "2024-11-24T14:09:51Z")
Hi, I have set some fields from import and calculation. The system setting number format on macOS is 1.234,56 - decimal comma However, the number fields act strangely and do read 123,4 as 1234. So does the index. When… --- ## [Finding the most recent modification date of all related records](https://the.fmsoup.org/t/finding-the-most-recent-modification-date-of-all-related-records/4474)
**Author:** [@Susurrus](https://the.fmsoup.org/u/Susurrus)\ **Replies:** 11\ **Last updated:** [November 23, 2024, 11:03am UTC](https://the.fmsoup.org/t/finding-the-most-recent-modification-date-of-all-related-records/4474 "2024-11-23T11:03:28Z")
What is an efficient way to determine the most recent modification timestamp across a primary record and all its related records? For example, if the primary record was modified on 11/1/24, and one related record was mod… --- ## [MBS MapView - Distance and Radius](https://the.fmsoup.org/t/mbs-mapview-distance-and-radius/4475)
**Author:** [@BoloMan28](https://the.fmsoup.org/u/BoloMan28)\ **Replies:** 1\ **Last updated:** [November 15, 2024, 9:29pm UTC](https://the.fmsoup.org/t/mbs-mapview-distance-and-radius/4475 "2024-11-15T21:29:23Z")
Hello, I love the MBS Plugin! I'm using MapView.PlanRoute and have 2 questions. 1 - How can I calculate DISTANCE between 2 gps points? 2 - Using MapView am I able to determine if a gps point is within a Radius? Thank… --- ## [New blog post: inside my mind while writing a function](https://the.fmsoup.org/t/new-blog-post-inside-my-mind-while-writing-a-function/4459)
**Author:** [@FabriceN](https://the.fmsoup.org/u/FabriceN)\ **Replies:** 4\ **Last updated:** [November 11, 2024, 11:31pm UTC](https://the.fmsoup.org/t/new-blog-post-inside-my-mind-while-writing-a-function/4459 "2024-11-11T23:31:26Z")
Hi, Here's a really long blog post of a new kind. Trying to share, not a technique, but a way of thinking. If you have time, I'd really like to know if you find this interesting (Noes are as valuable are Ayes) Thank yo… --- ## [Little tidbits from the FileMaker conference](https://the.fmsoup.org/t/little-tidbits-from-the-filemaker-conference/4355)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 5\ **Last updated:** [October 12, 2024, 12:19pm UTC](https://the.fmsoup.org/t/little-tidbits-from-the-filemaker-conference/4355 "2024-10-12T12:19:53Z")
Back from the conference in Liechtenstein, I wrote down a few of the tidbits we learnt. Missing serial numbers If you use serial numbers for new records in FileMaker, you may notice that sometimes the serial numbers hav… --- ## [Data Viewer extensions in MBS Plugin](https://the.fmsoup.org/t/data-viewer-extensions-in-mbs-plugin/3302)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 9\ **Last updated:** [May 17, 2024, 8:20am UTC](https://the.fmsoup.org/t/data-viewer-extensions-in-mbs-plugin/3302 "2024-05-17T08:20:14Z")
Let us show you nine features of MBS FileMaker Plugin around the data viewer in FileMaker. While all are available on macOS, only one is also available on Windows: Toggle data viewer To show or hide the data viewer, jus… --- ## [Self Relationship](https://the.fmsoup.org/t/self-relationship/4114)
**Author:** [@pfro](https://the.fmsoup.org/u/pfro)\ **Replies:** 5\ **Last updated:** [May 9, 2024, 9:17pm UTC](https://the.fmsoup.org/t/self-relationship/4114 "2024-05-09T21:17:26Z")
Hi all, I run a manufacturing outfit and we do everything with filemaker since 15 years. We produce cosmetics. We have a product table which has a manyToMany self-join via a "components" table. Because products are m… --- ## [Custom progress bars for FileMaker](https://the.fmsoup.org/t/custom-progress-bars-for-filemaker/4086)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 0\ **Last updated:** [April 11, 2024, 8:49am UTC](https://the.fmsoup.org/t/custom-progress-bars-for-filemaker/4086 "2024-04-11T08:49:31Z")
At the Spanish developer conference an attendee asked me about whether we have something to show a nice colored progress bar in a portal, preferable possible for Web Direct, too. After a bit of research, I found an easy… --- ## [Building a Mermaid.js Gantt Chart in a Filemaker Web Viewer](https://the.fmsoup.org/t/building-a-mermaid-js-gantt-chart-in-a-filemaker-web-viewer/4081)
**Author:** [@greenflux](https://the.fmsoup.org/u/greenflux)\ **Replies:** 5\ **Last updated:** [April 9, 2024, 9:20am UTC](https://the.fmsoup.org/t/building-a-mermaid-js-gantt-chart-in-a-filemaker-web-viewer/4081 "2024-04-09T09:20:27Z")
Hey FileMaker Devs! I've been using a lot of different JS libraries in Appsmith lately, and I wanted to see if I could get the same thing working in FileMaker. This was my first attempt at using a web viewer for anything… --- ## [Local $variable inside a Single Step button calculation](https://the.fmsoup.org/t/local-variable-inside-a-single-step-button-calculation/3982)
**Author:** [@xochi](https://the.fmsoup.org/u/xochi)\ **Replies:** 7\ **Last updated:** [February 18, 2024, 6:21pm UTC](https://the.fmsoup.org/t/local-variable-inside-a-single-step-button-calculation/3982 "2024-02-18T18:21:25Z")
I think I've found a bug in Replace Field Contents where there's a difference between a Button that runs a script vs. a button that has a single script step. I'd like another pair of eyes on it. The goal is to take the… --- ## [Optimization ideas for Draco calculation engine](https://the.fmsoup.org/t/optimization-ideas-for-draco-calculation-engine/3943)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 11\ **Last updated:** [February 1, 2024, 3:45pm UTC](https://the.fmsoup.org/t/optimization-ideas-for-draco-calculation-engine/3943 "2024-02-01T15:45:58Z")
Since HOnza posted about his Initiative ’24 about making FileMaker calculations quicker, I spend some time thinking on how to do this practically. Like what could be optimized if Claris puts work into their calculation e… --- ## [Format button for FileMaker](https://the.fmsoup.org/t/format-button-for-filemaker/3799)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 2\ **Last updated:** [January 19, 2024, 10:53am UTC](https://the.fmsoup.org/t/format-button-for-filemaker/3799 "2024-01-19T10:53:48Z")
We got a new format button labeled with "ƒ" for the calculation dialog in FileMaker on macOS. We parse the formula, detect which brackets belong together and then output the formula with additional whitespacing. Let'… --- ## [How does work the Count() function?](https://the.fmsoup.org/t/how-does-work-the-count-function/3481)
**Author:** [@planteg](https://the.fmsoup.org/u/planteg)\ **Replies:** 10\ **Last updated:** [December 30, 2023, 5:07pm UTC](https://the.fmsoup.org/t/how-does-work-the-count-function/3481 "2023-12-30T17:07:36Z")
Hi, the question says it all. The documentation reads Returns the number of valid, non-blank values in a field. What is a value in there ? It's Friday afternoon, and my mind just can't understand. Many thanks --- ## [Data structures in MBS Plugin](https://the.fmsoup.org/t/data-structures-in-mbs-plugin/3819)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 1\ **Last updated:** [December 3, 2023, 11:59am UTC](https://the.fmsoup.org/t/data-structures-in-mbs-plugin/3819 "2023-12-03T11:59:51Z")
Let us show you today the various data structures we have in MBS FileMaker Plugin and how to use them. QuickList Dictionary Matrix JSON References SQL Result In general you can keep huge amounts of data in memory to q… --- ## [Incorrect search results on calculation field](https://the.fmsoup.org/t/incorrect-search-results-on-calculation-field/3802)
**Author:** [@BrianB](https://the.fmsoup.org/u/BrianB)\ **Replies:** 3\ **Last updated:** [December 1, 2023, 7:46pm UTC](https://the.fmsoup.org/t/incorrect-search-results-on-calculation-field/3802 "2023-12-01T19:46:39Z")
Hello, I am getting incorrect results when searching a calculation field in our database. We have been running client/server in our office for many years, first on a Mac network, now a PC network. We're still on FM 11… --- ## [MBS Function calls in blue](https://the.fmsoup.org/t/mbs-function-calls-in-blue/3806)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 0\ **Last updated:** [November 22, 2023, 7:56am UTC](https://the.fmsoup.org/t/mbs-function-calls-in-blue/3806 "2023-11-22T07:56:02Z")
When you enter a MBS function in a calculation on macOS, we show MBS in blue. The function name entered behind it as parameter turns blue if the function is known to the plugin. It will show in red while the function nam… --- ## [How long do you wait for Insert From URL to finish?](https://the.fmsoup.org/t/how-long-do-you-wait-for-insert-from-url-to-finish/3743)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 0\ **Last updated:** [October 14, 2023, 8:00am UTC](https://the.fmsoup.org/t/how-long-do-you-wait-for-insert-from-url-to-finish/3743 "2023-10-14T08:00:04Z")
Did you know you can run CURL commands in background with MBS FileMaker Plugin? Let's start with a simple Insert From URL script like the following one. $url has the URL to query and $json the data to send to whatever w… --- ## [Layout Calculations in FM20.2.1](https://the.fmsoup.org/t/layout-calculations-in-fm20-2-1/3727)
**Author:** [@FileKraft](https://the.fmsoup.org/u/FileKraft)\ **Replies:** 9\ **Last updated:** [October 6, 2023, 4:24pm UTC](https://the.fmsoup.org/t/layout-calculations-in-fm20-2-1/3727 "2023-10-06T16:24:38Z")
Found out that some calculations are not supported when used in a layout calculation: Tried this: LEt ( \[ dp = Get ( DesktopPath ) ; tp = Get ( TemporaryPath ) \] ; List ( "DocumentsPath: " ; dp ; "-" ; "TempPat… --- ## [What triggers an unsaved calculation field to revaluate](https://the.fmsoup.org/t/what-triggers-an-unsaved-calculation-field-to-revaluate/3388)
**Author:** [@planteg](https://the.fmsoup.org/u/planteg)\ **Replies:** 8\ **Last updated:** [March 1, 2023, 9:20am UTC](https://the.fmsoup.org/t/what-triggers-an-unsaved-calculation-field-to-revaluate/3388 "2023-03-01T09:20:04Z")
Hello all, I have an app that displays some fields according to the selected language. There are two languages, French and English. When the user change language, I need to update the display according to the new set la… --- ## [Nuanced data-type behavior change in FM Pro calculation engine, v.19.6.1](https://the.fmsoup.org/t/nuanced-data-type-behavior-change-in-fm-pro-calculation-engine-v-19-6-1/3331)
**Author:** [@steve\_ssh](https://the.fmsoup.org/u/steve_ssh)\ **Replies:** 3\ **Last updated:** [January 21, 2023, 5:00pm UTC](https://the.fmsoup.org/t/nuanced-data-type-behavior-change-in-fm-pro-calculation-engine-v-19-6-1/3331 "2023-01-21T17:00:04Z")
Hello, As best as I can tell, there is a small change in behavior in the FileMaker Pro calculation engine which occurred between v.19.5 and 19.6.1. Please note that I have not tested to see of this change occurs across… --- ## [How do you find the center point of multiple GPS coordinates](https://the.fmsoup.org/t/how-do-you-find-the-center-point-of-multiple-gps-coordinates/3256)
**Author:** [@eric.ha](https://the.fmsoup.org/u/eric.ha)\ **Replies:** 2\ **Last updated:** [December 12, 2022, 6:17pm UTC](https://the.fmsoup.org/t/how-do-you-find-the-center-point-of-multiple-gps-coordinates/3256 "2022-12-12T18:17:44Z")
Hello all! I'm trying to find a way to find the center point of multiple GPS coordinates pulled from a photo's meta data. I've found some python examples, but was curious what the FileMaker community has come up with. I… --- ## [Out of Memory Error](https://the.fmsoup.org/t/out-of-memory-error/3100)
**Author:** [@bdbd](https://the.fmsoup.org/u/bdbd)\ **Replies:** 2\ **Last updated:** [September 21, 2022, 2:40pm UTC](https://the.fmsoup.org/t/out-of-memory-error/3100 "2022-09-21T14:40:35Z")
Anyone know why the following produces an "out of memory" error? Let ( \[ A = "Name is "; B = GetValue (Substitute (GetFieldName (Contact::record\_\_ctl); "::"; "¶"); 2) \]; A & B ) --- ## [GetAsNumber Gotcha](https://the.fmsoup.org/t/getasnumber-gotcha/2825)
**Author:** [@bdbd](https://the.fmsoup.org/u/bdbd)\ **Replies:** 6\ **Last updated:** [March 30, 2022, 5:06pm UTC](https://the.fmsoup.org/t/getasnumber-gotcha/2825 "2022-03-30T17:06:34Z")
I may be late to the game… but I just came across a gotcha I thought would be good to share. GetAsNumber returns the numerical characters in a given string. In essence, this function is equivalent to Filter (textToFilte… --- ## [Our buttons to add or remove table occurrences](https://the.fmsoup.org/t/our-buttons-to-add-or-remove-table-occurrences/2694)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 2\ **Last updated:** [January 12, 2022, 10:51pm UTC](https://the.fmsoup.org/t/our-buttons-to-add-or-remove-table-occurrences/2694 "2022-01-12T22:51:17Z")
As you may know we have some tools in the plugin for macOS to make the live easier in FileMaker. For various dialogs to enter calculations we got check syntax and evaluate buttons. That is convenient to make a syntax che… --- ## [A calculation that drives me nuts](https://the.fmsoup.org/t/a-calculation-that-drives-me-nuts/2656)
**Author:** [@planteg](https://the.fmsoup.org/u/planteg)\ **Replies:** 12\ **Last updated:** [December 20, 2021, 8:25pm UTC](https://the.fmsoup.org/t/a-calculation-that-drives-me-nuts/2656 "2021-12-20T20:25:44Z")
Hi there, The title says it all. Background We have a FileMaker file that is the backend of a Web App made with Xojo. This Web App is used by the customers to create support tickets. These customers may access the Web… --- ## [Auto Complete Teaser](https://the.fmsoup.org/t/auto-complete-teaser/2621)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 1\ **Last updated:** [December 7, 2021, 12:30pm UTC](https://the.fmsoup.org/t/auto-complete-teaser/2621 "2021-12-07T12:30:18Z")
Let us tease all the FileMaker developers with a feature I work on for MBS FileMaker Plugin: Auto complete is coming for variables into the calculation dialogs for macOS when you type $ sign. Try it in 11.6pr1 or wa… [Next page](https://the.fmsoup.org/tag/calculations/198.md?match_all_tags=true&page=1&tags%5B%5D=calculations)