Forum Discussion

Qrew Member

4 years ago

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

I want to print single records when fid 19 = record id. I know this works: URLRoot() & "db/" & "brh639uhd" &"?a=printr&rid=" & [Record ID#] I want to base the records on fid 19 like: URLRoot(...

APIs and custom code

Printing

QBSystem

Qrew Member

No. I want to print records when the related PO line item = record ID#.

The name of the field is Related PO Line Item

Thanks

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

MarkShnier__You

Qrew Legend

4 years ago

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
mark.shnier@gmail.com
------------------------------

QBSystem
Qrew Member
4 years ago
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
  Qrew Legend
  4 years ago
  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
  mark.shnier@gmail.com
  ------------------------------
  - QBSystem
    Qrew Member
    4 years ago
    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
    ------------------------------