Custom Functions
A collection of Custom Functions for FileMaker Pro. Do you have a custom function to share? Post it here.
Subforums
FileMaker Custom Functions
- 659 posts
A large selection of FileMaker Pro Custom Functions from user\'s around the world.
358 topics in this forum
-
- 1 follower
- 3 replies
- 79 views
I want to sum, say, number 32 to get 5 ( 3+2) Any help to do the Calculation? Thank you
-
Timer Add-On
by MiltonT- 1 follower
- 0 replies
- 339 views
Hi All, Just had a look at the new Add-ons in Fm19. Is there a way to make the timer work in reverse. i.e. Start from a field (Timer::TimeLength) that a user can input, so that the specified time of say 30:00 will run down to 0:00 Any help would be appreciated. Regards Milton.
-
Jump to a record
by MiltonT- 1 follower
- 1 reply
- 263 views
Hi All, First time posting here. I have a couple of reports (List layouts) that have around 1500 records and I have 5 or 6 sort criteria's that I obtain by clicking buttons with scripts. All of this works fine but what I would like to accomplish is having a field at the top of the page and when I type a person's name the system would jump to that record line so that I can obtain the record number row. I don't want to narrow the list down with a Find, because the row number changes according to how many records are showing. Then I can resort the list by clicking the next button and then typing the person's name again and this would show what row n…
-
- 1 follower
- 2 replies
- 271 views
Hi I have two tables, users and orders, connected to each other with the Users PK and the relative FK of Order. In the format that is based on Order I wish I could enter a user element in the FK field so you don't have to type it. I remember that in Access you could choose to take the data from a table different from the one on which the form is based and its fields but storing it in the correct field. In FileMaker I couldn't understand how to do it, if you can obviously. Thank you
-
- 2 followers
- 5 replies
- 437 views
LOOKING FOR FM PROGRAMMER We are a film production agency based in Vienna and need someone for custom programming. We already have a licence for FileMaker and need to adjust it in a certain way. Are there any freelance programmer out there, who want to help us? :) I'm looking forward to your replies. Thank you!
-
Expand Field to show all text
by St3v1e- 1 follower
- 8 replies
- 730 views
Hi, I have a tab which I'm using to add a new comment for client communications. My problem is that when the amount of text entered in the comment field exceeds the size of the window, it's hidden from view until I click inside the "Comment" field. At this point it expands so I can read everything. Is there a way to automatically expand these fields to show all text contained inside them without having to click inside the field?
-
Company Relationship - need to understand the logic of this Contact/Company relationship please !
by St3v1e- 2 followers
- 8 replies
- 439 views
Hi all, I'm trying to figure out how to create a one-to-many relationship for my Contacts' employers (many employee's / 1 company)? I'm assuming that I need to have a separate table for my Contacts, & another for "Companies"? And by entering the name of the Company in my contacts layout, a record would be created in my "Companies" table. I'm confused by how to set up the relationships, so that only One Company is created, but shows [via a portal in my Companies layout], all employees. Currently, each time I enter the [same] company name, a new record is being created - leading to multiple records for the same company. So if John's employer is XYZ L…
-
- 1 reply
- 146 views
I have any 5 numbers. Of course I can calculate fields one plus one and put result in another field. But I intend something more complex. Suppose my field numbers are: A-B-C-D-E I want all possible sums of these 5 numbers: A+B, A+C, A+D, ... but also A+B+C, A+B+D, C+D+E... and so on Any function is able to do that? Thank you very much for your help Eduardo
-
phone finder
by mariajason36- 2 replies
- 383 views
Hi, if any of you is familiar with an experienced and affordable company phone finder, please inform me.
-
Barcode Custom Functions
by idautomation- 0 replies
- 3.4k views
Create Filemaker Pro 1D (linear) barcodes with IDAutomation's custom barcode functions that can be embedded in the Filemaker database for easy distribution. Compatible with Mac and Windows (32 & 64 bit) versions of FileMaker Pro 12 and above. Barcode functions available for Code 128, GS1-128, Code 39, Interleaved 2 of 5, Code 93, MSI Plessey, Codabar, UPCA, UPCE, EAN8 and EAN13. The encoder is free to use with the purchase of an IDAutomation barcode font. Download the custom barcode functions. For more information and online tutorial. IDAutomation_FileMakerFontEncoderFunctions.zip
-
PDFPageCount ( container )
by Guest barry- 0 replies
- 908 views
Returns the pdf's number of pages - Submitted by Daniele Raybaudi More...
-
getSelected ( parameterCode )
by Guest barry- 0 replies
- 883 views
get all kinds of selection values - Submitted by hisc More...
-
CombineLines(RC;decimal;ObjList)
by Guest barry- 0 replies
- 741 views
Get a subslist under mask - Submitted by Erich Schmidt More...
-
ValidateUKPostcode
by Guest barry- 0 replies
- 815 views
UK Postcode Validation - Submitted by Thomas Seidler More...
-
IsPortrait
by Guest barry- 0 replies
- 687 views
An easy way to tell is the device is in Portrait - Submitted by Gabe Becker More...
-
IsLandscape
by Guest barry- 0 replies
- 629 views
An easy way to tell is the device is in Landscape. - Submitted by Gabe Becker More...
-
xShuffle ( string; control )
by Guest barry- 0 replies
- 889 views
To shuffle a string - Submitted by Nick Lightbody More...
-
CountWorkingDays ( From ; To )
by Guest barry- 0 replies
- 657 views
This helps to find no of working days in a date range including the given dates. - Submitted by Saigopal Das More...
-
Permutation( IdxLst; PermNr; nObj )
by Guest barry- 0 replies
- 944 views
Permutation of an index list - Submitted by Erich Schmidt More...
-
While ( condition ; function )
by Guest barry- 0 replies
- 851 views
Allows to use a while in FileMaker - Submitted by Hisc More...
-
RandomDate
by Guest barry- 0 replies
- 728 views
creates a random date between the specified first and last dates, inclusive - Submitted by Jeff Drake More...
-
CombineLists ( list1 ; list1 ; startposition; separator )
by Guest barry- 0 replies
- 754 views
concatenates one List to another - Submitted by Oscar Bautista More...
-
_AddMonths ( vDate ; vAddMonths )
by Guest barry- 0 replies
- 804 views
Add x number of months to a given date - Submitted by Makah Encarnacao More...
-
GetPatternList
by Guest barry- 0 replies
- 608 views
List of decimal numbers whose binary form contains the same number of bits set to 1 - Submitted by Erich Schmidt More...
-
_SubtractMonths ( vDate ; vLessMonths )
by Guest barry- 0 replies
- 658 views
Subtract x number of months from a given date - Submitted by Makah Encarnacao More...
-
NextBinPattern
by Guest barry- 0 replies
- 701 views
The next binary pattern - Submitted by Erich Schmidt More...
-
Erich Schmidt
by Guest barry- 0 replies
- 640 views
Get a substring under mask - Submitted by erich.schmidt@t-online.de More...
-
listFieldTypes ( listOfFields )
by Guest barry- 0 replies
- 852 views
Returns a tab-delimited list of fields & field type info for every field on the current layout - Submitted by Andrew Sasaki More...
-
listRelationships ( listOfTables )
by Guest barry- 0 replies
- 773 views
Generates a list of relationships from a list of tables for the current active file - Submitted by Andrew Sasaki More...
-
CountDays(from; to; dayPattern)
by Guest barry- 0 replies
- 815 views
Count days for a date range - Submitted by leinven More...
-
Upcoming Events
No upcoming events found