I need to open a record in a miniExtensions form prefilling values from Airtable fields - including a multi-select field.
I’ve used an extension to build a formula. The resulting URL works fine with an Airtable form, which populates all fields, including the multi select.
The miniExtension form won’t prefil the multi-select field using the same formula.
I can see the cause. The Airtable formula retrieves an array of values for the mini select field. However, it inserts a space after each comma.
Can anyone suggest how to adjust the formula to take out the spaces?
I found that it is the URL encode function that inserts the space.
As a solution, I wrapped the URL encode function with Regex_replace to remove the space trailing the commas. The miniExtensions form now works fine.