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!

Friday
Mar072008

FILEMAKER: The FieldIDs Function

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

FieldIDs
FieldIDs( fileName ; layoutName)
All Current Versions Of FileMaker
Returns A Text Result

This design function will give you the internal FileMaker id number for all the fields on the specified layout. This will even work for related fields on the reference layout. Each internal FileMaker ID will be presented with a carriage return between each value.

As with most of the design functions, if you hard code the parameters of fileName or layout name, the results can be broken if you change the name of the file or layout afterwards.

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

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

Wednesday
Mar052008

FILEMAKER: The FieldComment Function

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

FieldComment
FieldComment( fileName ; fieldName)
Introduced With FileMaker 7
Returns A Text Result

In FileMaker 7 and higher, you can add comments to any field. The comments field was added as part of the dialog box that you used to create and edit fields. The FieldComment function allows you to fetch data entered into the comments area of a field defined in the Manage Fields dialog box.

The default syntax for this function is to refer to the current table. If you want to use an outside table, you have to add a little something in front of the fieldname parameter ( nameoftable::fieldname ).

Here you can see the comments area that can be attached to a defined field.
=
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.

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.