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!

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.

Sunday
Dec302007

FILEMAKER: DYK: Calculations And Show Dialog Box

From Dwayne Wright
www.dwaynewright.com

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? Calculations And Show Dialog Box
One very nice script step is called Show Dialog box, which allows you to show the user a pop up dialog box window. The Show Dialog box script step allows you to use calculations for the title of the dialog box, the message to the user and the labels for the 3 input fields.


If you think about it for a moment, there are some very remarkable possibilities. You could show a completely different message depending upon some calculated condition. Using get and design functions, you can tell a lot about what is going on in a FileMaker file or computer system. Based upon a calculated result, you can customize the entire appearance and purpose of the dialog box.

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

FILEMAKER: The Get(LayoutCount) Function

From Dwayne Wright
www.dwaynewright.com

Get(LayoutCount)
FMP Version: FileMaker 7 and higher
Returns a number result

This Get function returns the number of layouts in the current FileMaker file. This is a complete count of the layouts including layouts the current user may not have access to view or layouts that do not appear in the layout list in browse mode.

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

FILEMAKER: The Get(LayoutAccess) Function

From Dwayne Wright
www.dwaynewright.com

Get(LayoutAccess)
FMP Version: FileMaker 7 And Higher
Returns A Number Result

A privilege set can be used to apply precise control over what a user can or cannot do for a particular layout. The layout access privilege options are ...

All modifiable - This setting will allow anyone, using this privilege set, to modify all layouts within the file.

All view only - This setting will allow all layouts to be viewable but they cannot be modified. This privilege settings will not allow it's users access to layout mode changes.

All no access - All layouts will toss up an Access Denied gray screen over the layout.

Customized - With this setting, all layouts can have customized and individual settings. From the customized layout access dialog box, you can choose if a layout can be modified, viewed or has a no access setting. This can also be setup for records on that layout with the same three settings.

So back to the Get(LayoutAccess) function, it will return a number result that corresponds to a users layout access. It will only return information about the layout access and that may not tell you the entire story. FileMaker security can be layered, like an onion. You might have modifiable access to a layout but have record restrictions. This function will not return information about record level access settings. That would be done with the Get(RecordAccess) function. Here is what the function will return based upon the layout access of the user when the function is called upon 0 for no access, 1 for view only access or 2 for modifiable access to the 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.

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