Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 01, 2022 07:33 AM
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.
Solved! Go to Solution.
Jun 01, 2022 10:21 AM
Two things:
airtable.com/shr
but yours doesn’t. Make sure you copied the correct url.Jun 01, 2022 07:52 AM
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?
Jun 01, 2022 08:07 AM
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.
Jun 01, 2022 09:13 AM
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.
Jun 01, 2022 09:56 AM
Okay, I used the app (very useful) but I am still having the same problem. It stops right after the ?prefill function.
Jun 01, 2022 10:21 AM
Two things:
airtable.com/shr
but yours doesn’t. Make sure you copied the correct url.Jun 02, 2022 08:40 AM
Alright I figured it out! Thanks for the help @Kamille_Parks @Vivid-Squid! It is appreciated!