I am using a mulitselect list box that I need use all the values for somewhere else in my form( preferably coma or semicolon deliminated). In my text box I have the following TextBox = ListBox2.Selected.Value. This formula only gives me the last value selected. Am I missing something? thanks in advance
Solved! Go to Solution.
Hi Henry,
I tested your scenario with a new app with a multiselect listbox, using the default sample data for the listbox, and a textbox. The type of ListBox.Selected.Value is a table result so I was able to do the following to get the selected values.
TextBox1.Text = Concat(ListBox1.SelectedItems.Value, Concatenate(Text(Value),","))
Result:
Hi Henry,
I tested your scenario with a new app with a multiselect listbox, using the default sample data for the listbox, and a textbox. The type of ListBox.Selected.Value is a table result so I was able to do the following to get the selected values.
TextBox1.Text = Concat(ListBox1.SelectedItems.Value, Concatenate(Text(Value),","))
Result:
Is there anyway to have multiple items (i.e 1 and 2) selected when the page loads?
Hi Henry,
Did you get a way to pre multi-select listbox items onload ?
I am trying to achieve the exact same thing.
Any pointers would be greatly helpful ?
Thanks & Regards,
Rahul
The formula you have works on New form creation. But on edit, all the values selected are gone. If i make edit on other fileds, the list box values changes to default ( in my case it sets it to none).
Can you help with this please.
Thanks!
This function works perfectly on my app. I can save in my data base as string like "1,2,3"
But I have a question, how can I read back that string to a Listbox again, obviously I want to color those selected items in my listbox?
User | Count |
---|---|
184 | |
123 | |
91 | |
47 | |
42 |
User | Count |
---|---|
271 | |
159 | |
132 | |
85 | |
78 |