Forum Discussion

Re: URL to print a list of record based on _fid_ instead of rid

I see two choices. 

1. Use the technique here to run the report and then print the report. 


https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MessageKey=7afe6b7e-eeaf-4025-bdba-34d1232607c0&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer&ReturnUrl=%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3dd860b0f8-6a48-487b-b346-44c47a19a804%26tab%3ddigestviewer


2.  When sitting on a parent purchase order there will be an embedded list of purchase order lines. On the top of that embedded report there is a native button to print and have your users just use the nativo print button.



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------

3 Replies

  • QBSystem's avatar
    QBSystem
    Qrew Member
    Thanks. I am using the first method.

    Now how do I wrap it in the a=printr or a=printrecords&ridlist= so it takes me to the Print one record per page like it does with the a=printrecords.

    Thanks again

    ------------------------------
    Chaim Weiss
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      I have been hanging around this forum for a lot of years and never seen a solution to that question.  I don't think there is a way to make a single click button take you into a print screen.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      [email protected]
      ------------------------------
      • QBSystem's avatar
        QBSystem
        Qrew Member
        There is a way to print directly a single record:

        URLRoot() & "db/" & Dbid() & "?a=printr&rid=" & [Record ID#]

        And to print a list of records:

        URLRoot() & "db/" & Dbid() & "?a=printrecords&ridlist=8545&start=0&num=1&dfid=2

        We are only looking to replace the ridlist with our query.

        Thanks

        ------------------------------
        Chaim Weiss
        ------------------------------