Forum Discussion

Qrew Cadet

4 years ago

filtering a query using URL text formula field

Can I use this URL Text Formula field (button) to query a report but show related records? This button sits in the Parent table record of this child table DBID_PLC. If Yes, What do I need to add to ma...

Formulas and functions

MarkShnier__You

Qrew Legend

no problem,

1. Make your perfect report with an <ask the user> filter for related parent.
2. Run the report and answer the question and observe the URL:

Then make a formula to mimic it.

URLRoot() & "db/" &[_DBID_PLC]&"?a=q&qid=6&nv=1&v0=" & [Record ID#];

If we translate that URL into plain English it says go to my realm and then go to this table and run Report number six and it will ask you for one value (nv=1) and the answer to the 0th value is [Record ID#]

If Report had two values to be answered then it would read like this &nv=2&v0= something & v1= something.

ie it starts numbering at zero.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

GeorgeBramhall2

Qrew Cadet

4 years ago

I would rather not ask the user. Since I am in the Parent record, Can't I some how grab the Record ID for the Parent record and use that to fetch all the related child records in the report?

------------------------------
George Bramhall
------------------------------

MarkShnier__You
Qrew Legend
4 years ago
No, you are not understanding. The whole point of that formula is to run the <ask the user> report and answer the question and display the report immediately to the user upon click.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- GeorgeBramhall2
  Qrew Cadet
  4 years ago
  Got it, worked like a charm! Thanks Mark.
  
  ------------------------------
  George Bramhall
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    4 years ago
    I am not sure why you use this method compared to just having a report link field on the form but an advantage of this method if you get to control the report which is used when you click. For example you might want to have a simple table report but with non-default columns and sort or you may want to click off to a summary report or even a chart. So essentially this method gives you full control over the destination of a link which looks like a report link.
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------