Formula To Create A Static URL of a record that will copy intact to a new copied record.

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
We use Quickbase to log events, many duplicate with only minor changes, so often a record is simply copied and necessary fields are updated. I am looking for a formula that would generate a Static URL of a record that would remain intact on the copied record, allowing the user to simply click on the URL to see the previous record.
Photo of JRogerson

JRogerson

  • 450 Points 250 badge 2x thumb

Posted 4 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,348 Points 50k badge 2x thumb
The formula to display a record is

URLroot() & "db/" & dbid() & "a=dr&rid=" & [Record ID#]


So just make a that formula field and then make a URL non formula field called static URL and make a form rule


When static URL is blank change static url to the value in the field formula url.
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,348 Points 50k badge 2x thumb
Note that with the solution above. If you copy a copied record, the static URL will refer to the very original record.

But that is actually good. You can make a report link field based on that static URL and show that on every ticket. Then automatically you will have a history of all the previous tickets that are related to that original ticket.

It is actually a pretty cool and easy technique. Thank you for making me think of it.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,348 Points 50k badge 2x thumb
It is not exactly good golfing weather where you live now. So I imagine you have lots of time for QuickBase development
Photo of JRogerson

JRogerson

  • 450 Points 250 badge 2x thumb
The winter has been crazy,so yes lots of time, just not enough intellect. When they say no code Development, yes in respect of creating a pretty simple application, but soon needs exceed abilities on this stuff.

(And lots of, "what I want to do seems simple, but why is it so hard,?)
Photo of JRogerson

JRogerson

  • 450 Points 250 badge 2x thumb
Thanks Mark, yes that is what I want, I will give it a go. Always appreciate your help.