Multiple sets of values in value list

Classic Servoy
1

Hi all

I need to be able to provide an individual valuelist to different users, such that they can use a checkbox to flag various records with various tags that they have set up.

The checkbox field works well, and my code for changing between the users, and reloading their own set of values also works well (I have a ‘tags’ table, with a username, a tag name, and whether it is active or inactive). Changing the user per form changes the valuelist, and each can see their own set of flags, and flag rows.

I understood that a valuelist populates a text field with values, and removes the values when they are deselected from the valuelist. However I have just noticed, after thinking that it was all working well, that if I change the valuelist to one of the other users’ valuelists, and make a choice, ALL other choices from the original user are deleted.

Is there any way to change this behaviour, or protect the previously entered values when changing a valuelist?

Thanks for any guidance you can give.

Bevil

2

Ik think something goes wrong with your reloading or storing te data Its hard to say without any example

3

bevil:
if I change the valuelist to one of the other users’ valuelists, and make a choice, ALL other choices from the original user are deleted.

Is there any way to change this behaviour, or protect the previously entered values when changing a valuelist?l

This is expected behavior for radio, checkboxes and comboboxes. To get additive behavior, a workaround is to not connect them directly to the final datasource but to a local variable. Then manually manage the local variable with the final data source. Keep in mind that checkbox (multiple choice enumerator) stores values separated with line breaks.

4

Hi David

Thanks for that… I was angling toward doing it something like that (I was going to use a join table to store the data, and ‘enable’ / ‘disable’ the values there).

Bevil