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!

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.

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.

Page 1 ... 6 7 8 9 10 ... 44 Next 5 Entries »