Custom Functions Discussions

Hi there...! Calling all Custom Function wizards I need your help!! I am trying to make a custom function that can take a list of values like so: Bob|5 Mary|3 Anne|3 Bob|5 Frank|1 Bob|5 Anne|2 And turn it in to a group summed list like this: Bob|15 Mary|3 Anne|5 Frank|1

I'm not sure which forum this should be posted in, so if a mod could move this if necessary, I'd appreciate it. I'm wondering if it is possible to have FMP detect what type of credit card is being entered just based on the card numbers? I have seen other systems able to detect what type of card was entered based on, I'm guessing, the amount of numbers entered and what order they're in. The same goes for routing numbers on bank accounts. I would want the institution/card type's logo to appear upon the information entered into the correct field, so a related record(s) containing all this information would need to be created. Is this secure information? Is anyone awa…

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

Hello, In a table called "ITEMS" I have a field called "ItemCode". Beside it is a portal that references a related table called "ORDERS". It shows the OrderYear and QtyProduced fields for every record in the "ORDERS" table that has the same ItemCode as the record being browsed. The ItemsCode field is what links the "ITEMS" and the "ORDERS" tables together. I have been able to get a summary of the total QtyProduced for all the records in the "ORDERS" table that have the same ItemCode as the record I am browsing, regardless of the year. For this, the formula I am using is " =Sum(Orders::QtyProduced) ". and it is working. But I'd like to break it out by year …

As I've been marveled at the little size of my knowledge and at the willingness to help available in this forum, I'd like to make a simple question that, although not totally fmp, is going to help on it. I have a database of read articles. My articles are stored completely, and I highlight portions of them. "Comment", from this forum, helped my way out on implementing background color in it, using a GetAsCss (full link: http://fmforums.com/forum/topic/90644-workflow-fromtext-color-to-highlighted-background-incl-print/), and it was amazing, but I want one more thing yet. I'd like to know what is the easiest way to highlight something in a usable way to fmp. When I …

Hello, I'm new to this forum and to filemaker also. I have a problem that I'm unable to solve so far, and would really appreciate all help. I have a lot of text in my database, and I'd like to highlight some part of it. I know TextStyleAdd would be a possibility, but I need to highlight in different colors (what TextStyleAdd would not, to my knowledge, allow). This is so easy to do on a program like MS Word, just highlight one part of the text in blue, another in red, etc. I already know how to change the color of the text, and make it bold, italic, but what I want is to change the background color. Is it possible in FMP? Not the whole field, just the part I want. …

Hi Hope this is the correct forum. I was trying to replicate a system I have been using up to now. I was hoping to activate an email client either outlook or gmail and send out emails to all the records i choose or all of them, I have an email field for each contact. Thanks for any pointers.

Hi, I am not sure if this needs to be a custom function or just a calculation but I am trying to increment a field with a letter in it. I have found a function to increment through the alphabet which is what I need but after "Z" I need to go to AA->AB->AC...AZ->BA and so forth. The original topic with the calculation is here: http://fmforums.com/forum/topic/32866-increment-the-alphabet/ Thanks for any help. Daniel

Morning, 1) I am trying to create a custom keyboard shortcut ("command+1") so I can find a specific field ("lastname") in the current record and replace it with specific text ("YES"). I am using FMP 11 Pro. I am having difficulty getting it right with the custom menu. Thank you, Adam

