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

Question

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!

QuickBaseCoachD · Answer

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.

Sign up

Login to the community