select Value List by Pop-up Menu

[vierdewereld]

Trying to figure out how to change between 4 Value lists with a Pop-up Menu.

What I want is actually quite simple but I'm breaking my brain on finding out how.

I would like to be able to change the Value List of, let say field "Checkinbox" displaying the Value List with Checkboxes.

There are 4 different Value Lists.

The idea is to use a Pop-up Menu field called "Changer" to select which Value List should be shown.

• 
  
• After trying with a Portal I noticed this won't work because I want each Value List to be on the same location. Using overlapping fields in a portal only makes all the fields in the Portal appear or disappear, so this didn't do it, having to change between 4 different Value Lists.
  
  
• Using Relationships to itself on another document I got stuck because it completely changed the order of the Value List and I need to keep the order I have in the Value List.
  

If only there is an calculation that changes the Value List of field Checkinbox by the choice made in field Changer.

Or are there other ways?

Really hope somebody is able to help me out with this. I spent a day trying/learning but still I don't have the result. Help...

Many thanks ahead.

[Ugo DI LUCA]

The simpliest workaround would be to have 4 similar layouts except from the field formating you want to change for. The popup menu would trigger a script (with doscript plugin or with a button close to the popup) "go to layout N

[BertBoye]

I

51733-conditional corrected.zip

[jasonwood]

You want a "conditional value list" (search for that in the forum). Unforunately, as you said, this reorders items. The only workaround I know of would be to number the items.

I don't think you'd want to deal with multiple layouts, you'd have to do a lot of scripting to make sure everything works properly for your application.

[vierdewereld]

Seems I'm still not there but thanks for all the suggestions!

A pitty but multiple layouts can't be the solution in my case...

The 'conditional corrected' document doesn't involve my problem...

Numbering the Value List entry's is indeed an option.

[color:"#666666"]_______________________________________________________

Still hoping to find a way to change between Value Lists without having to use multiple layouts...

[color:"black"] would really be cool

Thanks for all your interest.

[Ugo DI LUCA]

Have a look here also

[LaRetta]

Hi vierdewereld

Well, I was breaking a demo file apart today that might do just the trick! It's from CobaltSky's Nightwing website Automatic Value List

Truthfully, he has several in this same section that will most certainly meet your needs! Good luck to you.

LaRetta

[vierdewereld]

Hey dilucaugo,

That's MAGIC! It can really be useful and it's close to what I need.

I tried to do it with checkboxes and some problems came up. So maybe you can have a look at the file attached. I took the file with the pauze (you pointed out) and altered it with checkboxes.

I put the stacked fields a bit besides eachother to have a better view of what's happening.

[color:"yellow"]Problems:

1. When you select A or B and then click outside of the field and not in the checkbox that pops to the top. The Purple field will come to the top, blocking the checkboxes A or B. You will need to select A or B again to have them reach the top.

2. When you selected A and all the checkboxes (Red, Yellow, Black) and wish to disable the Yellow checkbox again, the Texvaluelist Field will popUp blocking the checkboxes. You can't get to them, only if you start again by selecting A in the Text field. [color:"pink"] This is not much of a problem, I'll probably have the Textvaluelist field not below with the stacked ones.

3. The checkboxes are visable even when A, B or C is not selected. It would be nice if they aren't visable when a selection is not made yet.

I really hope these problems can be solved which will be great for the database I'm developing.

Thanks for thinking with me.

choose value list(checkbox).zip

[vierdewereld]

Thank you LaRetta for the suggestion!

I played around with it and got stuck with the checkboxes. Something strange happends actually. Try it if you wish. I've added a file to quickly see what I mean with the bug.

Instead of the PopUp list, I created checkboxes with the two fields: TextField. The script that activates when clicking the top TextField (go to next field script) activates the field behind. [color:"purple"] Then the Value List from behind go to the top, but only the text! Even tho the field behind is NOT transparent. So the text of the checkboxes are MIXED together! Not something I can use...

Perhaps there is another solution to this... I'm happy to hear it.

I've scouted Nightwing... I couldn't find the solution there.

I'm overwhelmed with the help I recieved.... thank you all.

[LaRetta]

Hi vierdewereld!

Instead of the PopUp list, I created checkboxes with the two fields: TextField.

Not quite right! At the top of the demo are radio buttons (which you could, if you wished, change to be graphic container checkboxes) and would be labeled Client, Supplier and Other. Then, when a checkbox is selected, the User clicks ONE pop-up field (which would contain the multiple value lists). I think it's the cleanest solution for you.

Good luck!

LaRetta

[Ugo DI LUCA]

Put a blanck bordure over each checkboxes choices as a sandwich. Here is the file back. I also modified the pause to 1 second.

Edited : let the pause to 2 seconds. Doesn't work with 1.