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!

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.

Friday
Dec282007

FILEMAKER: The Get(LastODBCError) Function

From Dwayne Wright
www.dwaynewright.com

Get(LastODBCError)
FMP Version: FileMaker 7 and higher
Returns data in a text format

This function will return the last ODBC Error based upon the ISO/IEF standards.

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

Thursday
Dec272007

FILEMAKER: The Get(LastMessageChoice) Function

From Dwayne Wright
www.dwaynewright.com

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

This function is linked to the Show Custom Dialog script step. Using this function, you can see which of the 3 possible choices the user made from the dialog box the Show Custom Dialog script step provides.

In the dialog box, the users selection of the first choice on the right will return a 1

In the dialog box, the users selection of the middle choice will return a 2

In the dialog box, the users selection of the first choice on the left will return a 3

It is kind of weird but the order is reversed when the developer is setting up the Show Custom Dialog. In this case, the option to the far left is the default and returns a 1 by the Get(LastMessageChoice) function, then then goes to the right.

This is what the developer sees.

This is what the user sees when the script is executed.

The way the Get(LastMessageChoice) is used in a script is that after the Show Custom Dialog script step, the developer would include a set of branching IF statements. Depending on the result returned from the Get(LastMessageChoice), aka the choice made by the user via the dialog box, the script will perform a set of script steps.

This is what a typical script may look at using the above examples as context.
=
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.

Wednesday
Dec262007

FILEMAKER: The Get(LastError) Function

From Dwayne Wright
www.dwaynewright.com

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

While a script is running, this get function will return a numerical result for any encountered error. For the function to work properly, the script step of Set Error Capture [ on ] needs to in use before you can trap the error.

We all have had the experience of encountering a FileMaker error message. The most common occurrence is when FileMaker tells you that it didn't find any records that match your settings in a find command. Which isn't so much an error as a condition message from FileMaker.

Some of the messages you get from FileMaker after an error might be confusing, particularly to the users that are not familiar with FileMaker. The Set Error Capture step is the fundamental first step that allows ScriptMaker to detect errors in advance and instead of showing FileMakers error message ... allows the developer run a set of script steps.

When Set Error Capture script step is included in a script and is set to the ON position, FileMaker's Error Messages to the user is off while the script is running. You then can use the IF, ELSE and END IF scripts steps are part of your error handling routine.

This is good if you want to trap for an error condition in a script and build a customized reaction ( such as a customized dialog box or performing a subscript ). A listing of all the error code numbers can be found in the online help of FileMaker.
=
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
Dec242007

FILEMAKER: The Get(HostName) Function

From Dwayne Wright
www.dwaynewright.com

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

When a file is hosted in a multi-user setting, this get function will return the name of the host as it appears on the network (set via the operating system). The host is the machine that first opens a database file that is being hosted on a network ( in a pier to pier setting ) or the FileMaker Server that is sharing the database over the network.

The name of the FileMaker Server can also be set using the FileMaker 9 Server Admin Console.
=
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 ... 41 Next 5 Entries »