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
Jan182008

FILEMAKER: The Get(ScreenHeight) Function

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

Get(ScreenHeight)
FMP Version: FileMaker 7 and higher
Returns A Number Result

This will return a numeric result that will match the number of pixels in the current monitor height. This function can even take into account multiple monitors, which is always a possibility in today's computing environment. The results of this function are linked to the monitor that contains the foreground window.

It is unlikely but it is possible to have the foreground window covering multiple monitors. In a case like this, FileMaker tries to give you the most accurate information it can by selecting the monitor that has the largest percentage of the window and give you its screen height information.

=
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.

Thursday
Jan172008

FILEMAKER: The Get(ScreenDepth) Function

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

Get(ScreenDepth)
FMP Version: FileMaker 7
Returns A Number Result

The Get(ScreenDepth) function will return a numeric result of the number of data bits in the screen depth of a users monitor. Most computers run on millions of colors these days but you might run into situations where you have to branch a script depending upon the users monitor setting.

Black & White would return a 2
256 colors would return an 8
Thousands of colors would return 16
Millions of colors would return 32

=
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.

Tuesday
Jan152008

FILEMAKER: The Get(RequestCount) Function

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

Get(RequestCount)
FMP Version: FileMaker 7 and higher
Returns A Number Result

You can stack find requests in a find operation to best filter your results. The Get(RequestCount) function will return the number of find requests within an impending find operation. The practical use for this function is a little different and I’m not sure how often it is used.

Obviously, it will only be useful in scripted search routines, likely only in HIGHLY scripted search routines. I’ve chatted with some developers that provide solutions for the legal practice markets. Many times, those solutions have a highly scripted search environment because the search results often are used to build critical areas of legal contracts.

So I imagine this function could be used to record how many search levels a user had performed, then loop through those requests, capture the search criteria and write it to a log file. The log file could be used for reference or perhaps to rebuild those search settings via a scripted operation.

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

Monday
Jan142008

The FileMaker Get(OpenRecordState) Function

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

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

The Get(OpenRecordState) Function
This function  returns the state of the current record for the current user. The state refers to if a user has their cursor within one of the fields and thereby locking the record. The results of this state are returned by this function in the following manner ...

0 - if the record is closed

1 - if this is a newly created record and the current user is still adding the first round of data to it

2 - if this is a previously created record and the current user is currently modifying the data within that record or they simply have their cursor in one of its fields.

This function is not network aware, it will not tell you if another user has a record opened or not.

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

Sunday
Jan132008

FILEMAKER: The Get(RecordNumber) Function

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

Get(RecordNumber)
FMP Version: FileMaker 7 and higher
Returns A Number Result

This will return the record number of the current record in the current found set. This number can change dynamically via sorts, deleting records or adding records.

This function is often used in databases that hide the status area in FileMaker. Hiding the status area adds valuable layout space that can be used for fields, buttons and other objects. However, you loose the flip book that FileMaker uses to tell you what record you are on. Using the Get(RecordNumber ) and some other functions, you can effectively design your own customized flip book for your users.

As a side note, this is one of the functions that usually will introduce users to the concept of unstored settings for calculations using the Get function.
=
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.

Page 1 ... 4 5 6 7 8 ... 46 Next 5 Entries »