Can you post screen shots of your data including column headings ? Do all of the options already exist in the configuration of the multiple select?

@kuovonne
I am populating value of category column from domain-category table into Source Category column of another table(SUBS-Table).

SUBS-Table Schema

domain,Source Category,Source URL,Target Category,Target URL,Email

As I already mentioned, Source Category and Target Category both are of type multi select.

Thank you for the screen shot. Can you also post screen shots of the configuration of the multiple-select field that you want to prefill?

It looks like the {category} field in the [domain-category] table is a long text field with choices separated by pipes |. However, when prefilling a muli-select field, the options need to be separated by commas ,. You may be able to use this in your formula to replace the pipes with commas …

ENCODE_URL_COMPONENT(SUBSTITUTE({category}, "|", ","))

ENCODE_URL_COMPONENT(SUBSTITUTE({category}, "|", ","))

@kuovonne
Thank you for replying to me. As {category} field was ‘|’ delimited. Hence , i tried to use below formula with SUBSTITUTE option. But still, didn’t work for me.

“url?” &
“prefill_domain=” & ENCODE_URL_COMPONENT({domain} & “”) & “&” &
“prefill_Source%20Category=” & ENCODE_URL_COMPONENT(SUBSTITUTE({category}, “|”, “,”) & “”) & “&” &
“prefill_Target%20Category=” & ENCODE_URL_COMPONENT({category} & “”)

multiple-select configuration

Thank you for the screen capture. Your multi-select field has no options. You cannot prefill a multi-select field unless the value already exist as options for the field.

@kuovonne Then , how to prefill this field dynamically? Providing the value as option to this field is nothing but assigning values statically . But, i would like to fill up those options dynamically?

Is there a way to populate multi-select field dynanically?

This is honestly a no-duh value add feature that is hugely annoying you don't have.  Silly AirTable.