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
Dec182007

FILEMAKER: The Get(FileSize) Function


From Dwayne Wright
www.dwaynewright.com

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

This Get function will return the size, in bytes, of the FileMaker file which you are in at the time the function is called upon.

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

Monday
Dec172007

FILEMAKER: The Get(FilePath) function

From Dwayne Wright
www.dwaynewright.com

Get(FilePath) function

FMP Version: FileMaker 7
Returns A Text Result

This function will return a text result of the path to the currently open FileMaker file. For example, I have a FileMaker file that stores all my blog related work. Here is what I got when I used this function in that file ...

file:/Larry/Users/dwaynewright/Desktop/Blog Stuff/Blog Stuff.fp7

So you can see the file is stored on a hard drive called Larry. It’s actually stored on a partition of a larger drive. So the function is returning the logical drive partition of Larry and doesn’t return any information about the other partitions of Moe or Curly. It then tells you the file resides on my desktop, in a folder called Blog Stuff and that the file name is Blog Stuff.fp7. I’m using a Macintosh computer at home, if I was using a Windows based machine, the returned value would change marginally but still quite readable. So if you are using this function in a multiple platform environment, you might want to test for the platform in use. The Get ( SystemPlatform ) function would be your choice for that.

Here you can see my computer desktop, my three drives, the folder on the desktop named Blog Stuff.
=
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.

Sunday
Dec162007

FILEMAKER: The Get(FileName) Function

From Dwayne Wright
www.dwaynewright.com

Get(FileName)
FMP Version: FileMaker 7 And Higher
Provides A Text Result

This function will return the name of the current FileMaker file ( sans the extension ) at the moment the function is called upon. So a database with the name of Invoices.FP7 will simply return Invoices.

Some other functions will require the name of the file in one of its parameters. In fact, most of the functions in the Design family will require a parameter identifying what file you want the function to look at. In many cases, a developer will use the the Get(FileName) function here instead of typing in the actual file name. In this case, the Design function will still work correctly if the name of the FileMaker file is changed.

Here is a peek at the family of Design functions. See how many of them have a reference to the current file name in one of its parameters?
=
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.

Saturday
Dec152007

FILEMAKER: The Get(FileMakerPath) Function

From Dwayne Wright - www.dwaynewright.com

Get(FileMakerPath)
FileMaker 7 or Higher

This Get function returns a text result of the path to the folder of the currently running copy of FileMaker Pro.

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

Friday
Dec142007

FILEMAKER: The Get(ExtendedPrivileges) Function

From Dwayne Wright - www.dwaynewright.com

Get(ExtendedPrivileges)

FMP Version: FileMaker 7 and Higher
Returns A Text Value

** let’s recap extended privileges before going to far into this function **

Extended privileges are used to determine data sharing options for a particular privilege, such as sharing the file or allowing it’s access via a web browser. Used primarily by the account / privilege combination in order to dynamically expand a developers options for setting up security within a solution.

There are 4 default extended privilege sets in FileMaker 7 ( all off by default ) and looking at FileMaker 9, there are 3 more and they are for FileMaker Server use. Here is the current list ...

Instant Web Publishing - Privilege allows browser access to the file by using instant web publishing

ODBC/ JDBC - Privilege allows ODBC/ JDBC access to the file or not

FileMaker Network - Privilege allows the database to be networked ( or not )

FileMaker Mobile - Privilege allows FileMaker Mobile software access to the file or not

and the server related options are XML Web Publishing, XSLT Web Publishing and PHP Web Publishing.

As you look at the area where the extended privileges are set ... you see there is room for expansion. The extended privilege set area looks like a portal that can easily have more than the 4 default options.

** now we can start talking about our function! **

You can create your own extended privilege sets by the way. You might be asking, “why would I do such a thing?”. Well, the answer involves a Get Function called Get ( ExtendedPrivileges ). This function will supply a return delimited list of the extended privileges the current account has access to. So you can create calculation branches for scripts, calculation fields and even access to areas of your solution. All customized by you!

=
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 ... 36 Next 5 Entries »