Discussions

 View Only
  • 1.  Formula redirect that passes a dynamic value to a report?

    Posted 17 days ago
    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
    ------------------------------


  • 2.  RE: Formula redirect that passes a dynamic value to a report?

    Posted 17 days ago
    Edited by Mark Shnier (Your Quickbase Coach) 17 days ago
    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
    ------------------------------



  • 3.  RE: Formula redirect that passes a dynamic value to a report?

    Posted 17 days ago
    Awesome, Mark. Adding this to my small library of tricks. Have a good holiday week next week.

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