Well, it is not entirely that FM leaves you without some recursive means. There is one very important thing you must remember. Ideally, it should not refer to any fields and tables directly. You would probably want to do some formula that you used very often in the current or other FM files. What functions can be done? Well practically anything as long as it results in a value. CF function is also available if you created more than one in current file. Since CF are like formulae, the available list of FM functions for your CF are all available, Plugin functions are available if you have one or more. You can call the function with the function name and semicolon delimited parameters if you have more than one parameter. One thing to note is that the parameters' value cannot be skipped. The line below it will show the structure of the function. If you have any CF in other FM, you can import the CF into the FM that you are working on.Ĭhange the "New Function" to your function name.Īdd any function parameter names as you wish. Go to File Menu, Manage, Custom Functions. This means that not all users can do maintenance on CF regardless of their rights.
HOW TO USE FILEMAKER PRO CUSTOM FUNCTION PRO
First of all, you need to purchase Filemaker Pro Advanced. It is even less functional than what a Plugin can do. It works exactly the same as FM functions. The only thing it could do is return a result of a calculation.
Unlike most common understanding of a function, FMP custom function is severely limited in its feature. My purpose here is to make sure you get the right perspective about CF (custom function) before even jumping into it. Steve himself said "everything you can do in a CF can be done in a script." Now that is an anti-climax when the title above is about Custom Functions. It will then use the local system formats and you will get the same results when converting date and time values to a string.According to Steve Lane CTO of Soliant, Todd Geist said "he prefers to avoid custom functions whenever possible, preferring to use scripts instead". The only solution that I’m aware of is to create a clone of the file and then open it on a computer with the required system formats. VALUES('Logging Commenced at " & Get ( CurrentTimeStamp ) & "'" & ")") For example my plug-in calculation looked liked this: BE_FileMakerSQL (" This appears to happen anytime you need to convert dates, times etc into a text data type via the calculation engine (not specifically related to using a plug-in), which is what I’m doing with the internal SQL feature and the BaseElements plug-in. I did some tests and whenever I evaluated the Get ( CurrentTimeStamp ) function I would get a correctly formatted timestamp for my region (e.g 3:51:20 PM ) but as soon as I used this in an SQL statement or converted it to a text data type I would lose the system settings and get the original settings that were saved with the file when it was first created (German in this case). Instead of inserting a timestamp for my system settings (Australian) which would appear as: 3:49:07 PM It wasn’t until I started using the BaseElements plug-in to enter the current timestamp along with some additional text into a text field that I noticed something was amiss. The startup/OnOpen script for the file was also using the Set Use System Formats script step and setting this to which also instructs FileMaker Pro to use the current system formats. I was working with a file that I didn’t even realise was created with different system formats as the developer of the file had set the File Options to “Always use current system settings” which tells FileMaker to use the current system settings for data entry of numbers, dates, and times instead of those saved with the file when it was first created or cloned: It’s important to note that FileMaker Pro uses your computer’s system formats to determine how dates, times, and numbers display and sort when you first created a new file. I’ve been using the ability to execute SQL statements via a FileMaker Pro plug-in more and more lately (see An Approach to FileMaker Server-Side Script Debugging for an example of this) and recently encountered one issue that might arise when working with files created with different system formats to those on your computer.
0 kommentar(er)
