Jump to content

Search the Community

Showing results for tags '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
    • FileMaker Pro 15
    • Legacy FileMaker Platform 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
  • Forum


There are no results to display.

There are no results to display.


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

Found 14 results

  1. Hi, Here is a custom function that I found on Briandunning.com. The problem is when I try to create a new function with this code, Filemaker refuses it saying The "here" above is situated before the parentheses after "WordWrap" and before "UnprocessedText". Would someone be kind enough to tell what I'm missing here to get this up and running? Let ([ TruncatedText = Left ( Text ; Size + 1 ) ; CountOfSpaces = PatternCount ( TruncatedText ; " " ) ; CountOfReturns = PatternCount ( TruncatedText ; "¶" ) ; PositionOfLastSpace = If ( CountOfReturns > 0 ; Position ( TruncatedText ; "¶" ; 1 ; 1 ) ; Position ( TruncatedText ; " " ; 1 ; CountOfSpaces ) ); AddReturn = If ( CountOfReturns > 0 ; "" ; " ¶" ); ThisLine = Trim ( Left ( TruncatedText ; PositionOfLastSpace ) ) ; UnprocessedText = Right ( Text ; Length ( Text ) - PositionOfLastSpace ) ; Result = If ( Length ( Text ) ≤ Size ; Text; ThisLine & AddReturn & WordWrap ( UnprocessedText ; Size ) ) ]; Result ) Sorry everyone. Please dismiss my post. I just realised that I was trying to include "WordWrap" as a function parameter and as the function name. All's well.
  2. I have a field that receives a bunch of first names from a portal, thanks to the List function. The result might look like this: Alice, Bill, Chuck However, I need for the list to read: Alice, Bill, and Chuck I need to find the last comma in the text and add an "and" to it. I have been messing around with the Position function stuffed inside of a Substitute function, but I can't get it right. Can someone help? FMPA14 Rick A. Pleasanton CA
  3. I have a few situations where I need to be something specific having to do with dates. For the sake of this example, let's say we're dealing with pay periods.  payperiods table will have 1 record for each pay period. It will have a pay period number, a date the pay period starts and a date the pay period ends. See attachment table.png   From other tables, when a user enters a date...I need to be able to return the pp_number for which that date belongs. For instance, entering 7/12/2014 would return 2.  Entering 7/19/2014 would return 3.  Nothing is set in stone here, I'm open to a different structure, I just need an efficient way of looking up the pay period number.  Suggestions?  Thanks in advance!!! Jeff
  4. Hi im still a bit of a beginner with filemaker i have been trying to figure this out but need a little help. I have this function If (GetAsDate ( Date1) - GetAsDate ( Date2 ) < 0 ; Date1 + 28 ; Date1 ) What i need is to turn it in to a loop so that 28 is added to Date1 until Date1 is higher than Date2 I have tries and testes let function and loop, if any one could help Many Thanks Meir
  5. I have registered external function: trimWhitespace (text) if (text == null) return text; return text = text.trim(); If I put this function in indexed calculation field, question mark is displayed instead of text. Is it a bug?
  6. Hi Everybody, I have a text field with a text that contains normal and red-bold characters, I would like to count the number of characters with bold style. Could anyone help me to do this operation with a function? I am trying to do an script that extracts the portion of normal text to calculate the length and then calculate the number of total characters minus normal text. What is the best option? a function or an script? Thank you very much, Wardiam
  7. Prevent Blank Records

    Hey guys, I have a layout that I want to be used like a data entry form as in Access. Each time I go in and close the layout it saves a record. I have tried adding the fields as required fields but the annoying thing was if I don't use tab and just click out of the current field it has a cry and says x field is blank. It seems fairly sensitive. Maybe I have done it wrong. Any suggestions? Cheers
  8. Hey guys, I have a layout called "Aircraft Hours" where I enter in details for an aircrafts flight. The field I am interested in this one is [date]. I have another layout called "Maintenance" where the maintenance for the aircraft show up. I wish to have this layout display the last time that aircraft flew. I am new to this kind of stuff. I am using from what I have read I need to use the 'lookup' function but I am guessing I need an "IF" function as well? I want the calculation to look up the last record entered on the "Aircraft Hours" layout and grab the date from the date field however I need the aircraft field to match on both layouts. The "Aircraft Hours" layout will have records for all different aircraft. I need the calculation to not only look up the last entries date but last entries date for the correct aircraft. Gosh I hope that makes some sense... Cheers!
  9. For some reason the Get(ActiveFieldName) function is not working in any of the tests I've done. I click into a field, but the calculation field with the function in place never changes to reflect the name of the field that has the focus. It just remains blank. The FileMaker website says: Get(ActiveFieldName) Purpose Returns the name of the field that has the focus. Thanks in advance for any help. I'm sure it's something I'm overlooking. Alex Get (ActiveFieldName).fmp12.zip
  10. The topic says it all. My UUID function is working, and I can display it in a standard display field, but I can't get it to populate into my SC URL. Here's how I have the fields set up: (SC is running under tomcat on a Win2008 R2 server) SC_ServerURL (calculation) ="http://myserver:8080/SuperContainer/Files" SC_RecordPathURL (calculation) =Get ( FileName ) & "/Record_" & SC_Get_UUID SC_VersionTrackingURL (calculation) =SC_ServerURL & "/" & SC_RecordPathURL & "/" & "Version_" & SC_VersionNumber & "?style=nodelete+info" SC_VersionNumber (calculation) =Number w/ a range of 0-99999 SC_Get_UUID (text) =UUIDRandom custom function I realize this could be cleaned up a bit. Maybe that's part of the problem. But everything else works. I was using a traditional incremental record ID, and that worked perfectly, but I took that out completely. Now all I end up w/ is all files ending up in the same "Record_" directory, even though I can see the UUID changing in the display field. Any help would be greatly appreciated. Thanks! jbh
  11. Hi Guys, I have only started working with FileMaker for the last 2 months or so, and I didn't like the way that the API is very procedural driven, so I decided to make a class which would help me. I have got a function which I have made which interacts with the FM PHP API (Official) which I am trying to get sorted. The idea to the whole class is to save time writing each function over and over again, but basically I have got this function which I am having problems with which is to get the FileMaker Layout Fields and Values of those fields and put them into an array. Here is my code: /** * Selects data from a FileMaker Layout from the given criteria * * @author RichardC * @since 1.0 * * @version 1.2 * * @param string $layout * @param array $arrSearchCriteria * * @return array */ public function select( $layout, $arrSearchCriteria ) { $arrOut = array( ); if ( ( !is_array( $arrSearchCriteria ) ) ) { return false; } $findReq = $this->fm->newFindCommand( $layout ); foreach ( $arrSearchCriteria as $field => $value ) { $findReq->addFindCriterion( $field, $value ); } $results = $findReq->execute(); // Adds all the fields in the layout to the array $this->fields[] = $results->getFields(); if ( $this->isError( $results ) === 0 ) { $records = $results->getRecords(); //Set the last used layout and object $this->layout = $layout; $this->lastObj = $records; //Loops through the records retrieved foreach ( $records as $record ) { $arrOut[] = $record; //Here I want to Get the Layout FieldNames and Values into an array -> example : $arrOut['user'] = 'DarkMantis' } } else { $arrOut['errorCode'] = $this->isError( $results ); } return $arrOut; } As you can see there, I have commented in that I want to get the Details into my array. If you have any ideas on how to do this it will be greatly appreciated. [Edit] I do apologise for the messy code, it was more of a PoC. [/Edit] Best Regards, DarkMantis
  12. Nested IF Logic

    I'm Web publishing a Database of children's games. There are 4 fields; Preparation (sometimes empty) How_to_Play (Always filled) Variations (sometimes empty) Notes (sometimes empty) I am trying to create a nested IF function that only displays the field if it has some text in it. Just displaying one big blob of text listing field after field is obviously easy, but I want to add a header above each field if the field I included. I am getting stuck because the 1st, 3rd and 4th field are all variables. This is as far as I've got; If (Preparation=0;"";"PREPARATION"&¶&How_to_Play) Up until here is fine, but now adding the IF function if Variations or Notes are also empty by including/excluding them or their headers is getting me a little stuck. Any help would be HUGELY appreciated. Thanks so much in advance,
  13. FOR IMMEDIATE RELEASE 24U Software releases 24U Toolbox Plug-In 1.1.1 Toolbox of the most useful simple functions for FileMaker® Pro adding precise timestamps, application-wide globals, and more... now also for server-side scripts and web publishing Prague, CZ -- September 27, 2011 24U Software announces an immediate availability of 24U Toolbox Plug-In 1.1.1 for FileMaker Pro 11. The new version of 24U Toolbox Plug-In has been updated to run in FileMaker Pro 11 on the most recent versions of Mac OS X and Windows. It also sports new useful functions and capability to be used as a server plug-in for server-side scripts and web publishing on FileMaker Server and FileMaker Server Advanced. What's new in version 1.1.1: - Application-wide globals let developers shared variables between FileMaker files - Precise timestamps allow for measuring of time with microsecond precision - Value type checking can be used to check data type of values passed to calculations - Auto Update savvy version function simplifies automated deployment and updates - Server-side functionality helps creating powerful server-side scripts and web solutions Other Features include: - Execute system scripts (Bash, Perl, PHP, Python, AppleScript, BAT, VBS) - Execute SQL on the current database - Count and substitute text using Regular Expression patterns - Find out which special windows (Script Debugger, Data Viewer) are open - Merge fields and variables into text (faster than using Substitute) - Get the client's public IP address Use 24U Toolbox Plug-In to add a completely new dimension to your server-side data processing Server-side scripts can be efficiently used with FileMaker Server 11 for nightly batch data imports and processing. The powerful features of 24U Toolbox Plug-in let you make this processing much faster and more powerful by being able to use system-level scripts, access your data with SQL queries, merging fields and variables into text, etc. HOnza Koudelka, Software Division Manager of 24U, says: "For a customer project I need to download data from several websites, import the data into a FileMaker database, parse the HTML, and extract thousands of records from the imported data every day. I am using Toolbox Plug-In to trigger curl to download the web pages, SimpleFile to import the downloaded files, and then Toolbox Plug-In again to help with fast parsing and preprocessing of the data. The text merging feature of Toolbox lets me even recognize graphical symbols such as smilies and translate them to text equivalents." 24U Toolbox Plug-In is designed to help FileMaker developers in their daily work by providing a solid toolbox of the most commonly needed simple but powerful functions. Requirements and Compatibility 24U Toolbox Plug-In 1.1.1 requires Mac OS X 10.4 or newer and FileMaker Pro 8.5 or newer. Recommended is Mac OS X 10.6 Snow Leopard and FileMaker Pro 11 Advanced. Windows XP SP3 and FileMaker Pro 8.5 are minimum requirements for using the plug-in on the Windows platform. Windows 7 and FileMaker Pro 11 Advanced are recommended. Some features of the plug-in are specifically designed for FileMaker Pro 8.5 and 9 and do not work with newer versions of FileMaker Pro. Availability and Pricing 24U Toolbox Plug-In is immediately available for download as a free fully functional 14-days trial version, which can be activated after purchasing a license code. More info: http://www.24uSoftware.com/Toolbox Download: http://www.24usoftwa...oolbox#download License for 1 user is $48, additional users pay just $24 or less! Developer license starts at $349 US limited to 20 concurrent users per site, but unlimited to a number of solutions or customers. Server-side license is available for $499 US and covers unlimited server-side scripts and unlimited web users seved by a single installation of FileMaker Server or FileMaker Server Advanced. To purchase visit: http://www.24usoftware.com/Toolbox#buy More about 24U licenses: http://www.24usoftwa...om/licenseguide Discounts are available to FBA, FileMaker TechNet, and FMPUG members. 24U Software offers solutions for people, not for computers! With FileMaker experience reaching back into the early 90's and developing FileMaker plug-ins since 1997, 24U has become recognized a key vendor of plug-ins for FileMaker Pro. Dedicated to creating the easiest to use FileMaker plug-ins... Optimizing performance of FileMaker solutions... Inventing unique iOS applications… Helping organizations to get more out of their technologies... We connect the dare of education with the experience of industry to achieve the impossible. Customer contact: HOnza Koudelka Software Division Manager, 24U s.r.o. FileMaker 8, 10, 11 Certified Developer FileMaker Business Alliance Member mailto:sales@24usoftware.com http://www.24usoftware.com Press Contact: mailto:pr@24uSoftware.com ###
  14. Hi all, I'm new to the forum--and new to programming FMP for my boss! I understand the logical concepts of programming, and how the FMP UI works for table relationships and scripts, but I don't know specific function commands. Now I'm trying to create a database for the manufacturing company I work for, and can't find a function to create a text string I want in a calculated field. Apologies if this question has already been answered, but I can't figure out how to word a search for this!! I have two tables related exactly like the "Contact Management" and "Notes" tables in the starter template: each record in table 1 has an "k_ID" number that matches a group of records in the second table (all having that same number in their "kf_ID" field"). There is another field in table 2 whose contents are a digit from 0-9. This field is the "Item Batch #". I want a calculated field ("Batch Code") in table 1 to paste the values of "table 2::Item Batch #" from ALL related records strung on end, whether there is 1 related record or 5. I've tried typing an example of what I mean....my company won't allow me to attach copies of our file, sorry. records are separated with ------------------------ lines. EXAMPLE: =========== ==TABLE 1== =========== k_ID: 01 Batch Code: 253 ------------------------ k_ID: 02 Batch Code: 67 ------------------------ =========== ==TABLE 2== =========== kf_ID: 01 Item Batch #: 2 ------------------------ kf_ID: 01 Item Batch #: 5 ------------------------ kf_ID: 01 Item Batch #: 3 ------------------------ kf_ID: 02 Item Batch #: 6 ------------------------ kf_ID: 02 Item Batch #: 7 I really appreciate the help, if I can have a solution by tomorrow morning it will mean MAJOR points with my boss! I'm on the west coast, so I'm rooting for all you people further east who'll be perusing the forum with your Monday morning coffee earlier than I will! Thanks again.

Important Information

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