Apr 19, 2016 06:38 AM
This is what I have tried: "http://nwatagalog.xyz/maps/"&pinColor&"/“number_”&sort&".png"
I’m getting this error:: “Sorry, there was a problem saving this column. Invalid formula. Please check your formula text.”
Apr 19, 2016 06:41 AM
Never mind. I see the problem. The formula should be: “http://nwatagalog.xyz/maps/"&pinColor&"/"&“number_”&sort&".png”
Dec 15, 2016 05:22 PM
For any other Airtable beginners like me, you create the URL using a Formula Field type.
Airtable then recognizes that it is a valid URL, and when you click on it, it opens the web page.
Fantastic!
Here’s my setup:
Formula:
("https://search.cdc.gov/search?query=%22" & SUBSTITUTE(Name, " ", "%20")) & "%22&utf8=%E2%9C%93&affiliate=cdc-main"
Keep in mind that you have properly encode the URL.
Here, I just substituted %22
for spaces.
May 16, 2017 07:41 AM
I just jump on here and add my question if it’s possible to add a name/title for this link so instead of the URL you can show a text that is linked.
May 23, 2017 03:54 AM
Thank you @JMichaelTX !!! :raised_hands:
So far I’ve been asking users to manually URL encode their strings via http://www.url-encode-decode.com/
Using SUBSTITUTE(fieldName, " ", "%20")
means I can streamline our URL builder tool - at least for simple single-line URL parameters.
Yihaaaa!
I’d like to see a URLENCODE(fieldName)
function eventually.
Aug 14, 2018 02:27 PM
Yes. Me too. I just want to see clickable text that opens the url if clicked.
Jan 09, 2020 11:10 PM
For anyone seeing this, the ENCODE_URL_COMPONENT(component_string)
function was added sometime over the last year. See it in the Formula field reference under Text functions.
Feb 01, 2021 04:31 PM
What the …?! Why am I doing anything with formulas when I just want to have my button field link out to another url. I shouldn’t have to do anything except copy / paste the url into where I want the button to go… :frowning:
Jan 10, 2024 12:00 PM - edited Jan 10, 2024 12:06 PM
Solved: the expected input here is a string. Just put "quotemarks" around your URL and it should work.
If your URL has multiple components (path equals another Airtable field, for instance), just use the formula CONCATENATE().
Example: