How to order fields

[#1]

Here is my issue. I am trying to get a field to work a desired way and dont know where to start.

Assume I have a field called Account and it is populated as follows.

1,2,3,4,5,6,7,8,9,10

when I select 4, the others will become gray and the order would look like this

4,1,2,3,5,6,7,8,9,10

What I would like it to do is show the following row so you could just step to the next number without having to scroll down (imagine a 10,000 rows)

4,5,6,7,8,9,10,1,2,3

Now I know I can uncheck the sort button but, it makes the selection harder to find if say your on 9,323.

Any solution would also have to work in Ajax ZFC but lets just take it one step at a time.

Also the user could make a selection from another field that would hone down the accounts to just show

4,7,9,10 and the rest gray

in this scenario, If the user then selects 9 I would expect the following

9,10,4,7,1,2,3,5,6,8

Is this even possible, where would I start?

[prieper]

Hi,

by default this is not possible, you should create a macro.

Alternatively you might search this forum - can recall that there was a post along with a tricky example with an underlying slider.

HTH

Peter

[johnw]

It may have been me that posted the "tricky example", but if so, it wasn't very tricky. Create a single value slider bar for the field, put it on the bottom layer, and size it so that the left and right arrows appear on either side of the list box. Now clicking on the right arrow will take you to the next value, and clicking on the left arrow will take you to the previous value. Not exactly what you asked for, but it may work.

Ah, here we are. Attached.

What I more commonly do is just remove the sort by state. At that point, your selection will appear at the bottom of the list box instead of at the top, and you can just scroll down slightly to pick the next one. But if I really wanted users to be able to just go "click click click" through the possibilities, I'd probably use a slider bar or a macro. I can give you a macro example if you want that too.

[prieper]

yep - this was it.

Guess you needed some hours and thinking out of the box. This is what I would call "tricky". Was a bit short of time, otherwise would have tried to search by myself in the forum.

Peter

[#5]

I havent had to create too many Macros so if I could see an exampole of yours that would be great. I like the slider but I would like to limit the selection and then scroll through those. I added the Zone field in you app and I unchecked "Always One selected value" from the Centre field. If I select Zone 10. Valid Centre selections are AINCOURT and then BRAY ET LU. Do you have a macro that could show me how to step through each relevant selection. so if I had AINCOURT selected and Zone 10 and then clicked the arrow, I would want BRAY ET LU selected in the Centre at that point?

Thanks for all you ideas.