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.”
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.
Here’s my setup:
("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.
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/
SUBSTITUTE(fieldName, " ", "%20") means I can streamline our URL builder tool - at least for simple single-line URL parameters.
I’d like to see a
URLENCODE(fieldName) function eventually.
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: