Unanswered

Collect Combo box selections in columns not rows

(0) Share

Report

Posted on by kgiles123

224

I have a combo box that I've limited to a max selection of three items. Instead of stacking the items in rows in a table I would like the result to populate three columns on a single row with just the Title items that were selected in the combo box.

Here is my current formula:

If(CountRows(Self.SelectedItems)>3,Reset(Self);Notify("Only Three Items Allowed"));
ClearCollect(colTreatment, TreatmentCombo.SelectedItems)

Here is how my collection currently appears:

Categories:

General Questions

All responses (3)

Answers (0)

Ethan_009 4,838 Super User 2025 Season 1 on at

Like (0)

Report
Re: Collect Combo box selections in columns not rows

Hi @kgiles123 ,

Yes, it is possible

For example, use a Label control and insert following formula in the Text/Default

Concat(ColTitle, Title, ", ")

You will get merged data separated with ", "

Hope this helps
kgiles123 224 on at

Like (0)

Report

Re: Collect Combo box selections in columns not rows

thank you for your help! Title is now it's own column. I was hoping that I could have three columns and a single row containing all the selections. Is that possible?
Ethan_009 4,838 Super User 2025 Season 1 on at

Like (1)

Report
Re: Collect Combo box selections in columns not rows

Hi @kgiles123 ,

If you create another collection, do you get the Title column only?

Append this code after your colTreatment code

ClearCollect(colTitle, ShowColumns(colTreatment, "Title"));

Hope this helps