Add data to Multi-select field
Hi, I want to use names from a text lookup field as the source of a multi-select field. Some lines of the text lookup field have multiple names which are currently separated by ";". On the multi-sele...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendSo are you looking for the original fields to be "de-duplicated" and listed vertically in the resultant field?
Hi Mark,
Yes, I'm looking for the new field (Impacted brand field) to have all options in the Brand field listed vertically so users can select whichever they want.
- MarkShnier__You
Oh no sorry, I don't have a way to so that.
Can you have the concept of a dedicated table that lists the Brands instead of pulling them from where they are comcing now. Or does that list change too often??
No the list doesn't change too often. Maybe once a month.
There is already a separate table in a different app that houses all the brands individually. I tried to pull that table into my app and then use that field as the source of a multiselect field but I got an error because I have more than 100 brands in that table.
Ideally, I would only want to show the brand names with the same ID# in the multiselect field - that would only be like 5 choices per line item maximum - so it should work but I don't know how to filter the data to only show matching choices.
Is there a way to filter it maybe with a formula multiselect field?