Forum Discussion

ReneeHansen's avatar
ReneeHansen
Qrew Member
4 years ago

Create a button that displays an embedded report from a different table

Hello, I want to create a button that displays an embedded report from a different table that is related to what's on the current record. I want a button to go in the green circle and op...
Forms
reports and charts
KirkTrachy1's avatar
KirkTrachy1
Quickbase Staff
Hi Renee:

QuickBase uses report links to display related records. These can be from the same table but mostly these are displaying child records that somehow relate to the parent record (like, "display all the tasks where my project's Record ID# matches the Related Project reference field"). And if you use this you can choose either a link or an embedded report.  If neither of them satisfy need you can also add a formula URL field and make that a button that will do the same thing.

The video shows how to gather the information we need for the button and how to build it.

URLRoot()&"db/"&[_DBID_TASKS]&"?a=q&qt=tab&dvqid=32&query={'48'.TV.'"&[Record ID#]&"'}&clist=6.23.127.67.12.13.108.33.86.85.76.77.10.98.75.3.84&slist=12.77&opts=so-AA.gb-V.qws."

 We cover questions like this in our daily, "Office Hours" webinars held each weekday, M-F at 1pm Eastern time. This is an open Q&A session where we take questions and build solutions. 

------------------------------
Kirk Trachy , Senior Solutions Consultant
QuickBase | 603-674-5454 M | ktrachy@quickbase.com
------------------------------
ReneeHansen's avatar
ReneeHansen
Qrew Member
4 years ago

I can't even begin to thank you enough Kirk, I watch all of your videos religiously on YouTube to help me learn!

I am going to give this a watch and see if it works and I may have more questions after! :)

I have just been blown away by Quickbase since Feb 2020 when I discovered it and decided we needed a database for our company. I dove in headfirst and EVERYONE has been so nice and so helpful!

Thank you again!



------------------------------
Renee Hansen
------------------------------