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

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 15 results

  1. 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 ###
  2. 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
  3. 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
  4. 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
  5. 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.
  6. 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?
  7. 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. 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
  9. 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,
  10. 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.
  11. 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
  12. 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!
  13. My solution is build according to the 'separation model', so I would like to keep control of the local file containing the layout and presentation of the data hosted in the server. I wonder if I could have a script to control wether the local file gets its structure, layout or scripting modified, so I need a function to control when a change to the file has been made before giving it a version number. When the file gets open only to work with the hosted data it's not a new version.
  14. 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
  15. 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
  • Create New...

Important Information

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