Forum Discussion

ColeenSchmitt1's avatar
ColeenSchmitt1
Qrew Cadet
6 years ago

Is it possible to create a report link that drives to a specific report?

Hi, I have two tables: Billing Month & Forecasts that are not related but I use a report link to connect the two based on a date field. I'd like for the Report Link on Table #1 to drive to a filter...
App builders
Formulas and functions
Relationships
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
OK, np.

Make  your perfect report with an <ask the user> filter for the field [Related Parent]    .... ie [Related Table #1]

Run the report manually and observe and mimic the URL you see when you answer the question.


Make a URL formula field on the Table #1

urlroot() & "db/" & [DBID_ of the table 2 from advanced settings]
& "?a=q&qid=xx&nv=1&v0=" & [Record ID#]