Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Button URL automation problem

Topic Labels: Automations
Solved
Jump to Solution
2830 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Nathan_Ramey
6 - Interface Innovator
6 - Interface Innovator

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.

1 Solution

Accepted Solutions

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.

See Solution in Thread

6 Replies 6

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
6 - Interface Innovator
6 - Interface Innovator

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.
image

@Vivid-Squid

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.

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

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.
Nathan_Ramey
6 - Interface Innovator
6 - Interface Innovator

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