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!

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.

Wednesday
Jan092008

FILEMAKER: DYK: Copy Calculations To Text  Files

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

Did You Know? (a series of quick discussions on things that you might have missed about FileMaker).
------------------------------------------------------------------------------------------------------
COPY CALCULATIONS TO TEXT FILES
Sometimes, you cannot get a calculation just right. When you replace the calculation, the previous version is lost forever. Remember, you can always copy a calculation and paste it into a text file. This can be later used as a reference or if you need to email someone for help.
=
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
Jan082008

FILEMAKER: Introducing Design Functions

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

If you haven’t spent much time with FileMaker Pro’s family of design functions, don’t feel bad. They were introduced when FileMaker Pro 4.0 was released and most of the focus of that upgrade was the FileMaker to the web features. However, a lot of water has gone under the bridge since those days. As FileMaker has matured, developers have uncovered a number of impressive ways to use the family of design functions.

Design functions can capture information about the structure of a FileMaker Pro file and or solution. Valuable information for elements such as layouts, fields, value lists, relationships and even scripts!

These functions are most often used by Web designers to pass information between FileMaker Pro files and web pages. However, that isn’t the only place they’re used. They’re often used to pass information to FileMaker plug-ins and another place you can find them is with solutions used to analyze the design of a solution. . I’ve also seen them used in situations such as activity logging, live record auditing, and even in building unique security techniques.

Here is a listing of the functions within the Design family.

DatabaseNames
Fieldbounds
FieldComment
FieldIDs
FieldNames
FieldRepetitions
FieldStyle
FieldType
GetNextSerialValue
LayoutIDs
LayoutNames
Relationinfo
ScriptIDs
ScriptNames
TableIDs
TableNames
ValueListIDs
ValueListItems
ValueListNames
WindowNames

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

FILEMAKER: The Get(PageNumber) Function

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

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

For the majority of the time, this function will be used to return the current page number that is being viewed in print preview mode. In some cases, the function can return the current page that is being printed ... or perhaps a better explanation... the current page that is being sent to the printer buffer from FileMaker.

The only practical use that I’ve seen for this function is determining the last page of a report to be printed by going to the last page via a script and setting the Get(PageNumber) to a global field.

Here you can see the Go To Record/Request/Page script step with the last page setup as the go to option.
=
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.