Goto Layouts by Name...

[Addam]

This is kind of like the other post "by Number"...

SINARIO:

I have a database where I've locked up the navigation so I can create my own (security reasons). Now, I've got it down to where I have a value list that is displaying the contents of a filed that I have called "LayoutNames" (List of Layouts in the database). Instead of me building a nav bar full of grapic reps of the layous, would like for them to be able to pick one from this particular drop down list and go.

PURPOSE:

I have given my users rights to create layouts BUT they can only do so in another database. I've figured out how to get a list of layouts in that database, but in the scripting portion of it, I can only do it by number. Can it be done by name somehow? This way if they create a new layout in the other database, the names will always stay current and I don't have to make any other navigation changes.

Can anyone help?

Thanks!

~Addam~

[Kurt Knippel]

Lookup the Design functions in the online help for Filemaker. Since Filemaker 5 (or maybe 5.5) there is a function to return the list of layout names.

[Addam]

Hey Kurt!

I got that portion figured out... now it's actually getting to the layout that's the problem.

[CobaltSky]

Hello Addam,

There's a demo of this available for free download from my web site. It shows a pop-up menu from which provides a list of layout names. When you make a selection from the list, a script (which is activated when you first click on the field) takes you to that layout.

If you're interested, the URL to download the demo is:

http://www.nightwing.com.au/FileMaker/demos/LayoutMenu.zip

The file is password free so that you can work through it "from the inside out".

[Kurt Knippel]

Ok, got it. Get the list of Layout Names. The "Layout Number" is simply its position in that list. So either use the Troi text plugin's GetLine function or use a more complicated Filemaker calc to determine which line the layout name is on. This is the layout number.

[CobaltSky]

If you want the FileMaker calc syntax, here it is:

PatternCount(Middle(LayoutNames(Status(CurrentFileName)), 1,

Position(LayoutNames(Status(CurrentFileName)), gSelectedLayout, 1, 1)), "

[Addam]

You guys are GREAT!! CobaltSky... thank for the calc! That was what I was looking for! Kurt! You are the BOMB!! Gosh! you guys are the best!

Cheers!