How do I create a url with a formula?


This is what I have tried: ""&pinColor&"/“number_”&sort&".png"

I’m getting this error:: “Sorry, there was a problem saving this column. Invalid formula. Please check your formula text.”


Never mind. I see the problem. The formula should be: “"&pinColor&"/"&“number_”&sort&".png


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:


("" & 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.


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.


Thank you @JMichaelTX !!! :raised_hands:

So far I’ve been asking users to manually URL encode their strings via

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


Yes. Me too. I just want to see clickable text that opens the url if clicked.