Forum Discussion

JeffRogerson's avatar
JeffRogerson
Qrew Cadet
7 years ago

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

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 UR...
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
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.