Search Project Mgmt
Search FileMaker Blogs
Friday
Sep192008

FILEMAKER: The Set Selection Script Step

From Dwayne Wright - Certified FileMaker 9 Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright

Using the Set Selection script step, you can determine where in the field data you want to start and where you want to end an insertion. The starting and ending values can be hard coded (literally typed in) or use a calculated result (most commonly involving the text functions or Right, Left or Middle). The values you use have to be within the range of 1 and the total number of characters in the field. You cannot use negative numbers and the end value must be greater than the starting value to select anything.

You can set the start value to be the same as the end value to place the insertion point somewhere. You do not get an error if you set the end value lower than the start value, FileMaker will simply put the insertion point at the end value you specified.


A very common use for this is to automatically take a user to the beginning of or the ending of a notes field. It is also common to use this as an automated copy, cut or paste routine.

Got To Know Factor - 1
=
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.

Monday
Jun302008

FILEMAKER: Select Dictionary Script Step

From Dwayne Wright - Certified FileMaker 9 Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright

The Select Dictionary script step basically does the same as selecting the Select Dictionary menu command. The dictionary files are how FileMaker spell checks information. You could choose a different dictionary that has different terms. For example, you might have a medical dictionary for your medical database database files/tables and a technical dictionary for your technical support files/tables.

Here you can see the select dictionaries menu command.

HOW IT IS USED
Perhaps as a startup script for new users. Also it could be used when a FileMaker solution is in kiosk mode, this allows you to access a menu command that isn’t available in kiosk mode.

Got To Know Factor - 3

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

Saturday
Jun072008

FILEMAKER: Nested If Script Steps Vs Sequential If Scripts

From Dwayne Wright - Certified FileMaker 9 Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright

There are two big families of advanced IF statements, the nested IF and the sequential IF. Well, I guess there is a third, which would be the combination of the two.

A nested IF is when a scripted IF statement ( including IF, ELSE and END IF ) is enclosed within another scripted IF statement. This is called nesting and is quite common in any programming like environment.

A sequential IF is when a scripted IF statement ( including IF, ELSE and END IF ) starts right after a scripted IF statement ends. Many times, a script that uses sequential IFs will have an Exit or Halt script step somewhere in the IF statements. This is a way to perform a test and exit the script completely.

I’m different in my approach to scripting in that I tend to use a sequential IF much more than a nested IF. I just think it is easier to read and therefore faster for me to program with. It does has some redundant END IF statements in my complex scripts but I’m just fine with that.
=
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.

====================== ADVERTISEMENT ==============================
For more information on InBizness Money including screen shots and tutorial movies, please visit http://www.dwaynewright.com/solutions.html
====================================

Friday
Jun062008

FILEMAKER: Enable Account Script Step

From Dwayne Wright - Certified FileMaker 9 Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright

FileMaker security accounts can be in a FileMaker solution but inactive. This can be helpful if you are going to hire a bunch of new people or need to disable an account for a period of time. The Enable Account script step allows you to toggle an accounts status from active or inactive.

You do need to specify the account name in which you want to work with. This can be hard coded or you can use the specify button to bring up the FileMaker calculation dialog box for a more dynamic way to choose and account.

The activate / deactivate setting is set via radio buttons allowing you to pick one or the other. So if you want to have a toggle effect, you would need to use the Enable Account script step twice in the script. You cannot dynamically choose one or the other.

HOW IT IS USED
I can be very useful in situations where you want at activate or deactivate a found set of user records within a database solution.

Got To Know Factor - 3

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

Sunday
May252008

FILEMAKER: Introduction To Intermediate Script Design

From Dwayne Wright - Certified FileMaker 9 Developer
www.dwaynewright.com
info@dwaynewright.com
TWITTER: dwaynewright

We have just about completed describing all the script steps in FileMaker up to and including the current version of FileMaker 9. So I’m going to get started on the meat and the potatoes of scripting. I will be posting a script step description and another more advanced topic when I post to this blog.

To best prepare for this series of discussions, you will also need to have a good foundation of knowledge in FileMaker calculations and relationships. This is because when you begin to advance as a script designer, you will begin to work with scripts, calculations and relationships in concert.

If you are having troubles in the areas of calculations, relationships or portals, I encourage you to investigate my web blogs that are dedicated to those subjects.

FileMaker Calculations And Functions Explored
FileMaker Relationships Explored
FileMaker Portals Explored
=
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.