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!

Sunday
Mar022008

The DatabaseNames Function

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

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

DatabaseNames
There is no parameter for this function
All Recent Versions Of FileMaker
Returns A Text Result

The DatabaseNames function provides the names of all open FileMaker database files at the time the function is executed. Each database file name is separated by a carriage return. If you are thinking about using this in script branching, you will probably have to use it in tandem with the PatternCount function.

If you have the .FP7 extension on your database files (and I hope you do), the extension information is not included in the result of the function. This means that it is possible ( however remote ) that this function might break if you have two FileMaker 7 databases open with the same name but different extensions. This could be the case when you are building runtime databases with FileMaker Advanced.

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

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.