Hi,
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.
Thanks,
Kane