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

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


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

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 20 results

  1. 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
  2. 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.
  3. 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
  4. 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.
  5. 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?
  6. 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" )


  7. 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";"")
  8. 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?
  9. 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.
  10. 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!
  11. For this Coaches’ Corner tip, Kristian Olsen demos a simple technique for creating a popup menu in which you can make multiple selections. Very useful! Grab the sample file here: http://bit.ly/2qTSttq FileMaker Coaches' Corner - Tip 4 - Editable Popup Menu - Custom Function https://youtu.be/HGw_nkhU58A www.fmcoachescorner.com Most Recent Upload https://goo.gl/Dbn9fm Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions. The course is 50 hours of video content! Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers. He has offices in California, Nevada, and Texas. Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client-server integration. Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution. Looking for FM Starting Point free software download: http://www.fmstartingpoint.com Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development. RCC, Filemaker Videos, and LearningFileMaker.com are headquartered in Santa Clara, CA. http://www.rcconsulting.com/ Please feel free to contact us at support@rcconsulting.com FileMaker Pro is simply a powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web Transform your business with the FileMaker Platform Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos 50 Hour FileMaker Pro 16 Video Training Course-FileMaker 16 News-Online FileMaker 16 Training Videos https://www.youtube.com/watch?v=KpQqLLDcZ8I Playlist https://www.youtube.com/watch?v=KpQqLLDcZ8I&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_&index=13 Top 10 New Features in FileMaker 16-FileMaker 16 News-FileMaker 16 Instructional Videos-FileMaker 16 https://www.youtube.com/watch?v=urh8iHOCxkg Playlist https://www.youtube.com/watch?v=urh8iHOCxkg&t=130s&index=1&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_ Sharing your Database with Other Devices and Users-FileMaker 16 News-FileMaker 16 Database Sharing https://www.youtube.com/watch?v=GF82vkYtCtA Playlist https://www.youtube.com/watch?v=GF82vkYtCtA&index=8&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_ Introduction to FileMaker WebDirect 16-FileMaker 16 News-Online FileMaker 16 Training Videos https://www.youtube.com/watch?v=uaZKIpBjMAM Playlist https://www.youtube.com/watch?v=uaZKIpBjMAM&list=PLjTvUZtwtgBSVV1-4pFG4SHAhCIP3Yy-I&index=17&t=10s A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data Official site provides the SDK, Developer's Guide, Reference, and Android Market for the open source project http://learningfilemaker.com/FIAS.html https://sites.google.com/site/filemakerprotrainingd2n/home/filemaker-training https://drive.google.com/file/d/0ByHcthu5EL9NSmowQm9OUDdZZ1k/view?usp=sharing Free FileMaker videos check out ...http://www.filemakervideos.com Download the FileMaker Pro 16 & FileMaker GO 16 for mobile devices training videos at http://www.learningfilemaker.com Download FileMaker Go 16 video training at http://learningfilemaker.com/FMGO-16/fmgo16.php Download FileMaker 16 Full Video Training Bundle at http://learningfilemaker.com/subscription.php FileMaker Video Training Review-FileMaker 16 Video Course Review-FileMaker Pro 16 101 Course Review https://www.youtube.com/watch?v=mF6Uor0KmKo Playlist https://www.youtube.com/watch?v=mF6Uor0KmKo&list=PLjTvUZtwtgBT8tNHuzF6cOKC_37zCTQl6&index=18 Use FileMaker to create an app with the FileMaker Training Series FileMaker Pro is a cross-platform relational database application from FileMaker Inc. Comment, Like & Share Our Videos. Feel Free to Embed any of Our Videos on Your Blog or Website. Follow Us on Your Favorite Social Media Facebook Twitter Google+ #FileMakerCoachesCorner #FileMakerPro16Training #FileMakerPro16Videos https://www.youtube.com/watch?v=4ozLZaRUgZ0&feature=youtu.be
  12. 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.
  13. 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
  14. 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
  15. 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.
  16. 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
  17. 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
  18. 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
  19. 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?
  20. 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  
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.