URL Button filtered by record clicked on

Question

I'd like a button that directs a user to a report that is filtered to show records based on the record from which is was clicked.

For example, the button lives on a Customers form. I click the button and it opens a report of Sales where Related Customer=[Record ID#] of the Customer I was on.

Is this possible?

------------------------------
Raymond Sakar
------------------------------

Is this possible?------------------------------Raymond Sakar------------------------------

justintorrence · Answer

I don't know if this is&nbsp;officially supported by Quickbase, but here is how I have achieved this in the past.

Create a report that uses an &lt;ask the user&gt; filter.
Run the report, provide the user value and copy the URL into a Formula - URL report.
Make the URL dynamic and change the parameter provided to the query at the end to the dynamic value you want to use.

Here is some additional details:
The "nv" parameter should be the number of responses being providedYou can have multiple v(n) parameters based on the number of responses providedIf you had a second filter to ask the user, the next parameter would be &amp;v1= [Dynamic Field]
------------------------------Justin TorrenceQuickbase Expert, Jaybird Technologiesjtorrence@jaybirdtechnologies.comhttps://www.jaybirdtechnologies.com/#community-post------------------------------

Forum Discussion

URL Button filtered by record clicked on