Forum Discussion

DavidBrogdon's avatar
DavidBrogdon
Qrew Assistant Captain
7 years ago

I need to filter report by source value, but still use report on dashboards

I have a report that shows all shipped items for invoicing. I use the report on a dashboard page for grid editing in the related invoice #.  However, I am also needing to link to this report from t...
App home pages
reports and charts
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
are you asking how to make a URL formula button that will run a report and answer an <ask the user> question automatically based on where you launched from?
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Make a new <ask the user> report

run the report and answer the question.

Observe the URL.

now make a formula URL button on the launch table records on the dashboard to match that.

URLRoot() & "db/" & [_DBID_table name from Advanced properties] & "?a=q&qid=xx&nv=1&v0=" & URLEncode(the field that has the answer to the question form the record you are launching from)