Question
Formula To Create A Static URL of a record that will copy intact to a new copied record.
+4We 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.
This topic has been closed for replies.
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.
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.
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.
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.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.