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

GeorgeBramhall2

Qrew Cadet

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
  ------------------------------