Link to Record URL Formula - error

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

This formula

URLRoot() & "db/" & Dbid() & URLEncode("?a=er&rid=")&ToText([Record ID#])

is producing this result 

https://tiret.quickbase.com/db/bj5g3nssu%3Fa%3Der%26rid%3D1

when I'd like it to produce this result

https://tiret.quickbase.com/db/bj5g3nssu?a=er&rid=1&rl=bu8

Can anyone tell me where I've gone astray?

thank you.

Photo of Roth

Roth

  • 30 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
No problem.  You don't need to URLEncode for this

URLRoot() & "db/" & Dbid() & "?a=er&rid=" & ToText([Record ID#])