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

Tuesday
Jan292008

FILEMAKER: The Get(SystemDrive) Function

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

Get(SystemDrive)
Introduced With FileMaker 8
Returns A Text Result

Have to say that this seems to fall into the category of ... hmmm...well...ok. The Get(SystemDrive) function return the drive letter (on Windows OS machines ) or the volume name (on Macintosh OSX machines) where the currently running operating system is located.

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

Saturday
Jan192008

FILEMAKER: The Get(ScreenWidth) Function

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

Get(ScreenWidth)
FMP Version: FileMaker 7 and Higher
Returns A Number Result

The Get(ScreenWidth) function will return a numeric result that will match the number of pixels in the current monitor width. 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 it's screen width 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.

Friday
Jan182008

FILEMAKER: Exporting TextStyleAdd Changes

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

A READER ASKS ...
While searching on the web, I came across your Blog, FILEMAKER: The TextStyleAdd Function. It was exactly what I was looking for except for one item. I want to export the information in the FileMaker Database to comma delineated text format. When I exported the data, I did not get all lowercase for the one field. I have over 90,000 student usernames, etc. to convert. The only problem is this one field which must be all lowercase for the state department.

----------------------
DWAYNE RESPONDS
Well, there are a number of things you can do. So I’ll just run the gamut of options and let you see if one works out for you. Now, none of these use the TextStyleAdd function but instead use the Lower function.

EXPORT A CALC FIELD INSTEAD
The lowest impact would be to create a calculation field that uses the lower function and then export that field instead. For example, Lower ( Blog Title ) for this record in the FileMaker database I use to create my blog would return, exporting textstyleadd changes. In your scripted export, substitute the calculation field for the calculated one.

REPLACE COMMAND
Replace the contents of the field with the lower version of itself. So if I wanted to make my blog title field lower case for all records in the found set, I would use the replace command and use the calculated value of Lower ( Blog Title ).

INTERACTIVELY CHANGING THE TEXT OF THE FIELD
Going forward, you may want to have the field interactively change case as the user exits the field. This can be done via the auto enter calculated value with the “do not replace” option unchecked.

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