Search Project Mgmt
Search FileMaker Blogs

Thank you for visiting the FileMaker Calculations Explored blog. I recently moved this content over from my blogger account. Hope you like it! When you get a chance, check out the centralized search feature for all the FileMaker blogs found along the right side panel. It is quite handy!

Thursday
Dec132007

FILEMAKER: The Get(ErrorCaptureState) Function

From Dwayne Wright - www.dwaynewright.com

Get(ErrorCaptureState)
FMP Version: FileMaker 7 and higher

You can setup a script to detect errors that might occur while the script is running. This is done by using the Set Error Capture [On] script step. This get function will return a 1 if Error Capture is on for the script that is currently running and will return a 0 if Error Capture is not on.

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2007 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

Wednesday
Dec122007

FILEMAKER: The Get(DocumentsPath) Function

Get(DocumentsPath)

The Get(DocumentsPath) function returns the path to the documents folder for the current user. This can be handy because you might want to have FileMaker interact with that folder by placing content in there (exported data, images and the like) and / or bring items out of the documents folder into the database.

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2007 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

Thursday
Dec062007

FILEMAKER: The Get(DesktopPath) Function

The Get(DesktopPath) Function

When you first start up a Windows based or Macintosh computer, you are normally taken to an area called the desktop. This is actually a folder that is already open but it is designed to appear like the top of a desk. Just like the top of a physical desk, you can have folders, documents and other items on the top of your computer desktop. The idea is that you can always get back to your computer desktop in the computing environment.

The Get(DesktopPath) function returns a text string that FileMaker would use to take the current user to the open desktop folder. This can be used in scripts and calculations to put items on the desktop or reference an item on the desktop.

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2007 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

Wednesday
Dec052007

FILEMAKER: The Get(CustomMenuSetName) Function

Custom menus is a feature that is just hitting its stride in the FileMaker community.

Custom menus allow a FileMaker developer to create custom menus for their users. This feature was introduced with FileMaker 8. Creating and implementing custom menus in a FileMaker database does require FileMaker Advanced. Using custom menus in a FileMaker database is available for all users running FileMaker 8 or higher.

The Get(CustomMenuSetName) function will return the name of the active custom menu set. It will return to you a text result and can be used in scripting navigation or changing a calculated result to a user. If there isn’t a custom menu applied, the function will return an empty or null value.

FYI... It might be handy in using the new FileMaker 9 feature of conditional formatting of layout objects as well. This is because many times you may set a custom menu via a script based upon multiple criteria and the conditional formatting could ride on the coat tails of this logic.

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2007 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

Sunday
Dec022007

FILEMAKER: The Get(CurrentTimestamp) Function

From Dwayne Wright - www.dwaynewright.com

Get(CurrentTimestamp)
FMP Version: FileMaker 7 and higher

This will return the current date and the current time as it appears in the system clock of the operating system of the current users machine running FileMaker. For internal calculations, the Get(CurrentTimestamp) function references the number of seconds since midnight of month one, day one and year one (01/01/01).

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2007 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

Page 1 ... 6 7 8 9 10 ... 34 Next 5 Entries »