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

Tuesday
Jan012008

DYK: Calculating The Else Command

From Dwayne Wright
www.dwaynewright.com

Did You Know? (a series of quick discussions on things that you might have missed about FileMaker).
------------------------------------------------------------------------------------------------------
DID YOU KNOW? Calculating The Else Command
In FileMaker, you can even use a calculation as part of an else statement. This means you can do away with a lot of lengthy nested If scripts or sequential If scripts!

Basically the Else If script step is a combination of the If and Else script steps. I wrote the following on purpose because it the actions are actually flipped (as the name implies).

The ElseIf needs to follow an IF script step (or another Else If) and it allows you to embed a calculation. If that calculation is a TRUE result (1=1 for example), then the script will perform all the script steps between that ELSE IF to a branch ending script step (such as another ELSE IF, END IF, Exit or Halt).

As I alluded to earlier, you can have many ELSE IF script steps in a scripts. This allows you to write a script that has an almost endless number of different branching actions.

Tuesday
Jan012008

FILEMAKER: The Get(LayoutNumber) Function

From Dwayne Wright
www.dwaynewright.com

Get(LayoutNumber)
FMP Version: FileMaker 7
Returns A Number Result

This Get function will return the position of the current layout in the layout order defined for the current file. Some FileMaker files are developed to use scripts and buttons to navigate from layout to layout. The Get(LayoutNumber) function can be very helpful if the users navigation through a fully scripted database is fully scripted. Using this function, you can build a log of what layouts the user has previously visited and script a "Back" button to return to the previously viewed layout.
=
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
Dec312007

DYK: About Calculation Exiting Script Loops

From Dwayne Wright
www.dwaynewright.com

Did You Know? (a series of quick discussions on things that you might have missed about FileMaker).
------------------------------------------------------------------------------------------------------
DID YOU KNOW?
About Calculation Exiting Script Loops
A calculation can be used to determine what set of conditions need to be met to exit out of an established ScriptMaker looping routine. For example, you could have ScriptMaker count how many times it performs a loop. Then, you can have ScriptMaker perform an Exit Loop If step when the counter meets a calculated result.

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

Monday
Dec312007

FILEMAKER: The Get(LayoutName) Function

From Dwayne Wright
www.dwaynewright.com

Get(LayoutName)
FMP Version: FileMaker 7 And Higher
Returns A Text Result

This function will return the defined name of the current layout being viewed in the current foreground window.

FYI ... Layout names do not need to be unique in the same FileMaker file. This is something you might want to remember if you are scripting an action with the Get(LayoutName) function and you have two or more layouts with the same name.

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