# \#custom-function **URL:** https://the.fmsoup.org/tag/custom-function/398.md [Latest](https://the.fmsoup.org/latest.md) · [Categories](https://the.fmsoup.org/categories.md) · [Tags](https://the.fmsoup.org/tags.md) --- ## [Custom Function than handles field reference OR List of values?](https://the.fmsoup.org/t/custom-function-than-handles-field-reference-or-list-of-values/5188)
**Author:** [@xochi](https://the.fmsoup.org/u/xochi)\ **Replies:** 4\ **Last updated:** [December 22, 2025, 5:31pm UTC](https://the.fmsoup.org/t/custom-function-than-handles-field-reference-or-list-of-values/5188 "2025-12-22T17:31:51Z")
Re: Similar to Sumif got me thinking about how Custom Functions handle field references. My goal is to have a single Custom Function which can handle either a field reference to a related table, OR a List of values. Is… --- ## [Register custom functions with MBS Plugin](https://the.fmsoup.org/t/register-custom-functions-with-mbs-plugin/5011)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 1\ **Last updated:** [August 29, 2025, 6:47am UTC](https://the.fmsoup.org/t/register-custom-functions-with-mbs-plugin/5011 "2025-08-29T06:47:36Z")
With MBS FileMaker Plugin 15.3 we allow you to dynamically register custom function via plugin functions. Yes, make your own functions on the fly and use them in all your database files. Instead of defining custom functi… --- ## [How to archive checkboxes & their values from Value Lists?](https://the.fmsoup.org/t/how-to-archive-checkboxes-their-values-from-value-lists/4687)
**Author:** [@jprinter](https://the.fmsoup.org/u/jprinter)\ **Replies:** 7\ **Last updated:** [March 7, 2025, 2:13am UTC](https://the.fmsoup.org/t/how-to-archive-checkboxes-their-values-from-value-lists/4687 "2025-03-07T02:13:50Z")
I've got a Contact Management file that a developer helped set up for me, and I'm trying to archive certain checkboxes and their respective values, and replace old checkboxes with new ones. I don't want to archive the co… --- ## [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… --- ## [Get All Get Functions](https://the.fmsoup.org/t/get-all-get-functions/3508)
**Author:** [@Malcolm](https://the.fmsoup.org/u/Malcolm)\ **Replies:** 5\ **Last updated:** [April 7, 2024, 6:04pm UTC](https://the.fmsoup.org/t/get-all-get-functions/3508 "2024-04-07T18:04:39Z")
Do you ever want a complete snapshot of the current file state? The following code creates a JSON formatted snapshot of every GET function for FileMaker v19.6.3, with the exception of Get(DocumentsPathListing). You can… --- ## [How can I modify the custom function and include particular fields?](https://the.fmsoup.org/t/how-can-i-modify-the-custom-function-and-include-particular-fields/3761)
**Author:** [@Saeed](https://the.fmsoup.org/u/Saeed)\ **Replies:** 2\ **Last updated:** [October 31, 2023, 6:43pm UTC](https://the.fmsoup.org/t/how-can-i-modify-the-custom-function-and-include-particular-fields/3761 "2023-10-31T18:43:50Z")
Hi all, I'm curious if it's possible to customize the following function by incorporating specific fields, such as (First\_name, Lastname, Nationality, etc). /\* Added exclusions parameter to avoid script \*/ Let ( \[ ~t… --- ## [Calculation formatting function with ƒ button for custom function and calculation dialogs](https://the.fmsoup.org/t/calculation-formatting-function-with-button-for-custom-function-and-calculation-dialogs/3719)
**Author:** [@weetbicks](https://the.fmsoup.org/u/weetbicks)\ **Replies:** 5\ **Last updated:** [September 27, 2023, 9:58am UTC](https://the.fmsoup.org/t/calculation-formatting-function-with-button-for-custom-function-and-calculation-dialogs/3719 "2023-09-27T09:58:00Z")
\* Added calculation formatting function with ƒ button for custom function and calculation dialogs. Love this! So excited to finally see something like this in the function. Obviously this one is going to be rather dif… --- ## [CF for Returning ExecuteSQL results as JSON](https://the.fmsoup.org/t/cf-for-returning-executesql-results-as-json/2403)
**Author:** [@steve\_ssh](https://the.fmsoup.org/u/steve_ssh)\ **Replies:** 39\ **Last updated:** [June 29, 2023, 7:25pm UTC](https://the.fmsoup.org/t/cf-for-returning-executesql-results-as-json/2403 "2023-06-29T19:25:17Z")
TLDR: This post shares a small set of custom functions which make it easy to return results from ExecuteSQL as well-formed JSON. Some Details: The functions require v.16 of FMP or later The functions are designed wi… --- ## [Custom Function - Corrupted?](https://the.fmsoup.org/t/custom-function-corrupted/3465)
**Author:** [@bowdendata](https://the.fmsoup.org/u/bowdendata)\ **Replies:** 4\ **Last updated:** [March 23, 2023, 2:10pm UTC](https://the.fmsoup.org/t/custom-function-corrupted/3465 "2023-03-23T14:10:06Z")
I have a custom function that I can't edit. It has worked all along and continues to work. I would normally create a new version, go to the places it is used and change to the new one, then delete the old one. It has bee… --- ## [What's a Custom Function you've created that you think should be built-in to FileMaker?](https://the.fmsoup.org/t/whats-a-custom-function-youve-created-that-you-think-should-be-built-in-to-filemaker/3091)
**Author:** [@Malcolm](https://the.fmsoup.org/u/Malcolm)\ **Replies:** 35\ **Last updated:** [October 4, 2022, 1:54pm UTC](https://the.fmsoup.org/t/whats-a-custom-function-youve-created-that-you-think-should-be-built-in-to-filemaker/3091 "2022-10-04T13:54:04Z")
I use a lot of custom functions but there is one that I always include in every file. I have been using it for so long that I expect it to be in new files that don't have any custom functions. I think that I should donat… --- ## [What’s a Custom Function you’ve created that you think should be built-in to MBS Plugin?](https://the.fmsoup.org/t/what-s-a-custom-function-you-ve-created-that-you-think-should-be-built-in-to-mbs-plugin/3125)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 0\ **Last updated:** [October 3, 2022, 9:45am UTC](https://the.fmsoup.org/t/what-s-a-custom-function-you-ve-created-that-you-think-should-be-built-in-to-mbs-plugin/3125 "2022-10-03T09:45:43Z")
Inspired from the other threadd\](What's a Custom Function you've created that you think should be built-in to FileMaker? - #35 by Malcolm), let me ask what custom functions could be converted to plugin functions. That h… --- ## [Query custom functions automatically in FileMaker](https://the.fmsoup.org/t/query-custom-functions-automatically-in-filemaker/2741)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 0\ **Last updated:** [February 6, 2022, 8:27am UTC](https://the.fmsoup.org/t/query-custom-functions-automatically-in-filemaker/2741 "2022-02-06T08:27:10Z")
We have clients with lots of custom functions in various FileMaker databases. How would you automate this to track custom functions used in various files? For MBS FileMaker Plugin 12.1 we got two new functions for thi… --- ## [Simple Custom Function to flatten JSON Object](https://the.fmsoup.org/t/simple-custom-function-to-flatten-json-object/2265)
**Author:** [@steve\_ssh](https://the.fmsoup.org/u/steve_ssh)\ **Replies:** 0\ **Last updated:** [June 27, 2021, 10:27pm UTC](https://the.fmsoup.org/t/simple-custom-function-to-flatten-json-object/2265 "2021-06-27T22:27:00Z")
Hello, In an exchange on this post, I shared a custom function which I once wrote, which can be used to "flatten" a JSON object. The flattened output can take a few different forms, including: A CR-delimited list of … --- ## [Can you Trust your Custom Function Library?](https://the.fmsoup.org/t/can-you-trust-your-custom-function-library/1995)
**Author:** [@Malcolm](https://the.fmsoup.org/u/Malcolm)\ **Replies:** 23\ **Last updated:** [April 16, 2021, 7:09pm UTC](https://the.fmsoup.org/t/can-you-trust-your-custom-function-library/1995 "2021-04-16T19:09:54Z")
I've just discovered that an issue that I have been troubleshooting was being caused by a custom function which was producing the wrong result. I do a lot of error-logging and use scripts to do in-line error logging but… --- ## [Time field entry for duration](https://the.fmsoup.org/t/time-field-entry-for-duration/1787)
**Author:** [@cpking](https://the.fmsoup.org/u/cpking)\ **Replies:** 13\ **Last updated:** [March 4, 2021, 12:27pm UTC](https://the.fmsoup.org/t/time-field-entry-for-duration/1787 "2021-03-04T12:27:18Z")
An interesting subject came up in another post about this. I have a list of songs in a table. One of the fields is duration, which is entered-not calculated. The field is set up as a Time field. During data entry, t…