Best way to do a 2-pane pick list/selector

Classic Servoy
1

I’m not sure if I am using the terms correctly (2-pane pick list). It is when one needs to pick available rows (as in 20 available fields to export) and then one chooses 12 rows to export.

Usually this appears as two “panes” of rows with arrows sandwiched between the panes (select or de-select rows/choices).

The Servoy native “Export” screen is a classic situation.

Does anyone have a suggestion or background in the best (and most reusable) way to go about this? Or, perhaps some code or … :)

I am undecided between datasets via the Database Manager node, relations (with global variables), conventional forms within a tab panel with the appropriate filters running, etc, etc.

Suggestions or tips?

Thanks

Michael

2

DISCLAIMER: I don’t program that often anymore so my advice might not be the best one to solve it.

I’d use 4 globals. 2 globas that maintain the arrays of selections and 2 globals to visualize it using html. The html triggers a method to click from left to right or viceversa and when done retriggers your generic method to set the contents of the html globals to match the arrays.

Coding time: approx 6 minutes
Debugging time: 3 minutes (for a normal programmer, in my case 7)

3

You could also consider using two Table-Beans. That way your users could either double click on a row to copy / remove it or even selecting multiple rows and drag them over to the other table…

4

Jan,

Coding time: approx 6 minutes
Debugging time: 3 minutes (for a normal programmer, in my case 7)

For me, while working out the techniques, probably more like my initials (M^2): so 36 minutes. :)

Thanks

and Patrick, thanks as well!