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~

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.

Hey Kurt!

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

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

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.

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

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

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

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!