You may refer to the previous support forum question…
Link & Load a free text field to Multipe Select - Support - Ragic Community
I would like to be able to this, and it is somewhat necessary for what I am working on!
I have a field LOCALITY on the property unit sheet, a free text field, it gets its info from three separate fields; Closest City, Greater Area, Area/Suburb.
I Link & Load the Locality field to the Listing sheet. At the moment the loaded Locality field on the Listing sheet is set to free text. I have tried setting it to Multiple Select, hoping that it would recognize the address values provided, separated by a coma.
But, it does not work, instead shows all values as a “single multiple select entry”, however if just one value is provided, it works fine in that case! Hmmm
The reason that it is kind of important/good that a free text can actually loaded to a multiple select, is specifically because I will be able to easily search and sort this field in the sheet view, i.e. with the individual items being present in the drop-down. This seems to occur when the field is set to multiple select or even just selection.
The only real downside for now, is as I said, the search capability is somewhat diminished without having a dop-down present in the sheet view!
I am surprised that it does not work at the moment! For if I were to import this same data else ware, into a website for instance, to populate a multiple select field, with the free text combined data mentioned, then in that case it would recognize my free text field, and the separate values present, separated by comas.
My two cents!