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!

Thursday
Feb072008

FILEMAKER: The Get(UseSystemFormatsState) Function

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

Get(UseSystemFormatsState)
Introduced With FileMaker 8
Returns A Number Result

Although there are three possible options, the Get(UseSystemFormatsState) function returns a Boolean result in regards to the setting of System Formats via the File Options dialog box.

Basically, the Get(UseSystemFormatsState) function returns a 1 if the “Always use current system settings” option is checked. Otherwise this function will return a 0.

These settings take into account some regional aspects for number, date and times settings. I had run into this when working on JobPro, a popular FileMaker production solution sold by SoftTouch Technologies. Since the package was designed in Ireland, I had some problems with currency formatting for my United States customer. This setting allowed me to make sure the currency settings default to our dollar format.

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

Wednesday
Feb062008

FILEMAKER: The Get(UserName) Function

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

Get(UserName)
Introduced With FileMaker 7
Returns A Text Result

The Get(UserName) function will return a text string of the user name as specified in the FileMaker general tab application preferences. On the surface, this can be a nice tool to build auditing information about who creates or modifies a record.

However, there are some drawbacks to using this function instead of the Get(AccountName) function. It is not uncommon for more than one user to use the same computer. In a case such as this, the Get(UserName) function will return the same value for each user because the information in the General Preference area does not change.

On the flip side, a user can change this information and reflect that they are someone they are not. So many records can be flagged incorrectly or (heaven forbid) you use this function for security reasons, the security model could be defeated easily.

So in more cases in which you are tempted to use the Get(UserName) function, I’d recommend the Get(AccountName) function instead.

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

Wednesday
Feb062008

Multiple Calculation Repetitions

** this was originally posted to my FileMaker Term Of The Day blog but I thought I'd also include it as a posting here ***

Multiple Calculation Repetitions

CATEGORY: Calculations
CLASS: Storage
VERSION: All Current Versions

A calculation field can have a repeating storage option set for it just like a text, number, date, time, timestamp and container field.

Repeating fields are odd little things and I seldom use them anymore. Back before FileMaker 3, they were a workaround for the flat nature of FileMaker. According to the FileMaker wikipedia entry, FileMaker 3 rolled out in December 1995. So in the 13 + years since FileMaker went relational, repeating fields have been used as workarounds for things other than relationships (by experienced developers) and sometimes used instead of relationships (by inexperienced developers).

So there really is no way to say that repeating fields are used for this, that and the other. It is more like, “he/she is using repeating fields to do this, interesting”.

Calculations with repetitions are used primarily when interfacing with other repeating fields. This is so you have a clean calculation that extends what the standard repeating fields told you about a particular record. So if the standard field has 10 repetitions, your associated calculation will likely have 10 repetitions as well.

So in summary, a calculation can have a repeating storage option set for it, mainly so it can calculate results from other repeating fields accurately. You will generally run into this when an advanced developer is doing something “special”, when you are working on a very old file that hasn’t been modified in a long while or when a developer used a repeating field where they could have used a relationship portal.

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

Monday
Feb042008

FILEMAKER: The Get(UserCount) Function

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

Get(UserCount)
Introduced With FileMaker 7
Returns A Numeric Result

The Get(UserCount) function returns the number of users / clients currently accessing the active FileMaker file. It will return a 1 if the file is not being shared, because there is only one user. If the file is being shared, it will return 1 for the host and then the number of clients or guests using the file via standard FileMaker networking. By standard networking, I mean the function will not count web, ODBC or JDBC connections as users.

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

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