Search Project Mgmt
Search FileMaker Blogs
FileMaker Blog

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!

Monday
Feb182008

FILEMAKER: The Get(WindowTop) Function

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Get(WindowTop)
Introduced With FileMaker 7
Returns A Number Function

The Get(WindowTop) function is used to return the vertical distance of the current FileMaker window from the top of the FileMaker application window. There are some variances that come into play between applications and in regards to docking button bars that may be at the top of the application window.

© 2010 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. FileMaker Pro is the registered trademark of FileMaker Inc.

Sunday
Feb172008

FILEMAKER: The Get(WindowName) Function

From Dwayne Wright
www.dwaynewright.com
info@dwaynewright.com

Get(WindowName)
Introduced With FileMaker 7
Returns A Text Result

The Get(WindowName) function is used to return the name of an active FileMaker window. Normally, this would be the active window in the foreground ( like if you have a field using this function on the layout ). However it is possible to use this function in a script that might be working on another window ( when used in conjunction with the Freeze Window script step).

© 2010 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. FileMaker Pro is the registered trademark of FileMaker Inc.

Saturday
Feb162008

FILEMAKER: The Get(WindowMode) Function

From Dwayne Wright
www.dwaynewright.com
info@dwaynewright.com

Get(WindowMode)
Introduced With FileMaker 7
Returns A Number Result

The Get(WindowMode) function will return a number based upon the current mode ( Browse - Find - Preview - Layout) of the FileMaker active window. Active can be the foreground window or a window in use by a running script.

Browse mode will return a 0
Find mode will return a 1
Preview mode will return a 2
Printing in progress will return a 3

A little odd but you can also return a 4 when in layout mode and a script is trying to do something with that window. You won’t be able to see the returned value of 4 in another other situation than a currently running script on that window. You would use this for error checking that you are not trying to execute script steps in a window in layout mode. I’d assume FileMaker Advanced users would be able to see this result in the Data Viewer but I haven’t experimented with that situation yet.

© 2010 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. FileMaker Pro is the registered trademark of FileMaker Inc.

Saturday
Feb022008

FILEMAKER: The Get(TotalRecordCount) Function

From Dwayne Wright
www.dwaynewright.com
info@dwaynewright.com

Get(TotalRecordCount)
Introduced With FileMaker 7
Returns A Number Result

The Get(TotalRecordCount) function will return the sum count of all the records in the current FileMaker table as viewed by the foremost layout window. The current table will refer to the source table that is attached to the table occurrence in the current layout. The calculation will need to be unstored in order to be accurate when viewed on the layout. It will count the current users uncommitted records as well as the records that are in the index.

In some layout designs, the status area is hidden from the user. This can be done for security reasons or the developer wants to maximize the use of the screen real estate. Many times this function is used when someone is mimicking the information shown in the status area in browse mode.

© 2010 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. FileMaker Pro is the registered trademark of FileMaker Inc.

Thursday
Jan312008

FILEMAKER: The Get(TemporaryPath) Function

From Dwayne Wright
www.dwaynewright.com
info@dwaynewright.com

Get(TemporaryPath)
Introduced With FileMaker 9
Returns A Text Result

The Get(TemporaryPath) function will return the text of the path to the current OS user's temporary folder commonly used by FileMaker Pro. This is handy when you are importing and exporting routines and want to have those files in a place that shouldn’t disrupt anything else on that users machine.

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

© 2008 - 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.