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

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
  • (Edited)
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 the invoice record itself via a Rich Text Formula button. When going straight from the Invoice record I need to carry the Related Customer from the invoice to use as a filter of the report. 

The problem I am having is that once I convert the report to an ask the user, it removes the ability to display thta report on a dashboard page. 

Any way to do this without creating a separate report? 

Thanks
Photo of David Brogdon

David Brogdon

  • 1,222 Points 1k badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
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?
Photo of David Brogdon

David Brogdon

  • 1,222 Points 1k badge 2x thumb
Hey, thanks for your reply. I have figure out how to do that part, the problem I have is that once I make the report "ask the user" QB makes it to where that report cannot be displayed on a dashboard page. My question is, how can I answer the "ask the user" question but also still use the report on a dashboard page. 
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
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)