Forum Discussion

JackWoods's avatar
JackWoods
Qrew Trainee
4 years ago

Formula off of a URL field

Hey Community,

I'm look to make a formula field based off a URL field on my project table.

If have a link URL field to link to our other CRM. It would hold a URl text like the bellow.

"https://enterprise.website.com/t3stD3m0N0tR33Lqb1"

what text formula field function would you use to make it so the formula text field would only display the text after the last /

aka: "t3stD3m0N0tR33Lqb1"

this will allow me to sync information back and forth from both systems.

Thank you for your help :)

------------------------------
Jack Woods
------------------------------

2 Replies

  • Assuming that here are not really any quotes in the string, the formula would be 

    Right([my field], "/")

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JackWoods's avatar
      JackWoods
      Qrew Trainee
      that worked perfectly - thank you :)

      ------------------------------
      Jack Woods | Low Code 4 Lyfe
      ------------------------------