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

Expand all | Collapse all

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

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

    Posted 01-30-2019 12:37
    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.


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

    Posted 01-30-2019 12:43
    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.


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

    Posted 01-30-2019 12:49
    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.


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

    Posted 01-30-2019 12:50
    It is not exactly good golfing weather where you live now. So I imagine you have lots of time for QuickBase development


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

    Posted 01-30-2019 13:11
    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,?)


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

    Posted 01-30-2019 13:21
    Thanks Mark, yes that is what I want, I will give it a go. Always appreciate your help.