Jump to content

Search the Community

Showing results for tags 'custom function'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
    • FileMaker Pro 18 Advanced
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • 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
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting

Categories

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

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 22 results

  1. 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
  2. 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
  3. 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!
  4. Version 1.0.0

    53 downloads

    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" )
    Free
  5. 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 Sub
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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?
  11. 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) ; "" ) ----------------------------------------------------------------
  12. 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 th
  13. 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?
  14. 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
  15. 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 pos
  16. 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.
  17. 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:
  18. 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.
  19. 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.
  20. 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
  21. 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
  22. 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
×
×
  • Create New...

Important Information

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