Skip to main content
Question

filtering a query using URL text formula field

  • August 4, 2021
  • 0 replies
  • 198 views
GeorgeBramhall2
Forum|alt.badge.img+11
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 make this work? 

URLRoot() & "db/" &[_DBID_PLC]&"?a=q&qid=6";

------------------------------
George Bramhall
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement