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.
360 topics in this forum
-
Help with subtotal on a page
by Franky VH- 1 follower
- 0 replies
- 93 views
I've built my own database for invoices/quotations...so far ok. I made an invoice layout with multiple pages and page numbers ... also ok. However, I am unable to create a subtotal per page. So summary / count of the value Total_ex_vat does not work? anyone have an example?
-
- 1 follower
- 4 replies
- 275 views
Hello Filemaker Community, I have FM13 and I am trying to used calendar pickers to create records in a related table. The user should be able to click on one of the calendar dates (generated by repeating fields), this should then copy to pieces of data from the calendar and use these to create a new record. Then the user clicks on the date in the calendar a second time, the script should delete the record that was created in the related table. Would anyone be able to assist with helping me to set up the scripting as I am new to FM? I look forward to hearing from you soon. Best Regards, MA Francima Driver Hire 1.fmp12
-
- 1 follower
- 3 replies
- 197 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- 0 replies
- 460 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 reply
- 307 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…
-
- 2 replies
- 452 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
-
- 1 follower
- 5 replies
- 489 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- 8 replies
- 1.2k 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- 1 follower
- 8 replies
- 498 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
- 187 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
- 684 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.5k 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
- 943 views
Returns the pdf's number of pages - Submitted by Daniele Raybaudi More...
-
getSelected ( parameterCode )
by Guest barry- 0 replies
- 961 views
get all kinds of selection values - Submitted by hisc More...
-
CombineLines(RC;decimal;ObjList)
by Guest barry- 0 replies
- 767 views
Get a subslist under mask - Submitted by Erich Schmidt More...
-
ValidateUKPostcode
by Guest barry- 0 replies
- 956 views
UK Postcode Validation - Submitted by Thomas Seidler More...
-
IsPortrait
by Guest barry- 0 replies
- 762 views
An easy way to tell is the device is in Portrait - Submitted by Gabe Becker More...
-
IsLandscape
by Guest barry- 0 replies
- 669 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
- 928 views
To shuffle a string - Submitted by Nick Lightbody More...
-
CountWorkingDays ( From ; To )
by Guest barry- 0 replies
- 684 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
- 1.1k views
Permutation of an index list - Submitted by Erich Schmidt More...
-
While ( condition ; function )
by Guest barry- 0 replies
- 885 views
Allows to use a while in FileMaker - Submitted by Hisc More...
-
RandomDate
by Guest barry- 0 replies
- 765 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
- 799 views
concatenates one List to another - Submitted by Oscar Bautista More...
-
_AddMonths ( vDate ; vAddMonths )
by Guest barry- 0 replies
- 830 views
Add x number of months to a given date - Submitted by Makah Encarnacao More...
-
GetPatternList
by Guest barry- 0 replies
- 710 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
- 691 views
Subtract x number of months from a given date - Submitted by Makah Encarnacao More...
-
NextBinPattern
by Guest barry- 0 replies
- 800 views
The next binary pattern - Submitted by Erich Schmidt More...
-
Erich Schmidt
by Guest barry- 0 replies
- 678 views
Get a substring under mask - Submitted by erich.schmidt@t-online.de More...
-
listFieldTypes ( listOfFields )
by Guest barry- 0 replies
- 948 views
Returns a tab-delimited list of fields & field type info for every field on the current layout - Submitted by Andrew Sasaki More...