Help

Convert url to plain text

Topic Labels: Formulas
2202 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Dave_Thorne
5 - Automation Enthusiast
5 - Automation Enthusiast

Newbie question, I have a URL column but also want a single text column containing the url but in plain text tried =""&{URL} but that just copies the hyperlink to the new column.
any ideas?

1 Reply 1
Zollie
10 - Mercury
10 - Mercury

I think this is a result of auto-formatting on Airtable’s part. If you enter www.someurl.com into a single text field, it’ll become a link as well. Below is my attempt at solving, but I wasn’t able to either. This might be worth contacting Airtable about.

""&{URL} would have been my first thought too. I was able to get proper results when concatenating a string with a value (such as “1”). But after running a substitution (even in a separate column) to remove that added character, it reverts to URL form.