Prefilled Form In Airtable Works - When Emailed Through Automation - Results in Different Link

[Shana]

Hi There. I’d appreciate getting my Emailed Prefilled Airtable Forms Link to sync up with my AirTable Data.

I have 4 Fields being prefilled into an Airtable Form.

First Name
Last Name
Email Address
Mobile Phone #

I wrote a formula (with the help of the amazing Airtable Community) to pre-populate filled fields into an Airtable form. The link for the form with the pre-populated section works perfectly in my AirTable Base.

The problem arises when I use Airtable Automation to email the link. The emailed link is different from the link that was created in the Airtable Base.

I’d appreciate any help to get the emailed link to match the formulaic link shown in my Airtable.

Thank you.

Result in AirTable:
https://airtable.com/XXXX?prefill_First%20Name=Mickey&prefill_Last%20Name=Mouse&prefill_Email%20Addr...

Result when Emailed:
https://airtable.com/XXXX?prefillFirst%20Name=Mickey&prefillLast%20Name=Mouse&prefillEmail%20Address...

The difference in the links is the ‘prefill_’ (From Airtable) vs ‘prefill’ (Email)

Thank you!

[Kamille_Parks]

AirTable Automations Are Breaking My Links Automations

I ran a quick test that confirmed this markdown connection. Apparently the field data is inserted before markdown processing occurs, so underscores that come from fields are viewed as italics highlight markers. [Screen Shot 2020-10-23 at 5.34.54 PM] The way I got the second URL to pass through was by using a formula field that adds a backslash before each underscore. It was a longshot because backslashes are often used in strings to “escape” a character that should not be processed normally …

[Shana · Accepted solution]

Thank you! That solution worked like a charm.