Forum Discussion

ChristopherGre3's avatar
ChristopherGre3
Qrew Trainee
2 years ago

Formula redirect that passes a dynamic value to a report?

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
------------------------------
  • 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
    ------------------------------
    • ChristopherGre3's avatar
      ChristopherGre3
      Qrew Trainee
      Awesome, Mark. Adding this to my small library of tricks. Have a good holiday week next week.

      ------------------------------
      Christopher Greene
      ------------------------------