Append to a list box action

[#1]

Hi,

This is the current behaviour of a button Selection action :

"Select in Field" action : clears the current selection of the target list box and then adds the search string to it.

"Toggle Select" action: , toggles the target box selection state of the search string.

But, there is no "Append Select" to append the search string to the existing selection of the target list box. Is there a workaround?

[Anonymous · Accepted solution]

Hi,

you can use this expression in a select in field action:

= chr(40) &  concat(distinct YourField, '|'  ) & '|YourValue' &chr(41)

Best Regards

Stefan

[#3]

Thank You. After tweaking it a bit to fit my app it worked great.

[#4]

Hi,

I just noticed that YourField returns all possible values if nothing is already selected in the target list. So when something is added to the list for the first time, everything becomes green (selected). I tried to replace YourField with GetFieldSelections(YourField) function but that does not work. Here is my actual button Search String:

=chr(40) &  concat(distinct  replace(store_name,store_name,'"'&store_name&'"'), '|'  ) & '|' & '$(vAddToStores)' &chr(41)

Is there a simple solution for this?

[Anonymous]

Hi,

This should work:

= If(getselectedcount (store_name)> 0,chr(40) &  concat(distinct  replace(store_name,store_name,'"'&store_name&'"'), '|'  ) & '|' & '$(vAddToStores)' &chr(41))

Best regards

Stefan

[#6]

yes, it does. Thank you.