Announcements
I have two columns which contain the same type value which is country and now I have a dropbox which filters galleries by country but I don’t know how to get all items into one combobox.
Please help!
With a combobox you can use a Double layout and pick 2 columns to show.
No I mean like showing items individually and I just took as an example but I have 10 columns of countries which I need to have this filter showing all items across all 10 columns.
By filter I mean one combobox showing every country in all columns as items
I think you are going to be better off trying to make a one collumn collection from all your Collumns and then using that as the dropdown source.
So there is no way of doing what I want to do right?
Not with that attitude😁
ClearCollect(colCountries,RenameColumns(ShowColumns(yourlist,"firstcolumn"),"firstcolumn","ColumnA"),RenameColumns(ShowColumns(yourlist,"secondcolumn"),"secondcolumn","ColumnA"));
Keep adding Rename columns for each of your columns and this will stack them in collection under ColumnA. Change collection name and Column A to whatever you want. After this use the collection and ColumnA as your dropdown source.
Still not working could it be that I am pulling the data from exel?
After creating the collection did you change the combobox items datasource to the collection?
This is what I have done NewCountry is not a table or a column i just wrote that.
ClearCollect(
NewCountry,
RenameColumns(ShowColumns(Table1,"1st Country"),"1st Country","ColumnA"),
RenameColumns(ShowColumns(Table1,"2nd Country "),"2nd Country ","ColumnA")
);
Now in your dropdown use NewCountry for datasource and ColumnA as the field
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 638
Haque 317
WarrenBelz 315 Most Valuable Professional
