Button URL automation problem

[Nathan_Ramey]

Hello everybody! I was trying to create a automation that emails someone a prefilled form so they can respond to a record that somebody else put in. However both the button formula, and the record formula stops short of the entire form being a clickable link. It has the form link and then ?prefill then it stops. Can anyone help me with this? I would like the entire URL to be clickable.

[Vivid-Squid]

Hi @Nathan_Ramey
Are you using Markdown in the email body to format a link?

[text](URL)

Are you pulling in a formula that concatenates a prefilled URL? Can you post a screenshot of what you have?

[Nathan_Ramey]

This is my formula for both the button and the formula. Yes, I am using a concatenate formula to create a prefill link

“CONCATENATE(‘Airtablelink’,’?prefill_Type%20of%20Improvement=’,{Type of Improvement},’&prefill_Suggestion%20Topic=’,{Suggestion Topic},’&prefill_Description%20of%20Dysfunction=’,{Description of Dysfunction},’&prefill_Description%20of%20Solution=’,{Description of Solution},’&prefill_Anticipated Benefits=’,{Anticipated Benefits},’&prefill_Explain%20Anticipated%20benefits=’,{Explain Anticipated benefits},’&prefill_Adverse%20Effects=’,{Adverse Effects},’&prefill_Submitted%20By:=’,{Submitted By:},’&prefill_After%20Record%20ID=’,RECORD_ID(),’&hide_After%20Record%20ID=true’)”

Here is a snip of the email the red part is what the link shows then it stops after that.

@Vivid-Squid

[Kamille_Parks]

You have a bunch of spaces in your constructed URL because you’ve encoded some parts but not all. Try following this pattern

CONCATENATE(
  'airtable link',
  '?prefill_', ENCODE_URL_COMPONENT("Field Name 1"), '=', ENCODE_URL_COMPONENT({Field Name 1}),
  '&prefill_', ENCODE_URL_COMPONENT("Field Name 2"), '=', ENCODE_URL_COMPONENT({Field Name 2})
)

Or just use @kuovonne’s app that will write the correct formula for you.

Airtable

Prefilled Forms - Apps - Airtable Marketplace

Prefill forms with field values on Airtable with the Prefilled Forms app.

[Nathan_Ramey]

Okay, I used the app (very useful) but I am still having the same problem. It stops right after the ?prefill function.

[Kamille_Parks · Accepted solution]

Two things:

1. Pretty sure all Airtble form URLs start with airtable.com/shr but yours doesn’t. Make sure you copied the correct url.
2. If you’re putting this in the body of the Send Email step in an Automation, make sure you’ve inserted the link properly.

Airtable Support

Markdown in Airtable

Markdown is a lightweight and readable syntax used for formatting text. Formatting text can be useful in Airtable when you are looking to call attention to certain information or just looking for m...

Automation Email - URL link broken Automations

I only used the escaped urls when sending the url via an Airtable email automation so that the url is correct when the email arrives at the client. This thread has more info.

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 …

[Nathan_Ramey]

Alright I figured it out! Thanks for the help @Kamille_Parks @Vivid-Squid! It is appreciated!