Link & Load a free text field to Multipe Select

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

Hi,

We currently don’t have a way to separate values into multiple fields when linking and loading. Given that the values of the “Locality” field is summarized from 3 fields in the original sheet, the easiest way would be to load those 3 fields on the “Listing” sheet directly for search or filter purpose.

Hi Angie (long-time),

Firstly Angie, I never did ask “to separate the values into multiple fields when linking and loading” as you have stated above.

Now, if Ragic does not allow for any required design elements, I would understand completely! However, Ragic does encourage the making of Feature Requests on this its Forum site! So, I would oblige to do so, i.e. if I stumbled across some feature that I found to not yet be present in Ragic.

The ability or feature I am referring to in this case as stated before, is to be able to “load multiple free text values, separated by comas” into a “multiple select field”. Nothing to do with separating into separate fields, like you said. Separating a combined value into separate values maybe!

I understand that you may have been implying that there is no way to do this at the moment.

So great! Thought I’d better check first!

I will now proceed to make a feature request!

Thanks for your assistance again!

Kane

Hi Kane,

Regarding the use of Multi-Select Field based on selections from other field, although it is not supported natively right now. One workaround I managed to get working is to utilize the “|” separated value.
However, since that the Multi-Select Field doesn’t allow formula input.
I had to utilize Post-Workflow to insert the value into the target “Multi-Select Field”.

For example:
If there are A (Cell H1), B (Cell H2), C (Cell H3) three fields.
And I want to insert these 3 values into the target Multi-Select field. You can use a field to prepare the [text] with value separated by “|” before insert into the target field.
image

This method doesn’t just work with values coming from fixed number of fields. You can use this to get values from subtable as well. And insert all the values into Multi-Select field. Except that when you get distinct value from subtable by “UNIQUE(xx)” you need to replace the “,” with “|” with SUBSTITUTE() so the values are separated by “|” before you insert it by Post-Workflow.

For example: SUBSTITUTE(UNIQUE(D5),“,”,“|”)

See if it helps in your scenario.

1 Like

Hi Jeremy,

Very kind of you explaining all of this to me. I really have been wondering how to go about doing this! And my JavaScript really does leave a lot to be desired…

I have a work-a-round at the moment, but it does not accommodate for equal ownership vs co-listing for starters…

This looks like it will surely do exactly what it is I would like to do!

When I have a chance to implement, I will let you know how it all goes!

Thanks again, and all the best!

Kane

1 Like

@kanefranco You are welcome.
If you run into any issue, let me know.

1 Like