Forum Discussion

JeremyLahners's avatar
JeremyLahners
Qrew Cadet
4 years ago

Convert URL to text

I have a Formula Text field that is a combination of an integer and a URL.  Ultimately what I'd like is to just get the text as I am reusing that value elsewhere is our application and don't want a linked URL.  However when I review the field value it clearly presents as a URL.  Is there a type conversion or something I can do to remove the URL/linking behavior?  

Screenshot for reference:

TIA!

------------------------------
Jeremy Lahners
LeadBaller
------------------------------
Tables and fields
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    4 years ago
    Hi Jeremy,

    One way you can get the url as a plain text value is to create a formula text field and then just call the field into that text field. Then it won't be displaying as a link in a URL field type. Alternatively if you want to use that text somewhere in another formula, etc. you can also wrap that field in the ToText() formula function in a formula field.

    ------------------------------
    Evan Martinez
    ------------------------------