Add data to Multi-select field

Question

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-select field I want to display the individual options on a separate line. Is this possible?

This is an example of what I have:

Brand (Text lookup field pulled from a separate table)

A
B; C
D; G; H
E; F

This is what I want:

Impacted brand (new multiselect field created)

A
B
C
D
E
F
G
H

I want the user to be able to select multiple brands from the list

markshnier__you · Answer

So are you looking for the original fields to be "de-duplicated" and listed vertically in the resultant field?

shalomeguale · Answer

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.&nbsp;

markshnier__you · Answer

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??

shalomeguale · Answer

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.&nbsp;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?&nbsp;

markshnier__you · Answer

No, there is not a way to filter that.An alternative is to go to a proper Many to Many table set up where you add multiple child records which then can be rolled up into the parent if you want.There is an app I put in the exchange called User Focus Examples and that does a demo of how the Quick Select can work to allow users to quickly select the children for a satisfying user experience. An advantage of the quick select method is you launch the user into a report which can be filtered however you like so that the choices offered are relevant&nbsp;Or contact me directly for a demo.

Forum Discussion

Add data to Multi-select field

5 Replies

Related Content

Multi-Select Fields with Commas in Pipelines

Checkbox Fields Vs Multi-Select Fields for Tracking

If Then Else formula with a multi select field.

Using multi select field in pipelines

How to Calculate Completion Percentage Using Multi-Select Boxes