Button to Open Report from Other Table.

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • In Progress
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?
Photo of Todd Griffith

Todd Griffith

  • 220 Points 100 badge 2x thumb

Posted 10 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
np
just 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&qid=1"
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
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#.