Make a user-entered data field clickable to earlier record

  • 0
  • 1
  • Question
  • Updated 6 years ago
  • Answered
Hi, I'm trying to link a user-entered data field to an earlier record. I currently have a field called "See Job #" that a user can fill in to let us know to refer back to an existing record for more information. Can Quickbase automatically make the data in that field clickable, so when I view the report I can just click to the earlier job instead of having to do a search for it?

For example:

1) User enters "5414" into field "See Job #_____"

2) In the report, "5414" clicks over to Job Number 5414

Thanks for the help!
Photo of John

John

  • 0 Points

Posted 6 years ago

  • 0
  • 1
Photo of Mark_Shnier

Mark_Shnier

  • 700 Points 500 badge 2x thumb
There are some tricky nuances in the answer.  Can you tell me - when the user clicks the link are you looking to open up a new tab or can you live with staying in the same tab.
Photo of John

John

  • 0 Points
Having the old record appear in a new tab would be ideal so I can compare the two, but I can live with one tab if the other way is a problem. Thanks Mark!
Photo of Mark_Shnier

Mark_Shnier

  • 700 Points 500 badge 2x thumb
If you can live with staying in the same tab, then this would work as a formula text field with HTML enabled (that checkbox)

"<a href=\" " & URLRoot() & "db/" & dbid()& "?a=dr&rid=" & ToText([My record ID# of Old Job])& "\">" & totext([My record ID# of Old Job])& "</a>"

If you wanted it to read like See Job # 1234 then you could do it like

"See Job# " &
"<a href=\" " & URLRoot() & "db/" & dbid() & "?a=dr&rid=" & ToText([My record ID# of Old Job]) & "\">" & totext([My record ID# of Old Job])& "</a>"


If you want to have a new tab open than you will need to make a formula URL field with the formula
if([My record ID# of Old Job]>0,
Urlroot() & "db/" & dbid() & "?a=dr&rid=" & totext([My record ID# of Old Job]))

You would have to show the old job # in a column to its own as a URL formula field will just have a std label such as "show old job".

The reason have why you cannot have the first method work on a report and open a new window is that when you click on the record to click that link it will open up that record too. But on the other hand, if you turn off View for that Report, then it would not behave that way - but then if the user did want to View they then you would need to build them a button to View the record.

... anyways try out some of these options and post back if you have questions.

Mark
Photo of John

John

  • 0 Points
Thanks very much Mark, I'll try these out!