I wonder if there is a way to do this, would be great 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 as it is, 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.
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.
Please, if I am missing something here, and this can actually work somehow, then please do let me know! Or if there is some other way that I should be considering, I would love to know as well!
I actually have three fields that I would like to work this way if possible!
The only real downside for now, is as I said, the search capability is somewhat diminished without having a dop-down present in teh sheet view!
I am surprised that it does not work! 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 field mentioned, then in that case it would recognize my free text field, and the separate values present, separated by comas.