Skip to main content
Question

Button to Open Report from Other Table.

  • January 9, 2018
  • 0 replies
  • 66 views
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?
      This topic has been closed for replies.

      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
      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#.
      Terms & ConditionsAccessibility statement