Skip to main content
Question

Formula redirect that passes a dynamic value to a report?

  • November 18, 2022
  • 0 replies
  • 101 views
Is it possible to pass along a value in a redirect that can be used as a filter in the report I redirect to?

For example, say I click a formula rich text button, and in it is a line like this:

var text url = URLRoot() & "db/" & [_DBID_GROUP_IDS] & "?a=q&qid=7&_fid_7=" & $rid;

Where _fid_7 is the [related parent id], and make that report filter on [related parent id] = _fid_7?

------------------------------
Christopher Greene
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • November 18, 2022
Sure, just make an <ask the user> report and answer the question it is asking

The syntax would be

var text url = URLRoot() & "db/" & [_DBID_GROUP_IDS]
& "?a=q&qid=7&nv=1&v0=" & $rid;

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement