How to make this report URL point back only to the related report details

  • 40
  • 1
  • Question
  • Updated 4 months ago
  • Answered

I am making a new hire checklist.  Each checklist has several related reports to the checklist questions table.  Each report has a "completed" button.  What I noticed while testing is that sometimes I might hit the completed button by mistake, which then removes the record from the report.  My easy answer to this was to have a link under the report that takes you back to the report, so you can easily un-tick the complete box.  

I am using a Formula-URL field so that I can "hard code" the proper link back to the report (so that the link is always correct and there for the next new hire checklist).  Here is where my question comes in.

This formula does bring me back to the proper report...

ToText(URLRoot() & "db/" & "bjftfrx2p" & "?a=q&qid=25")

However, it shows all the items in that report, not just the related report items.  I only want the related report items.  How can I change that formula to just show me the related report items?

Thanks!

Photo of Michael

Michael

  • 20 Points

Posted 4 years ago

  • 40
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
You will need to relocate the effect of a Report Link field which has the concept of filtering only record for the related parent.

To do that make a report with an <ask the user> for related parent.  Run he report, answer the question of. With the record ID if any parent and  and observe the URL.  We need to replicate that URL.

The formula will be

URLRoot() & "db/" & [_DBID_of the child table with the ask the user report that you get from the Table's Advanced Properties] & "?a=q&qid=99&nv=1&v0=" & ToText([Related Parent]

Replace the 99 with the report number you see in hat URL when you ran the report, and for [Related Parent] use the reference field in the Relationship which ties the children back to the Parent.
Photo of Beth

Beth

  • 1,066 Points 1k badge 2x thumb
This was absolutely amazing! THANK YOU!  Solved an annoying report presentation issue that for two years I have just said, "deal with it."  No more. It even gets a nice pretty button now that the report does what I want it to do.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,246 Points 50k badge 2x thumb
Thx, I see I had some typos, but you got what I was saying.
Photo of Ruby Kapil

Ruby Kapil

  • 1,028 Points 1k badge 2x thumb
I'm using your formula and all is well except I would like to be able to have the 99 (the report id) reflect not a specific report but any report. I am using this button on a form and want the user to return to the report from which they selected the record. I don't know if there is a way to set the 99 to instead capture the qid versus hardcode a qid in there. Thanks. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,246 Points 50k badge 2x thumb
I suggest that you post this as a new complete question.