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!

Wednesday
Jan092008

FILEMAKER: The Get(PrinterName) Function

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

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

This function will return information about of the currently selected printer via the print selection in the computers operating system. This function will return different information based upon platform. For FileMaker users on Windows based machines, the function returns the printer name, driver name and printer port. For FileMaker users on Macintosh based machines, this function returns the IP address of the printer ( for networked printers ) and the printers name ( if specified ).

So if you are going to use this function in a mixed platform environment, you may need to nest the Get(PrinterName) function within the Get(SystemPlatform) function.

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

Wednesday
Jan092008

FILEMAKER: The Get(PreferencesPath) Function

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

Get(PreferencesPath)
FMP Version: FileMaker 8 and higher
Returns A Text Result

Each user that successfully logs into a Windows or Macintosh based computer will have a preferences/settings folder unique for them on that machine. The Get(PreferencesPath) function will return a text value of the path to the users preferences/settings folder.

For example, this is what is returned by using this function on my Macintosh ...
/Larry/Users/dwaynewright/Library/Preferences/

If I were using a Windows based machine, I may get something more akin to ...

/C:/Documents and Settings/dwaynewright/Local Settings/Application Data/
=
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.

Wednesday
Jan092008

FILEMAKER: The Get(PortalRowNumber) Function

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

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

This function will return the portal row that is selected or the portal field the cursor is within at the time the function is called upon. If the user isn’t in a portal, the function will return a 0. As with many of the Get functions, this function is looking at the current window in the foreground. Many times this function is used in scripts and particularly scripts that have loops.

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

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.

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