Discussions

Expand all | Collapse all

Button to Open Report from Other Table.

  • 1.  Button to Open Report from Other Table.

    Posted 01-08-2018 22:53
    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?


  • 2.  RE: Button to Open Report from Other Table.

    Posted 01-08-2018 23:01
    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


  • 3.  RE: Button to Open Report from Other Table.

    Posted 01-09-2018 01:11
    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#.