Once again I'm stuck and hope somebody that has the knowledge has time to help me out.

I'm working on a way to have the layout names appear in a PopUp menu so that the user can go to that layout. All fine... but I want the user to create layouts him/her self. This creates the problem that I want the new created layout appear in that PopUp menu as well.

My guess is that it can't be done automatically because FM does not allow to do a Value List on the calculated field that contains the Layout names.

So how do I get somebody to add the exact same layoutname to the normal text field that is connected to the Value list of the PopUp menu?

Or are there other solutions.....

Hmmm.... hope somebody can understand my Dutch way of thinking

Thanks in advance,

Rakesh

If you want the user to add lay-outs, you can let him edit the value-list containing the layout-lists as well.. or use some way of predefined lay-out names like USRDEF01, USRDEF02, and make some sort of errorcatching if the lay-out sought for is not there..

>mmm.. hope somebody can understand my Dutch way of thinking

niet helemaal..

Harryk

Hi Rakesh,

If I'm understanding you correctly, and I believe I am. You are wanting to have a pop-up menu like the "Jump" menu at the bottom of this page and have it so that your users can go between layouts by selecting a layout.

If so, I have some bad news - good news. First the bad news. FileMaker can *Not* execute a script when leaving a field. Good news, there are some workarounds that approach this feature, check out these to files to start with.

Script Execution on Exiting Field - URL

http://www.fmfiles.com/tnt8.html

Field Exit Runs Script - URL

http://www.fmfiles.com/dev10.html

Getting your list of layouts into a field to be use as a list is the tricky one, I haven't been able to do it through the Design Function, the only way I know of is to manually capture their names and put them in. You will also need to type them into the calculation attached to the work around.

Anyone have a better idea for getting a list of Layout names into a Value List, please let us know.

TIA

Lee

Thanks HarryK for your answer.

This is the solution I came up with. Please let me know what you think of it.

I created a field type: Text with an Auto-Enter Calculation LayoutNames("documentname").

Then I linked the Value List to that field from the PopUp field.

The only problem is that it won't show when there are no records and when a Layout is added it will only show if you create a new record.

That's not much of a problem because I use this document only as print file and it gets emptied after closing. So when I import new records for printing. All the layouts are there.

In any other case I will have to let the user adjust the Value List like you suggested. Thanks for the tip!

Much appreciated Lee,

The Field Exit script is something quite interesting and haven't seen yet. Thanks!

One way I got the problem PopUp problem solved was with the help of NightWing:

Pop-Up Layout Menu for Navigation

I did choose for the a seperate "GO" button in the end, because I noticed that when I get to a layout without using the Pop-Up, it switches immediatly when I click on it.

Just a quick thought:

Is there a way to remove words from a Value Lists by another field?

So, let's say Value List "trick" gets it's values from Text field "Data" which creates a list:

Tiny

Medium

Fun

Large

ExtraLarge

Is it then possible to have another Text field named "Delete" which substracts words from the Value List when it contains the same words. Like "ExtraLarge Fun". Which will create the list:

Tiny

Medium

Large

Perhaps this is to wicked to ask

Thanks for all your time.