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

Question

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.

quickbasecoachd · Answer

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.

quickbasecoachd · Answer

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.

quickbasecoachd · Answer

It is not exactly good golfing weather where you live now. So I imagine you have lots of time for QuickBase development

jeffrogerson · Answer

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,?)

jeffrogerson · Answer

Thanks Mark, yes that is what I want,  I will give it a go.  Always appreciate your help.

Forum Discussion

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

Related Content

create pipeline to create new records based on current record

New Form - Show Create Record button

Create a formula duration over 5 years

Bulk create child records from selection list

Create A New Record In the Parent Table from the Child Record's Information