We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

Search the Community

Showing results for tags 'custom function'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16 Discussions
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions
  • FileMaker Platform
  • Dungeon


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker


  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 21 results

  1. FileMaker 16 introduced a collection of built-in functions for manipulating data serialized as JSON. This makes it easier for FileMaker applications to interact with many web services. This will also make JSON the de facto standard format for scripts within FileMaker to pass parameters and results to each other, improving code sharing within the FileMaker community. JSON does not have a broad palette of scalar data types to choose from: text, number, boolean, and null. Even with those, FileMaker's JSONGetElement function always returns a text result, even when the serialized JSON value is a number or boolean. So I made a handful of custom functions and scripts for sending and receiving typed data with JSON. The module is hosted on GitHub, or you can download it directly.
  2. Hello, If I have two lists : ListA Apples 20 Oranges 15 Pears 120 ListB Apples 13 Oranges 30 Nectarines 70 ... how can I end up to Apples 33 Oranges 45 Pears 120 Nectarines 70, with a custom function? Thank you!
  3. Version 1.0.0


    Being unsatisfied with solutions I found on the internet and wanting a solution without plugin I created a set of custom functions that can read a path out of a json-string. Syntax: json_path ( json-string ; path ) examples: json_path( $user_prefs ; "Privileges/Modules" ) json_path( $json_data ; "Menus/Menu[10]/MenuItem[5]/Label" )


  4. View File read json custom function without plugin, FileMaker only Being unsatisfied with solutions I found on the internet and wanting a solution without plugin I created a set of custom functions that can read a path out of a json-string. Syntax: json_path ( json-string ; path ) examples: json_path( $user_prefs ; "Privileges/Modules" ) json_path( $json_data ; "Menus/Menu[10]/MenuItem[5]/Label" ) Submitter macjos Submitted 09/30/2016 Category Samples FM Version FM Version: 14  
  5. I am using a custom function to format a number into currency format ( two decimals ). RoundDecimals(11.0) = 11.00 The problems occurs when I use a variable: $amount = 11.0 RoundDecimals($amount) = 11.11 Similarly, I get the same error using a string: RoundDecimals("11.0") = 11.11 Is there any tricks to get around this issue ? This is the custom function that I used (I replaced the comma for a dot and defaulted second parameter to 2): https://www.briandunning.com/cf/974
  6. I am having difficulty removing the .JPG extension from the file name of my imported pictures. The Pictures are actually students pictures saved with the student's ID Numbers. Example SLT-098-00034.jpg , SLT-088-11123.jpg I am trying to extract the real ID Numbers from the File names which should be in this format SLT/098/33322 Accomplishment So Far.. Using the Substitute function, Substitute (text; searchstring; replacestring) , I have been able to convert the file name from SLT-098-00034.jpg to SLT/098/00034.jpg Now, I want to remove the .jpg extension, but can't achieve that using the Substitute function.. Please is there a better way to achieve this?
  7. I was lucky to have gotten an example file, which was based on designing a Subscription system. I think eos was behind it because of the file name. However, the subscription system was based on just three types 1 month, Six Months and 12 Months... I have tried to modify the scripts so that I can have more types like: 1,2,3,4,5,6... Months ( Basically all the months), I end up messing the whole system up. Please what values can I actually modify with respect to the required month I want? Here is a copy of the file.. LDprototype_subscription_eosMOD.fmp12
  8. I was doing a bit of work for a client who is running FM9 clients, connecting to a file hosted on an FM11 server. I don't have FM9, so was doing development on FM11. I thought I had checked out that everything was compatible, but I somehow generated a calculation that doesn't evaluate on 9, but does on 11. The components of the calculations and custom functions used all appear to be innocuous... I am hoping someone here knows what I tripped up on. Here's the field calculation, and the 2 custom function definitions that it uses. The entire point of this calculation is to take a mish-mash text field that they have and make it sort nicely. For this bit I added, I'm just concerning myself with sorting some suffix numbers that occur between parentheses, e.g. 12345(A-1). Field calculation definition: Let ( [ _fileNum = Files::File Number ; //Position of 1st open/close parens, and then extract the text between them: _sParen = Position ( _fileNum ; "(" ; 1 ; 1 ) + 1; _eParen = Position ( _fileNum ; ")" ; 1 ; 1 ) ; _suffix = Middle ( _fileNum ; _sParen ; _eParen - _sParen) ; //Count the leading digits before any non-digit character, e.g. an alpha, or dash or space, etc. _count = CountPrefixDigits ( _suffix ; 0 ) ; //Remove extraneous characters (dash, space): _suffix = Substitute ( _suffix; ["-";""]; [" " ; ""] ) ; //Pad out the string to min 5 characters (helps 75-A sort next to 75): _suffix = _suffix & Left ( "!!!!!" ; 5 - Length (_suffix) ); //Reverse the character sequence (so the Code() call works out better): _suffix = ReverseString ( _suffix ) ]; _count & Code ( _suffix ) //prepend the digit count, but don't encode that count, just the rest of it ) -------------------- 'CountPrefixDigits ( aString ; aCounter )' custom function: If ( IsEmpty ( GetAsNumber ( Left ( aString ; 1 ) ) ) ; aCounter ; CountPrefixDigits ( Right ( aString ; Length ( aString) - 1 ) ; aCounter + 1 ) ) -------------------- 'ReverseString (aString)' custom function: If ( Length ( aString ) > 0 ; ReverseString ( Right ( aString ; Length ( aString ) - 1 ) ) & Left ( aString ; 1 ) ; Left ( aString ; 1 ) ) Thanks, Justin
  9. I have really tried to figure out this calculation by subtracting the birthday from the current date, I guess that didn't work. I just need to have a countdown to a contacts birthday. Please how do I go about this?
  10. Hi All, I have written one Custom Function To get the list of Product IDs from the current found set. Custom Function Name: GetProductIDs Parameter name : FountCount GetProductIDs ( FountCount ) = --------------------------------------------------------------------------------------------------------------------------------------------------------------- If ( FountCount > 0 ; GetProductIDs( FountCount - 1 ) & If ( FountCount = 1 ; ""; "¶") & GetNthRecord ( Products::Product_ID ; FountCount) ; "" ) --------------------------------------------------------------------------------------------------------------------------------------------------------------- Note: "Products::Product_ID" this is my product id field from my "Products" table. You can use any field which you want from your current found set. In the Calculation Field: just write following to get the result of custom function GetProductIDs ( Get ( FoundCount ) ) Regards, Trupti MetaSys Software Pvt. Ltd. India
  11. Hi I need help in creating a custom function to calculate a salary increases based on the Starting Monthly Salary. Here's my scenario; I have 2 Tables Employee --< Employee Pay The EMPLOYEE table will contain a Field with the Starting Salary; this will be the base value of the employee. Anytime the employee receives an increase, that will be added to the EMPLOYEE PAY table. In our organization, increases can come as a Flat amount or at times a percentage increase. Is it possible to create a Custom Function for this? What I had in mind was to have a Increase Type field in the Employee Pay table, and depending on the selection. Also, the calculation will be a sequential order by Effective Date of the increase. I'm a Novice when dealing with complicated Calculations. Any suggestions? Thank
  12. scripttriggers control

    hi everyone, I'm new to filemaker, looking at different video tutorials I've seen the possibility to create custom functions to simplify and optimize the script of my database. in particular it would be useful (not only to me) to create 4 custom functions to control trigger scripts: triggerAreActive triggerDisable triggerEnable triggerReset can anyone help me?
  13. Hi all I think I have this custom function in every database I use. Case ( Start < Number ; GetNthRecord ( field ; Start ) & ¶ & AppendNth ( field; Start + 1 ; Number ); Start = Number ; GetNthRecord ( field ; Start ) ) It is just standard practice for me to use it. I mostly use it to concatenate data from Portals into a single field for display. As it only concatenates one field, I usually create a calc of all the fields I want to display and then use AppendNth ( relate::field ; 1 ; Count ( relate::recid ) ) Is there a better way? It just occurred to me this afternoon, that I just automatically use the FM7 custom function. Is there an inbuilt function that I have overlooked? I am sure I could achieve this with ExecuteSQL too. Thanks in advance. ZP
  14. Let me first preface this by saying I am by no means an expert on Filemaker, more an enthusiast looking to save my small regional field hockey facility from purchasing an expensive shrink wrapped package. So... After searching high and low for a way in which to generate a sports leagues fixture, by using a combination of Custom Functions, Calculations and Scripting. I've also been working on my own to generate something that will get me closer to my goal. This forum post is VERY close, but I've come up with a few things that make for a little more flexibility. Also, the solution posted by Eos has an issue with calculating the fixtures for a league that has an odd number of teams. That being said some points within this solution have been invaluable in getting my solution to where it currently is, so a very big thanks to Eos for his assistance previously. Onto my solution... Posted Here There are two issues at this stage, no doubt more will pop up... 1) The Match List, which utilises a CF called UnorderedPairs found on Brian Dunning's site, is sequential meaning all the 1 | x values are generated first, and then the 2 | x values and so on... Instead the combinations need to come out in a series that allows each team to play only once, and balances the distribution of the fixtures over the time slots available during the season. Home and Away designations DO NOT Matter, since all games are played at a single venue, with the time being the only designation for each round of fixtures. 2) The Loop that creates the fixtures does not carry the previous values forward with the counter, so each round ends up being the same, the script needs to 'remember' the used values and then step forward to the next available value from the match list at the completion of each round. As an alternative, I have a Python Script that will create the schedule perfectly, but I have no idea how to integrate Python into a Filemaker Solution, so I've moved away from that, but I do still have the Script available should I need it. So if anyone out there is able to help out in that respect, please let me know. Any and all help is greatly appreciated Many Thanks
  15. A function to finds all the dates for a week day within an given date range. For example: We need to find what are the dates for the Thursdays in the date range starting from 1/1/2013 to 1/31/2013. In this case: The function would be defined as FindDay ("1/1/2014";"1/31/2014";5) Here the start date and end date in the function parameters are text. Here the 5 refers to the number that represents Thursday in the week. Output: 1/2/2014 1/9/2014 1/16/2014 1/23/2014 1/30/2014 And for the invalid dates passed as the function parameters would return "N" that refers to NULL. For Reference: Sunday: 1 Monday: 2 Tuesday: 3 Wednesday: 4 Thursday: 5 Friday: 6 Saturday: 7 FindDay Function Parameters : Parameters Type StartDate : Text EndDate : Text DayN : Number Function Body : Substitute ( If(GetAsDate(GetAsText(StartDate)) ≤ GetAsDate(GetAsText(EndDate)); Let( [ start = GetAsDate(GetAsText(StartDate)); end = GetAsDate(GetAsText(EndDate)); Day = DayN; Day1 = DayOfWeek(start); Diff = Day - Day1; FinalDay = If(Diff < 0;start - Abs(Diff) + 7;Start + Diff) ];If(FinalDay > end;"N"; FinalDay & ¶ & FindDay (start+7;end;Day)) ); Let( [ start = GetAsDate(GetAsText(StartDate)); end = GetAsDate(GetAsText(EndDate)); Day = DayN; Day1 = DayOfWeek(start); Diff = Day - Day1; FinalDay = "N" ];FinalDay ) );¶ & "N";"")
  16. Name & Parameters: GetMap ( webViewerName ; zoom ; address1 ; address2 ; city ; state ; postalCode ; country ) Description: Appologies if I have put this in the incorrect format. I have tried to import the GetMap custom function from the Filemaker 12 Contact sample database. I have fiddled with several fields and setting to no avail. I'm using FM 12 pro advanced. My aim is input the address, a map appears then remains with or without internet connection. Ideally would only update when the address is changed. Any pointers would be much appreciated. Recursive: ? Sample Input: Let ( [ address = Substitute ( address1 & " " & address2 & " " & city & " " & state & " " & postalCode & " " & country ; " " ; "+" ) ; size = GetLayoutObjectAttribute ( webViewerName ; "width" ) & "x" & GetLayoutObjectAttribute ( webViewerName ; "height" ) ] ; "http://maps.google.com/maps/api/staticmap?center=" & address & "&zoom=" & zoom & "&markers=" & address & "&size=" & size & "&sensor=false" ) Results: 400. That’s an error. Your client has issued a malformed or illegal request.That’s all we know. Formula: GetMap ( webViewerName ; zoom ; address1 ; address2 ; city ; state ; postalCode ; country )Required Functions: Credits: Disclaimer: FM Forums does not endorse or warrantee these functions are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify.
  17. For FileMaker Pro 11 Advanced, I'm looking for a custom function and calculation debugger. This would be like the script debugger, but for custom functions and calculations. Does anyone have a plug-in for this? Or is there another solution? My custom functions and calculations can be very complicated and thus difficult to debug by hand or by printing out intermediate variables.
  18. Last September I wrote an article about a custom function that I optimized to evaluate hundreds times faster. At the end of the article, I challenged my readers and myself by claiming that the already optimized custom function can be optimized even further. Do you remember? Later on I actually really optimized it again, and talked about this optimization during my session at Pause On Error [x] London 2011. Now you can watch the video of this part of my session below: Read more and download my updated sample file at honza.24uSoftware.com.
  19. Two weeks ago I wrote an article about a FileMaker custom function I needed to preprocess some data imported from the web. I used this custom function in an auto-enter calculation to immediately preprocess the data while being imported. I created a server-side script that does the import every morning. But when I discovered that the import was taking over an hour every day, I saw it deserves some optimization. I used FM Bench Detective and optimized the custom function to evaluate up to several hundreds times faster… Read the whole article at honza.24uSoftware.com
  20. I needed to decode HTML encoded text in FileMaker. I thought this must have been done many times before, so I tried to search for a suitable custom function at BrianDunning.com and FMFunctions.com. After checking few functions I found one that seemed pretty good... Read the whole article at honza.24uSoftware.com
  21. Hi: I'm a Novice user of Filemaker 11 getting trouble finding a solution to link 2 tables from a set of values located in a Value List. The first table Products:Product_ID holds the list of products The second one Products_to_Products is used to show in a portal the products that have the same specs and that can be considered as "similar" or "compatibles". I need to create the link between this two tables using a Value List. Example: 4 products has been selected and the value list contains the Product_ID for each one separated by a CR: myValueList 1 2 3 4 Now, based on this list, I need to create in the table Products_to_Products the records that will hold the pk's for each combination of the members of the Value List. The only constrain is to avoid the association between same products. The needed result is this: Product_ID1,Produc_ID2 1,2 1,3 1,4 2,1 2,3 2,4 3,1 3,2 3,4 4,1 4,2 4,3 There is any Function in Filemaker 11 that will make easy to solve this? Any help will be greatly appreciated.

Important Information

By using this site, you agree to our Guidelines.