Button to Open Report from Other Table.

Question

I have been looking thru the postings, but cant seem to get anything to work.  I have two tables.  In Table 1 I would like to create a button that opens a report for table 2 in a popup window.  Can someone show me how to code that?

quickbasecoachd · Answer

npjust run the report and copy the URL onto your clipboard.Then make a URL formula field and set it to open in a new Window (there is a checkbox in field properties for that)put it in quotes"https://mycompany.quickbase.com/db/xxxxxxx?a=q&amp;qid=1

quickbasecoachd · Answer

Actually, I reread your question and I answered it too quickly thinking the other tablecwas in a different app.

A better answer is this

Formula url field

URLRoot() & "db/" & [_DBID_MY TABLE NAME] & "?a=q&qid=99"

Lookup the table name from the Advanced properties of the table with the report and 99 needs to be replaced by the report ID#.

Forum Discussion

Button to Open Report from Other Table.

Related Content

Building a report from multiple tables

API Button Help

Formula Url Buttons

+New Button

Multiple Tables Report