Search Project Mgmt
Search FileMaker Blogs

Thank you for visiting the FileMaker Thoughts 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
Jul282014

FileMaker Relationship Graph Buttons: Add, Edit & Delete 

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Along the bottom of the relationship graph area are a series of buttons that allow for table occurrence creation, relationship creation, alignment of table occurrence elements, viewing options for the graph and printing options for the graph. The first family of buttons are the table relationship buttons.


Here you can see the first five buttons in the relationship graph area.

The first button in the bottom button row is the Add Table Occurrence To Graph. Here you can add a table definition to the graph by clicking the button and then filling out the upcoming dialog box. The box will ask you which table you want to use and what name you want to give the occurrence. By default, FileMaker will try to name the occurrence after the table you selected. If the table occurrence already appears on the graph, FileMaker will attempt to add a number to the name such as Clients1, Clients2 or so forth.

You cannot have two table occurrences with the same name in the graph. If you could, you could get very confused which occurrence to use in relationship situations.

Before I adopted the design technique called anchor/buoy (which I will discuss later), I tended to name my table occurrences with some of the relationship information in them. For example, I may use a portal as a navigation aid. Portals can be easily filtered so I can easily jump to related records. In situations like this, I may want to create a set of table occurrences for this very purpose. I may name the occurrence People_rolodex, people_daytimer or people_filtered.


Here you can see the specify table dialog box when adding a new relationship to the relationship graph.


Here you can see that if the table you want to relate to isn’t in the current file, you can add a reference to another file. After you add that file reference, you can select any of the tables within that file to link your relationship to.

The second button in the bottom button row is the Add Relationship button. This button is an alternative way to create a relationship between two table occurrences. This button brings up the same define relationship dialog box we discussed in The Relationship Operator Box discussion. The only difference is that the two table occurrences you want to use have not been defined yet. You pick them and FileMaker will create the link for you. If a new table occurrence is needed, FileMaker will present you with a dialog box allowing you to do so.


Here you can see the Edit Relationship dialog box after clicking the second button. You will notice that no tables have been defined for either side of the relationship as of yet. However, I did click the pull down menu above the left side table occurrence area and can select a defined table occurence.


Here you can see the results of a properly defined relationship.

The third button is new as of FileMaker 8. It allows you to duplicate relationship graph objects. I have to admit this button was in there for quite some time before I even noticed it. It didn’t take that much longer before I started using it. You can select two linked tables, click the button and it will duplicate them with the relationship intact. You can then edit the relationship for your particular needs. You can also select unrelated table occurrences and duplicate them as well (sans their relationship settings to other table occurrences).

The later is the only way I use this button because I’m a strong advocate of the anchor/buoy relationship design system. I know that I keep bringing that topic up but I’m not ready to write about it yet. You can do a search for Kevin Frank anchor / buoy in Google and find his PowerPoint presentation on the topic. That was my introduction to it.

The fourth button in the bottom button row is the Edit Selected Object. You will need to select an object on the graph first and then click this button. You can edit the objects settings this way. I have to admit I never use this button because in most cases, you can double click an object in the graphic area and bypass the need to click this button.

The fifth button in the bottom button row is the Delete Selected Object. You will need to select an object on the graph first and then click this button. You can delete the objects ( which related to table occurrences ) this way. However, I don't think anyone really does it this way. In most cases, you can click an object, hit the delete key on the keyboard and bypass the need to click this button.

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

The WindowNames Function

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

WindowNames
No parameter is required but a filename parameter can be used
Introduced With FileMaker 7
Returns A Text Result

The WindowNames function gives you the name of each open FileMaker window. Each window name is listed separated by a carriage return. This function, like the DatabaseNames function, does not need a parameter. In FileMaker, you can have multiple windows open at a time. There are script steps that can open new windows and even give the windows specified names.

Example: At the moment that I'm writing this, I have three FileMaker windows open. I have two windows open for my afa_database and I have another file opened called Functions_7 ( which is an example file). So the function at the moment returned the following...

Functions_7
afa_database
afa_database - 2

Once again, by default, the WindowNames function does not have a parameter but you can certainly add one. You can specify a particular file that you want to capture the names of the windows for. This can be handy because if you have multiple files open, it is possible that the same window name may be used in individual windows.

Many times, when a design function parameter wants a file name, the developer will use the Get(FileName) function to provide the name of the current file. So if I had this function in my afa_database file and used the Get(FileName) function ... WindowNames(Get(FileName)) ... I would see the results of ...

afa_database
afa_database - 2
=
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
Jul272014

Talk to FileMaker Pro on a Macintosh (external link)

I was pretty sure this was a capability in the modern Macintosh and iOS FileMaker environments. I didn't have an occassion to leverage it until today. I came across the following post and wanted to be share it with my  auidence of blog readers. Below is a link to the posting ...

HomeBase Software - Talk to FileMaker Pro on a Macintosh

Sunday
Jul272014

Ways To Passover A FileMaker Script Step(S)

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

With FileMaker Pro Advanced, there is an easy way to disable script steps so that they do not execute when the script is run. There is a Disable button included right into the Edit Script dialog box. You simply need to click the script step(s) you want to disable and click the button.

To turn off the disable feature (or enable the step), simply click the disabled script step(s) and you will notice the disable button has changed into an enable button. Simply click it and the step(s) are good to go!

With the regular version of FileMaker Pro, there is no way to comment out an individual script step so that it does execute when the script is run.

There is a way but it's not a checkbox you can select from any dialog box. The idea is to use the IF script step in front of the script step (or contiguous set of steps) you want to comment out. Then make sure that the portion of the script step or steps you want to comment out are in an area of the IF statement that will always be false. For example, you can put in an IF parameter such as IF ( 1 = 2, then perform, else passover) So it would look something like this ...

Enter Browse Mode []
Go To Layout [Entry]
If ["1 = 2 ]
Perform Find [Restore]
Else
End If

Here the Perform Find step will never execute because it is branched by a statement that will always be FALSE.

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

Importing FileMaker Scripts, Don’t Underestimate It

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

The ability to import a set of scripts from one FileMaker file to another FileMaker file definitely helps reduce script development time and build more uniform solutions. In FileMaker 9, the button to import scripts was reduced in size to the point where it is quite easily missed. These small buttons do have mouse rollover tool tips attached. So you can hover the mouse above them and see which buttons perform which actions.

When you click the Import button, you get a script import dialog box. From this dialog box, you search for the FileMaker file you want to import the scripts from. There is even a Remote button in this dialog box, so you can import scripts from a networked file!

Once you pick out the file, you select which scripts you want to import via a check box next to each script. Then to wrap it up, you click the big import button and here the scripts come. Each imported script will have the word Copy after it. You will need to check each script for possible errors like missing fields, layout or relationships in the imported file.

Here you can see the import reported a couple errors. Based on the name of the script, you can see it is centered around going to a related record (gtrr for short). Chances are, my imported script involves a relationship setting I don’t have in my destination file. This is not uncommon at all, but still saves time from creating the script from scratch!

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

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