Skip to main content

Convert url to plain text

  • March 31, 2020
  • 1 reply
  • 46 views

Forum|alt.badge.img+4

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

Forum|alt.badge.img+18
  • Inspiring
  • April 1, 2020

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.