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!

Tuesday
Jan082008

FILEMAKER: The Get(NetworkProtocol) Function

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

Get(NetworkProtocol)
FMP Version: FileMaker 7 and higher
Returns A Text Result

Previous versions of FileMaker supported a number of different network protocols. Currently, a network protocol called TCP/IP is king and the other protocols are used in older legacy systems. FileMaker 7 is an advanced database package and doesn't support the older legacy protocols. FileMaker 7 through FileMaker 9 only supports TCP/IP, so this function will return TCP/IP all the time. This is even true is the network sharing option is disabled. So the function still exists (most likely) for backwards compatibility with older solutions or the remote possibility a new protocol will be supported in the foreseeable future.

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

FILEMAKER: The Get(MultiUserState) Function

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

FMP Version: FileMaker 7 and higher

Returns A Number Result

This function is used to return information about the network sharing status of a FileMaker file. In particular, it looks for three possible scenarios. One is that the file is not being shared at all, in this case the function returns a zero (0). One is that the file is being shared and this is the machine that is the host. In a case like this, the function will return a 1. The last option is that the file is being shared and this machine that is NOT the host but a client. In a case like this, the function will return a 2.

It is also possible to return a zero result (0) if sharing for the file is turned on but there are no security access privilege sets that have the [fmapp] extended privilege active.

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

Saturday
Jan052008

DYK: Length Function And Container Object Size

Did You Know? (a series of quick discussions on things that you might have missed about FileMaker).
------------------------------------------------------------------------------------------------------

DID YOU KNOW?
The Length function on a container field will return the container objects size? It is true and can come in quite handy. Here is a picture of an example below.

Friday
Jan042008

FILEMAKER: The Get(LayoutViewState) Function

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

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

As I'm sure you probably know, a FileMaker layout can be viewed as a form (one record at a time), as a list (as a form but with all records in the found set after each other) or as a table (viewed with rows and columns like a spreadsheet).

This function will return the current view state for the layout within the foreground window. It will return a zero (0) for form view, a one (1) for list view and a two (2) for table view. This function can be helpful when you are logging information about a users database session at a point in time or if a script requires a particular mode to operate. For example, table view will not show tab information, buttons or any number of other layout objects.

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

© 2007 - 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
Jan032008

FILEMAKER: The Get(LayoutTableName) Function

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

Get(LayoutTableName)
FMP Version: FileMaker 7 and Higher
Returns A Text Result

Layouts are linked to a defined table occurrence in the relationship graph. Please note that I said a table occurrence and not a table, although by default the occurrence is linked to a source table.

The Get(LayoutTableName) function will return the name of the table occurrence that is linked to the currently viewed layout in the foreground window. In many cases, the name of the table occurrence is the same as the table but not always. In particular, a complex FileMaker database may have many table occurrences linked to the same source table. In a case like this, you may need to have a standard way of naming your table occurrences. Using the same method each time, you might be able to use other functions to extract the base table information from the name of the table occurrence.

For example, if you always name your tables with one word and you always name your table occurrences with the base table name as the first word, then you could use the leftwords function to calculation the base table name of any currently viewed layout.

UPDATE: I wrote the majority of the above content when FileMaker 7 first came out. About a year later, a technique called the Anchor / Buoy (also called the Squid method) became popular. It became extremely popular with me and it is mainly due to how well it handles the ability to track what source table a layout will be linked to.

The source that turned me on to anchor buoy was a presentation by Kevin Frank and Associates. Here is a link, if you want to check it out.

http://www.kevinfrank.com/anchor-buoy.html

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

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