Greets all, and Happy Thanksgiving (in advance). I'm trying to strip every bit of formatting, extra spaces, returns, tabs...you name it...from a field and convert it to plain, Verdana 12 pt. text but try as I might I can't get rid of leading space of a new sentence after a carriage return. like this line. I incorporated Trim4 (Ray C's cf) into the following cf I threw together: TrimAll ( TextStyleAdd ( TextFont ( TextSize ( Trim4 ( text ) ; 12 ) ; "Verdana" ) ; "Plain" ) ; 0 ; 0 ) /* //Trim4 cf from Ray C on Brian Dunning's website Let([ sT = Char(9) & Char(13) & Char(32) & Char(160); C1 = PatternCount(sT; Left(text;…

In my solution that is based on this type of relationship (pic) I have a custom function called Infobase(). What it does is let me deduce the parent of a particular Primary Key. I use it to do things like link Information Topics back to found sets. http://pctechtv.com/show/cus.png So I am imagining that I keep feeding the result of Infobase() back into itself that I can come up with the parent of all parents in a particular topic. I was looking into to recursion in Custom Function and saw some info that said a Custom Function cannot iterate but it can recursively call itself. Assuming that is true I would think that this can be done with my function Infobase(). Eventual…

Does FileMaker have a function that can format a date the way you would like? The one in the Inspector is like what I am talking about. Or do you have to write one yourself? I have a date in one of my calculations that leaves off leading zeros on days and months I want: 9/2/2013 to be 09/02/2013 Are there any documents by FileMaker that show functions and formatting like dd = 09 YYYY = 2013?

Dear Filemaker ppl, I was wondering if there is a way to script or function that takes the contents of a field and change that into a unique key with length ofcharacters alpha-numeric. The key should not be random as it should be able to be converted back to the original field contents as it were. eg. field - reg_name - contains a name key to generate through a function adwesd2 - grewad2 - 2fdfhj - 345fryy- dgfsggs-wer4t5h (as an example) I am not sure how I would go about doing this and any ideas would be most welcome. I am unaable to atatched a sample file.fmp12 to this post to help out. I would be happy to email it to you from yongzi@…

I am currently using the ExtraData CF found on http://www.fmfunctions.com/fid/202 This has worked very well for me for some time, however the data I am parsing has now changed to include the same attribute across multiple arrays of data. Does anybody know of a custom function that will allow me to target a specific array's attributes?

Hi there... I'm trying to create a custom function which can remove value list items if a partial match is found eg: Alu (0) Aluminium (0) Aluminium Effect (0) Black (2) Saphire Blue (0) Silver (0) Soft Ivory (0) Stainless Ice (0) Stainless Steel (0) White (20) Yellow (0) I am trying to remove all the occurances or (0) thereby leaving Black (2) White (20) Any ideas?

Name & Parameters: HTMLEntities( text ; pointer ; store ) Description: Converts punctuation and symbols in 'text' to HTML entities, starting at position 'pointer' Set the 'store' parameter to "" - If you give it a value it will prefix your output with that value. Caution: This function will render inputted HTML non-functional. Since it will destroy the tags by replacing < and > with HTML entities. Recursive: Yes Sample Input: Hi, I'm some text with some symbols or punctuation to convert to HTML entities! ?&/ Results: Hi&#44; I&#39;m some text with some symbols or punctuation to convert to HTML entities&#33; &#63;&#38;&a…

I am looking for a custom function that will get values based upon a list of value numbers. Example: Data = a¶b¶c¶d¶e¶f¶g Value Numbers = 3¶5¶6 Result should be = c¶e¶f Or if I can choose my own separator, that would be great. Any help I can get would be greatly appreciated.

I'm new to FM and to this forum. I hope this was the right place to put this question. I figured it would probably involve functions. So here's my situation. I have a customer database that is continuously growing. Once a month I send a mailing to certain customers (but not all customers). I've created a check box for "Send maling" that I tick for customers who I want to send to. So at the end of the month, I do a search for all customers with a "Send mailing" check box ticked. I would like to find a way to keep track of the following: The customer that was sent the mailing The date at which the customer was sent the mailing The history of dates that a given cus…

Hi, I need to be able to take a serial number field and convert to text. like this: 1 = A, 2 = B, 25 = Z, 26 = AA, 27 = BB etc. I did try to use a custom function on brian dunnings website ( http://www.briandunning.com/cf/399 ) but for some reason when I try to save the function Filemaker says "An operator (e.g. +, -, *, ...) is expected here" and it flags the bracket as shown in red below in the code. /* DecToAlpha function Author *COMMENT Visual Realisation Format DecToAlpha ( decimal ) Parameters decimal - any numeric expression or field containing a non-negative numeric expression. NOTE: Only the integer part of decimal will be considered.…

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 &…

I got the window sizing I think. But How can I tell the size and location of someone's bar? We will have people using both OS. I have researched and I am still completely stumped. I figure I need some sort of custom function, right? Even a nudge will probably get me moving again. Thank you.

Sorry if I am not posting this question in the right place- i can't figure out where to post what. Anyways... I have 4 tabs and each tab holds a container field to hold PDFs. what i WANT to happen is if the container has a PDF, for the tab to be a different color. So i can tell which of the 4 tabs have a PDF without clicking through them. I am assuming i can do this with conditional formatting (if COA does not equal blank, make fill color green) - but i can't seem to get it to work. Thoughts? I tried using the VerifyContainer calculation but that did not work either. Thanks ahead of time! ...and Im psuedo beginner, so simple language please.

I've developed a solution for analyzing horse races using FMP. For each race it produces a list of Factor Analysis Points such as below for a 4 horse race Horse 1 = 7.6 Horse 2 = 10 Horse 3 = 4.7 Horse 4 = 5.4 Is there a source of a custom function to translate the % of points earned by each horse into its probability of winning and then into Projected Odds :1? Thanks

I found a nice custom function in the comments of this CF That allows a user to quickly enter times. Let( [ tt = Int( Substitute( Choose( Length( textfield ) - 1; "ç00"; "ç00"; "ç"; "ç" ); "ç"; textfield ) ); ts = Case( Div( tt - 100; 1200 ); 100 + Mod( tt - 100; 1200 ); tt ) ]; Replace( ts; Length( ts ) - 1; 0; ":" ) & " " & Case( Position( Lower( textfield ); "p"; 1; 1 ); "P"; Div( tt - 100; 1200 ); "P"; "A" ) & "M" ) But there are a few bugs: 00 = 12:00pm 10p and up = 12:00pm Plus I would like a tweak: let "." convert to 'pm' (for users with extended keyboards) any ideas?

I have a list which is generated from two separate tables, and consists of letters and numbers - for example Table A gives the list: 2, 3, 4, 4A Table B gives the list: A, B, 1 I would like to concatenate the lists and then sort them into order thus: Concatenated and sorted list; A, B, 1, 2, 3, 4, 4A Filemaker's sort mechanism allows you to sort records based on a value list. I can get them into this order with a sort using a value list like this (I've missed a few values out!) A, AA, B, BA, C, CA, D ......Y, YA, Z,1,1A, 2, 2A, 3, 3A ........24, 24A, 25 Has anyone got a custom sort function which will sort a list in the same way, or point m…

Hi Every one. I am trying to make a custom function or calculated field? What so ever is possible. One table will have two date fields - start_date and finish_date Same table will also have calculated fields Day1, Day2, Day3, Day4..... upto Day31 When we will write any start date of month and finish date of month, automatically in calculated fields 1 will come. For example Start date = 1/4/2013 and Finish Date = 6/4/2014 This should auto fill Day1, Day2, Day3, Day4, Day5, Day6 with 1. I do not want to use script or script trigger etc. Is it possible? I am attaching you test_dates filemaker 12 file as well with all fields. Thanks in advance for your help. …

A couple years ago I posted this custom function on briandunning.com: http://www.briandunning.com/cf/1085 It's an extremely simple function intended to be used to define a web viewer object. It basically calls a Google maps URL but embeds the map in the web viewer rather than displaying the entire page. Here is the entire function: "http://maps.google.com/maps?q=" & Address & "," & City & "," & State & "," & Zip & "&z=" & Zoom & "&output=embed&iwloc=0" The function works flawlessly in both FM10 and FM11. However, recently there have been a string of FM12 users that claim that when they attempt to create the c…

I have found a few functions that help build a list like the following (based on 5 minute intervals (300 minutes)): 9:15:00 ​9:20:00 ​9:25:00 ​9:45:00 ​9:50:00 ​9:55:00 ​10:15:00 ​10:20:00 ​10:25:00 I need a CF to create a key field that loops though this list, detects breaks in sequence, and handles them like the following: 9:15:00 9:15:00 9:20:00 9:15:00 9:20:00 9:25:00 9:45:00 9:45:00 9:50:00 9:45:00 9:50:00 9:55:00 10:15:00 10:15:00 10:20:00 10:15:00 10:20:00 10:25:00 Anyone have a bit of time to assist on this? I appreciate it ;-)

Hi Everyone, Â I stuck at one place. As i have make calendar in which i put name,to dispaly the booking my job is to put the name in whole date field From date To field,upto now i have showing name in From date only,i am attaching the screenshort for better undersatnding. Â Thanks

Is it possible to change the currency sign ie dollar to pound sign in the home budget planner all at once. Thanks

I am interested in creating a custom function that would allow a user to apply a function to every value in a list. It would look something like this: applyFunction2List ( myList ; "function" ) ... where 'myList' is a text field with return-delimited values, and "function" is a text expression of a user-specfied function. For example, applyFunction2List ("1¶2¶3" ; "[value] * 2" ) would return: "2¶4¶6" I've tried working and modifying CustomFunction() and SubstituteManyWithCalclation(), without much success, but I admit I'm baffled by recursive functions. Any tips would be appreciated.

I looked on briandunning.com to see if there was anything that fit my needs, but I have yet to find anything. What I'm looking for is a custom function that would return the number of days that a record has been "active" over a larger date range. I figure there would be four date inputs: periodStartDate periodEndDate openDate closedDate Open and closed dates are the dates associated with that particular record. Closed date can also be empty, which obviously implies that it's still open. Also it appears that the closed date should not be included in the count of active days (a current issue I'm dealing with). This is an extremely helpful calculati…

We are using FMP 12 Advanced, we have a layout in which we print an award certificate. We would like to be able to create a calculation field that draws from an existing date field (call the existing date field: "Date Awarded") the contents of that field would be a date value ex: 2/2/2012 this date may be a past, current, or future date, and will vary depending upon the actual date awarded. We would like to be able to add a calculation field (based on the "Date Awarded" field) which pulls the numerical representation of the example date "2/2/2012" and have it represented as a spelled out word: i.e. "This second day of December, two thousand and twelve". Further inputing "…

Using this tutorial (http://www.anvildataworks.com/?p=554/) I have managed to produce a series of reports by month. These include basic counts and percents, nothing too fancy. Now, I would like to do the same thing, but display this same data by week or day. The end goal is to have a tabbed dashboard which would display running data by month/week/day, but will also allow specific months/weeks/days to be selected. To achieve this for the months, I created a months table with 12 entries. Each has a DateStart and DateEnd, which are calculated by the following, respectively: DateStart=MonthNumber & "/1/" & Year(Data_Dashboard::g_CurrentDate) DateEnd=MonthN…

I'm trying to use CustomList to cycle through parameters declared in the let statement that the function is embedded in, but it looks like it won't accept parameters passed into it. Here's a very simple look into what I'm trying: Let ( [ _number = 1 ] ; CustomList ( 1 ; 10 ; "_number * [n]" ) ) The error that comes back says that the field reference doesn't exist. Error 102. Is there a way around this? If so, it would be amazingly powerful. Thanks! jared

I have been trying to figure this out. I have created the custom function and it is fine I'm sure because I just copy/pasted it. Then I go to script or calc, I tried both, and I need to know what to put in its places of object and type. ObjectID ( object ; type ; file ; layout ) I try attaching object name to first name field and trying this: ObjectID ( "FirstName" ; "T" ; "" ; "" ) ... I try a hundred things, anything to just get a result. I can't figure how it works because I am not knowledgeable enough yet but I want to still use it. Is that wrong? Here is the full thing and thank you so much for reading about my need and maybe helping. /** *…

The order function parameters are listed in a CF matters. What I do not understand is why it matters. For those who aren't yet aware, if a custom function has three parameters, you must list them in the order specified. If you switch the order that they appear in the list (drag one up or down), it will (most likely) break the CF. It does not matter the order they are created in - only the order of the parameters in the CF list. I thought originally it was because the calculation displays the function parameters and it would matter what was entered where but even that doesn't fit because all FM does is match the parameter name to itself within the calculation simil…

Hey there! Im new to this forum and with Filmaker Pro. Im currently still watching some tutorials I grabbed from lynda.com My boss wants me to make a database for incoming calls to the office, where when someone calls, we launch the database and start entering information about who called, when, what they said, etc etc. I think making this is fairly simple, just make the appropriate fields right? But the key thing he wants from me is to make the database so that you cant continue to enter data into the next fields until you've inputed something in the given field. Kinda like popup messages: Type First Name, then Type Last Name, then Type What they said, etc. So you…

Hi Guys, need some help please. Ive been searching on Briandunnings and fmfunctions website and I can't find anything I can use easily. I have the following inputs: No_of_Weeks = 5 StartDate = 11/5/2012 Week_Holidays [ 11/12/2012 11/19/2012 ] I want to calculate and end date based adding 5 weeks to the start date. The problem is if there are any holidays within 5 week range, I need it to add a further week(s). Any help would be appreciated. Not really looked at recursive custom functions before

Dear All, I just want to know, how to calculate XIRR using FileMaker. XIRR is a function in excel which returns the internal rate of return for a schedule of cash flows. 02-01-2006 200 01-02-2006 100 01-03-2006 100 03-04-2006 100 01-05-2006 50 01-06-2006 100 03-07-2006 100 01-08-2006 100 01-09-2006 150 02-10-2006 100 …

Hello all. I hope you are having a great weekend. I am running into a problem that basically results in eye candy (nice but not totally necessary) on a report. As of now, my Starting, Ending and Total Mileages do not have a comma separator. I would like to place a comma in the proper place in these fields. The only things I can find online that pertains to this do not work for me no matter what I try (and I've spent hours trying). Here is what I have referenced... Filemaker Help; Formatting Numbers in a Text Calculation Field and Filemaker Help; How to Handle Formatting Number, Date and Time Merge Fields and Formatted Numbers Within Text Fields. He…

I have been looking at the various plugins to dial phone numbers, send sms etc. What I am hoping to accomplish is the following: I have a system to checkout equipment to students. If they are past their due date, I want to use a plugin to send a recorded message stating that their item is overdue. Has anyone had experience with this. I chose this route as... some students do not check their email often enough, some do not have unlimited messaging and still other are not using twitter, etc. or....If you have a different suggestion of integrating contact info with a reminder system... I am indebted.

Howdy, all: I need a little help formulating the syntax for a proposed CF--named StripAllFormatting__cf--I'm cobbling together; what it does is strip away all kinds of excess stuff (returns, spaces, tabs, etc.) so it makes the data in a field "clean". The Players Trim command TextFormatRemove command CleanText__cf (contains a Let function-driven, Substitute-related command structure ) http://www.briandunning.com/cf/638 TrimReturns__cf (removes excess carriage returns) http://www.briandunning.com/cf/80 The goal is to include in many text fields in my solution an auto-enter calculation, StripAllFormatting__cf (Self) TIA for your help! Rich

I need to take in HTML and insert it into a field. Is there a custom function that will replace all the HTML Character Entity Encoding? For example: name format &copy; = © or numeric format © = © Ideally I'd have a substitute function for all of these, I'm hoping one already exists.

Hoi Can i make a calculation repeat? Something like Repeat ( Count ; Calculation ) So That Repeat ( "5" ; "2" * Count ) will give me 2 4 6 8 10 It sound simple to me but i can't figure it out.... I hope somebody can help me out.. Thx

I'm trying to figure out the pros/cons of using a Loop/Helper function to handle the recursion in a CF Specifically, are there speed or upper limit benefits to using a "helper" or "looper" function instead of combining all the steps into a single or is that simply for readability? What about using the CustomList function to handle the recursion?

Hi, I have 3 fields in a table that contain a currency amount in £ and I have formatted the fields on screen with currency £ and 2 decimal places which for on-screen use , is fine. I need to use the fields' contents in an email and find that I loose the formatting of 2 decimal places when doing so , which I can understand why - but I want £132.00 to appear as £132.00 , not £132 when using the data elsewhere, such as emails. is this a job for a custom function? and does anyone have an example I can see. many thanks

Hi There, I am having a bit of a problem. I know there is a simple solution but I can't work it out. I have a date field that user enters, This field defines what date an order is ready to be picked up. I have a time field that the user enters. This field defines what time an order is ready to be picked up. I have a field called "pick up date". This is a calculation field that returns a pick up date. I need this to calculate a pick up date based on the previous two fields. For example: If dayofweek (day) = Thursday and time (hh;mm;ss) > 16:00:00 then return "pick up date" as the following Tuesday. I can't quite get the calculation to work.…

I am trying to use a function with a one sub function to return me the nearest date to the a date in the field in table. I have created the custom function in filemaker and have it working to the original specification/ design. The site that learn about the function says that if I modify the sub function comparative it can be forced to return me the nearest date earlier than my input date. I am new to writing function and I could use and hand to modify this to work in that way. Or if anyone has a better way of returning a record in a table with the nearest date before the input date it would be greatly appreciative. I am using the ClosestDate Function fro…

My database is sorted by customer number, is there a way or function that basically prints out a report of what fields were modified for each customer for each day? Basically we sell insurance, and after working with a customer file ex: adjusting addresses or premiums at the end of each day we would like a report that shows what has been changed in the file so one of our agents can check over the changes. Any help on this issue greatly appreciated!! Matt

This isn't exactly a 'custom function' but perhaps someone who deals with functions can help. I have a script that first determines if the user is running in OSX or Windows. Then it creates a path to a file. (Using in part 360Works Select File() function) Here is the script: The OSX part (top) works. The Windows portion (bottom) produces this 'mess': I thought the problem might be in the get(systemDrive) function so I replaced it with C: . But, it still didn't work. What am I missing? (Yes, I tried putting filewin: in front without a good result.) Thanks Ron

I am trying to implement the following function on some FMP11 documents but can't get it to work. However it works fine on FMP 12. Is that normal or am I missing something? 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=" &amp…

I want to auto populate a field (LastModActiveStatus) with the current date everytime a calculation (Active_StatusSum.c) changes value from "0" to "1". If it weren't a calcualtion field I could use a trigger script but because it's a calc field I don't how to accomplish this... is it even doable? See attached zip example. LastModifiedAutoPopulation.zip

I've got a field called "expecting" which is a simple check box. The enduser checks the "expecting" checkbox when they are notified that a client is pregnant. What I don't want to happen... is that the "expecting" box remains checked indefinitely--since at some point, the person will no longer be in a state of "expecting". I don't want to rely on people to manually uncheck the box when the baby is born (particularly since a pregnancy doesn't always result in a birth). Since a person can only be "expecting" for a max of 9 mos... I'd like the box to automatically uncheck at the end of 9 mos. What would this entail? I assume there would need to be a dat…

Hi there, I'm fairly new to Filemaker, but I'm pretty sure there is a solution to what I'd like to achieve. I'm trying to keep a log of hotel rates. The rates are valid for date periods and each date period follows consecutively. To speed up data entry and eliminate errors I feel there is really only a need to enter the end date for each rate period and the start date should be calculated from the previous end date e.g below: Start Date End Date Rate 01/01/2012 15/01/2012 500 16/01/2012 31/01/2012 400 01/02/2012 20/03/2012 450 The initial start date would need …

I'm looking for some suggestions on how I might go about doing the following: My main table (TableA) contains an ActiveStatus, text field. My main layout page is based on the context of TableA and the ActiveStatus field defaults to checked ( or active) everytime a new record is created (added to TableA). key fields in TableA ID_PEO.pk Name ActiveStatus CreateDate People should be considered to have an ActiveStatus (checked) for the first 18 mos they exist in the system, and/or if they have a ActivityDate in TableB or TableC (below) within the most recent 18 mos period. I'm wondering what the script, calc or funtion might look like to atomate…

Hi, I have been trying to understand what is wrong with this custom function that I found in http://www.briandunning.com/cf/957 I have a simple database with about 100,000 records with numbers like 1200103792893 this function works well except that some secuences are not encoded properly. They turn into an invalid character represented as Ã� with all the barcode fonts I've tried. For example these numbers give me an error, 1200103380473, 1200103382093, 1200103552193 while others like 1200103817993, 1200103819193 and 1200103819693 works fine. I can post or send by email an example of the database. I will apreciate any help regarding this iss…

I can't seem to find anyone using this. I don't know if I am doing too much, as in there maybe some built in functionality I am not aware of. I am looking to duplicate a record but make all data copied formatted with a red font. This will be a quality control tool when our customer service department copies data from a similar job. This is what I have in my brain, sorry if it does not translate well with FMP. function duplicateRecordInRed() { // copy data from each field to var set fieldCount to count(every field of current record) set i to 0 while i < fieldCount set var i to field i // don't know if I can …

Hello everyone; I am noticing many similar traits with custom functions and scripts. Can someone please attach any / links to perhaps studied algorithms based on recursion,search,etc Or is this something one learns with time. @Comment has some amazing techniques that seem so "Technical" and not just out of the blue, makes me believe he has a degree in computer science ! : ) Let me go on... Some functions usually save positions where you are located, for example , starting text, or 2nd value in a list,etc Finds the end value and then grabs all the data in between to do some stuff with. Let([ Vn = ValueCount(Tips::gLibrary); P1 = Posi…

I'm trying to adapt a formula written in javascript into a Filemaker pro custom function. I have it functioning as a script, but I don't see a way to write this as a function since it needs to loop. Any help is appreciated. The original formula is found near the bottom of this page: http://www.movable-t...g-vincenty.html And I've attached an print of the scripted calculation (the system won't let me upload an example file). The latitude/longitude of 2 different points are passed to the script, and the result is the distance between them. formula.pdf

I'm looking for a custom function (or help with a formula to build one) for the Excel probability function NORMSINV [ inverse of the standard normal cumulative distr]. There is one out there for NORMSDIST. But I need the inverse function. Not knowing much about probability functions, I don't know if I can somehow make that one work? Has anyone run across the NORMSINV function in FileMaker?

Hello all, still I did not fully understand how to implement recursion.... admittedly I am lost- and very much so: There is a list of values = list By script, I am looping through another list with keys. Now I would like to check if the key is in the list. First I was thinking to get the value with Position ( list ; key; 1; 1). The problem is that in list, there might be 4651 and key might be 6, which would make Position true. However 4651 is not 6. Hence, I thought to loop through list by recursion and to check with the "=" but I dont know how to build this: Let ( [ list = thelist; k = thekey counter = 1 c = valueco…

Well Here is an interesting question, how do you all feel about the ability to sign documents with filmmaker using a digital signature capture system like pro sign for example, Likes, Dislikes, preferences on software types? I’m exploring the possibility of adding this to one of my data bases and want to know what your options are.

A little background to my question - I live in the UK so half of my contacts and therefore telephone numbers use the STD code for the UK which could be 0207/0208/0161/ etc. All my local codes start with just one "0" Whereas the International codes have two zeros "00". So is their a script that would insert +248 into the field then the rest of the number instead of the "00" and when it comes to the UK telephone numbers just being one "0" then leave the field as I have inputted. Example 01604 123 4567 Hope someone can help as I cannot work out how to do this. Sorry if I haven't explained myself well. Thanks

Unfamiliar with creating custom functions, I would like to return the value list with a count beside each item Let ( [ thelist = List ( diet::restriction ) ; vlist = ValueListItems ( Get ( FileName ) ; "diet_restriction" ) ] ; PatternCount ( thelist ; GetValue ( vlist ; 1 ) ) ) Inital List No Pork Vegetarian Vegan Return List No Pork 3 Vegetarian 2 Vegan 8

I am looking for a function that will change a number, a dollar amount, to words. I have found two, http://help.filemaker.com/app/answers/detail/a_id/3443/related/1 and http://help.filemaker.com/app/answers/detail/a_id/2860/~/converting-numbers-to-words-or-numbers-to-text I have FM9 Adv. The first link is for a very old version, and the 2nd one fails at the very last ")" with an error. Any ideas out there? Thanks.

http://www.briandunning.com/cf/493 Evaluate ( Function & " ( " & Substitute ( Field ; "¶";";" ) & " )" ) this custom function has limitation of calculation character count for big lists of data and caused filemaker be crashed. i must develop some analytic reports on some unknown and user defined tables and create some dynamic reports with some scripts with sophisticated analysis function like benford low and histogram, after user choosing the name of table and field. now because of the custom function limitation, i must do the calculations and compares on data list that be copied to the variable from source field, one by one, and in big list …

this one is blowing my mind!!! so, i need to calculate a date that is 11 months in the past. this is what i'm doing: Date ( Month ( Get (CurrentDate) ) + 1 ; 1 ; Year ( Get (CurrentDate) ) - 1 ) i've also tried: Let ( [ M = Month ( Get ( CurrentDate ) ) + 1; Y = Year ( Get ( CurrentDate ) ) - 1; D = 1 ] ; Date ( M ; D ; Y ) ) but for some really weird reason, it's making the year as 2011 (which should be 2010 by my calculations). here's the weirder thing....if i change my system date back 1 month....the calculation works fine. so, when my system date is set to december 2011...no worky.....but november 2011....works. ??? …

I am hoping someone can spot the illogic ... this CF (file attached) seems to work fine except if I put a non-word character at the front of the text. There are surely better ways to write this calculation but I am puzzled why this can recurse itself to death (apparently) only with beginning non-word character. Purpose produce 1 of every word in any number of strings, separated by a space. Each word should be individual (from both lists) but only replace full-word matches. I have calculation (result is text): DeDupWords ( Category & " " & SubCategory ) DeDupWords ( text ) Let ( [ string = " " & Substitute ( Proper ( text ) ; [ "," ; " "…

Case ( GetFieldName ( _self ) = Get ( ActiveFieldTableName ) & "::" & Get ( ActiveFieldName ) & Case ( Get ( ActiveRepetitionNumber ) > 1 ; "[" & Get ( ActiveRepetitionNumber ) & "]" ) ; Get ( ActiveFieldContents ) ; _value ) // =================================== /* This function is published on FileMaker Custom Functions to check for updates and provide feedback and bug reports please visit http://www.fmfunctions.com/fid/209 Prototype: AllowInputInAutoEnter( _self; _value; _triggers ) Function Author: Fabrice (http://www.fmfunctions.com/mid/37) Last updated: 15 May 2009 Version: 2.1 */ // =============================…

Howdy, howdy... I nabbed the following CF (Tony Tanevski, Hi-Voltage, author) from Brian Dunning's site so I can have a calc display the difference between two dates in the following format: "2 years, 6 months"; I have a quick question since I'm a little hazy about CFs: What are the parameters (xMonths, xYears, Months?) I'd use and how would I code the calc for say, field names Date1 and Date2? TIA for your help! ----------------------------------------------- Case(not IsEmpty(Months) and Months >=0 and months <> "?"; Let( [ xYears = Int(Months / 12); xMonths = Case(Months - (12 * xYears) > 0; Months -…

Sorry for what is probably a noobie question, but I haven't been able to find the answer. Custom functions would solve a few problems I have, but I don't have a copy of FMP 11 Advanced yet. If I get a copy of FMP 11 Advanced and make a database with some custom functions, are those function embedded in the database so they can be used by any FMP 11 Pro application? Or do they only work when the database is opened by an FMP 11 Advanced application? I _HOPE_ to get a version of Advanced, use it to write the needed custom functions and databases, and then let the databases actually run on FMP 11 Pro applications, but before I buy a copy of Advanced I want to veri…

Hello all, I need to divide the span of an opening until the span is less than a given value, each time subtracting the width of the divider. This is somewhat similar to building a wall and putting in 2x4s until the largest gap is no larger than x. Unlike a wall though, the value isn't based on the center of the 2x4 but on the span between them. The given parameters and example values are: span = from 0" to 200" maxGap = 24" dividerWidth = 4" So the span (200") will have one divider (4") inserted, leaving two even gaps of 98" each. One more divider will be added incrementally until the evenly sized gaps between dividers is less than the maxGap (2…

Does anyone know how to grab the create date and time of a local file? I'm pulling vendor catalog feeds into FM11. Up until now I've just been inserting the current date & time as the catalog date of the newly imported file -- the assumption here was that if a new catalog file was delivered to our FTP folder, then it was actually NEW! Worked fine until I discovered that one vendor has been sending an old catalog every morning. So I've been processing the same file needlessly every day... Just in case I've missed a external function that's already under my nose -- I have SMPTit Pro, FTPit Pro, and Troi URL plugins but have never run across anything tha…

I'm curious about the above question in general, but I'll give an example to clarify (I'm sure if I could figure this out once, I'd make use of it in other applications in the future). I'm trying to write a recursive custom function that would list the highest numbers in `overlapping sub lists` within a list. say you had a list of how many milliliters of water a mouse drank each day in chronological order, and then you wanted a list of the most ml the mouse drank on any day of overlapping 3-day periods... let's call the function 'peaks' you would use: peaks(valuelist ; 3) ... peaks( "10 20 30 40 50 60 70 80 90";3) wou…

Hello, I would like answer to this topic : CustomList custom function limited to 300 items in list on FileMaker Server Be careful when using the CustomList custom function on FileMaker server. My testing has revealed that the list this function will generate is limited to 300 entries when used on FileMaker Server. The documentation of this functions states that it is limited to 500,000 on FileMaker Pro and 150,000 on FileMaker Go. I had never actually tested on server. I just read this article by chance, I just did the test and saw that the function Evaluate () is the problem ( the same for FileMaker Go ) it is the current limit of FileMaker Serveur inte…

Does anyone have a custom function for social security numbers? Thanks...

I everyone, I'm brand new to the FileMaker database but have some FB experience and a newbie here. I'm well into a heavily modified starter solution for asset management and have been asked if FM will do something! What I need to do is every time a assets mileage or hours is changed in a shared field of "current hours" have it recorded in a table that can then be reported from with a time stamp for each change to the field and it's value. Could someone give me a bit of advice? Thanks always in advance, Jay

I'm having trouble with a function to do the following: Given an array of values, for example: 2 3 4 7 8 11 13 14 15 How can I group them in an array like so: 2-4 7-8 11 13-15

Name & Parameters: EmptyFields ( object ; counter ) Description: This function is meant to take a tab name as the object parameter and return a 1 if any of the named fields are empty, 0 if they have values. The counter parameter should be 0. Recursive: Yes Sample Input: "tab.Science" ; 0 Results: Formula: /*Empty Fields ( object ; counter ) by David Jondreau, www.wingforward.net This function is meant to take a tab name as the object parameter and return a 1 if any of the named fields are empty, 0 if they have values. */ Let([ objects = GetLayoutObjectAttribute ( object ; "containedObjects" ) ; end = ValueCount ( object…

I'm looking for a custom function that will give me all the names of the field objects on the frontmost tab. I can make one, but I'd rather save myself a couple hours work if I can. Anyone have one? Thanks, David

I came across this custom function below within the forums. http://fmforums.com/...e-export-files/ Vigenere ( text, key, decode ) Let ( [ tChar = Left ( text ; 1 ) ; kChar = Left ( key ; 1 ) ; tLen = Length ( text ) ; kLen = Length ( key ) ] ; Char ( Mod ( Code ( tChar ) + Code ( kChar ) * ( not decode - decode ) ; 255 ) ) & Case ( tLen > 1 ; Vigenere ( Right ( text ; tLen - 1 ) ; Right ( key ; kLen - 1 ) & kChar ; decode ) ) ) If anyone could help, I need the text being encoded to fall within the ascii characters 32 and 126 and for the life of me I can't seem to make this work. All text to be encoded would alway…

I'm trying to set up a field in the header of a layout that displays the current account name. I've tried it by creating a field in the table that the layout is for and setting it to calculate 'Get (AccountName)' and I've also tried just setting it to Auto-enter and checked 'modification' then selected account name from the dropdown. Either way, the value displayed in the browse mode doesn't get updated until the current user has modified a field or changed views. Is there a way to make the displayed name refresh the instant a new user logs in? Right now, I can switch users but the value shown in the field makes it seem like I'm still logged in as the last user, unt…

Hi all - I am just curious what your opinions are about the use of Global Variables in a custom function.

Hello, just wondering if anyone has or knows where i can get a "FREE" fp7 file containing all of FIlemaker's built-in functions - would love to have this as a reference. -cheers, -i

I recently took over an outdated project built in FM8 or earlier. There is a function I'm having trouble with which contains the code below. I'm familiar with the most recent graphing capabilities of FM but this "<function missing>" is confusing me. The code creates a bar graph attached to this post. If I try to change anything about this calculation/container I get an error message "A number, text constant, field name or "(" is expected here". The cursor highlights the "<function missing>" piece of code. I'm not clear on how this code even works with that first line... but it does. I need to change the formatting (and therefore code) of this graph. Ca…

This is what I am trying to do. 0234 - someText 0235 - more 123 Text 0236 - other text This is my list that I have ( folder names in a directory ) I know the ID "0235 -" pattern its the first word of the list. I am trying to return the value of 2 in the above example. I would be happy for a function to strip the list only to the first word then I can use another function to determine it's position. Most of the position value functions out there assume the string is return sep - in my case its a 'starts with' and I can't use a Filter() cause there could be numbers in the list.

Hi, all: I'm having a bit of a brain hernia trying to understand how the following, recursive CF--that creates an acronym of an organization's name--works: ------------- Let ( [ numWords = WordCount (TextString) ; firstLetter = Upper (Left (TextString ; 1)) ]; Case ( numWords > 0 ; firstLetter & Acronym_CFpub ( RightWords (TextString ; numWords - 1))) ) ------------- I "get" the Let part of the CF and the first part/left side of the Case statement, but it's the recursive part (right side) of the Case statement that's throwing me for a loop. (Okay, that was a lame pun.) Say the organization's name is Froot Loop …

Can anyone help me do this? hh:mm:ss to decimal number I've seen the function to do just hh:mm to a decimal number, but I'm not sure how to be able to handle the seconds part of it.

I'm new to FileMaker. My version is FileMaker Pro 8.5. Any help would be greatly appreciated. I have surfed through various forums and nothing has helped. Question: How do I make back/forward buttons? I've read about them with "backmagic" and "seedcode" but they were complicated to understand and didn't work for me. Details: I'm using "Lending Library" as a starter template and reworking for cataloging artwork. Please be detailed and specific with instructions. I know nothing about scripts so if they are involved, it would be great if someone could provide step by step instructions. Below are some thumbnails: Back/Forward Buttons http://imageshack.us/…

There are a number of CF that convert numbers to word. But these are all in English. Does anyone has a CF that convert Numbers to Words in French? My company now deals with a French bank and I know nothing about French. I try doing the translation one number at a time but I am not confident the conversion is correct. Thanks in advanced

My layout having around 10 fields, now I can able to key in all the fields with "English" language. but my need is to be enter the "Arabic" language for the particular two fields. how could i achieve this, Please share your thoughts it's possible or not.

Is there a function out there somewhere that will do this as a first script step, sort of like a Windows batch file? After unzipping to a designated folder, I need the file extension to be changed to .csv Thanks.

Hi, I've been trying to auto-format entered text using SmarterProper and I've run in to a couple of problems: 1. It was changing A.B. Enterprises to A.b. Enterprises. - I figured out how to fix this one, by adding " or first Char = "." " to newCase (inbetween firstChar = "-" and or not IsEmpty). 2. SmarterProper corrects O'reily to O'Reily, didn't to Didn't but it will change didn't do to Didn'T Do. - So, obviously the capital T in Didn'T is a problem, which I'm not sure how to fix. 3. It changes ABC Company to Abc Company. - When there are five characters or less that are upper case, I'd like SmarterProper to leave them upper…

Im connecting with a mySQL database and it uses UTC/GMT time for the modification timestamp field. Is there a timestamp function that will take daylight saving into account and generate a UTC/GMT timestamp?

Moving to a Mac workflow and realized that most of the plugins I've used don't have Mac versions, notably MooPlug. Does anyone have any advice as to an alternative? I'm mostly looking at interaction with the Finder, setting variables to folders, importing images, checking for file existences, etc...

Hi all, I would like to validate search criteria for a timestamp field before a find is performed. My preference is that a date would be valid entered using the following formats: d/m/yy d/mm/yy dd/m/yy dd/mm/yy d-m-yy d-mm-yy dd-m-yy dd-mm-yy (for all of the above yyyy would also be acceptable and either 01 or 1 would be acceptable for day or month.) also checking that day/month/year is valid in terms of days in a month, months in a year etc. Time would be valid in 24hr clock format i.e 0015 or as 12hr format i.e 12:15am. A full date and time would be valid if time follows date e.g 27/03/01 0015. My intention is to …

I am trying to write my first custom function to reformat a text filed. User enter the following format : text1/text2/text3/text4 I want to reformat this to text1 text2 text3 text4 with a carriage return at the end I think I need a CF and I have been trying this but no success so far. Appreciate someone can help me . Thank you

I found Andrew LaCates' ExplodedKey function in the forums, but I want to adapt it slightly, and I'm seeking help with that as I don't quite know where to start... Basically I want "Hello world" to result in: H He Hel Hell Hello W Wo Wor Worl World instead of H He Hel Hell Hello Hello Hello W Hello Wo Hello Wor Hello World //ExplodedKey(text) //By Andrew LaCates If( Length(text)>1; ExplodedKey(Left(text;Length(text)-1)) & "¶" & text; text )

I have several calculations that require a number to loop incrementally until the calculation is satisfied. What is the most simple counter that I can write as a custom function in the form of something like: Counter(Increment) ?