Forum Discussion

JonathanSpence1's avatar
JonathanSpence1
Qrew Member
4 years ago

Formula URL to change field and return to report with same selection criteria

Hi
I have a URL formula that in a table report that opens up a form, to allow the user to update a particular field on the selected record;  that part works fine:

URLRoot() & "db/" & [_DBID_OB_XXXX & "?a=er&dfid=11&rid=" & [Record ID#]

Once they've done and click save, I want the user to be returned to the report from which they clicked the URL button, with the same selection criteria  that they had in operation when they pressed the url.  I've tried a few tricks but haven't managed to get any of them to work.  The user has selected a date to run the report, and that date is in a field in the record on which they pressed the URL; so if it was possible to maybe use nexturl to open the original report but pass that date on to the report so it opens the exactly as it was, that would be great; I just can't figure out a way to do it.  The user's got to edit a number of records this way for the same date, and if (as it does with everything I've tried thus far) it opens the report with no selection criteria, it's pretty tedious for them. 
Any suggestions welcomed..




------------------------------
Jonathan Spencer
------------------------------

  • How about a low tech solution?

    Check the box on that formula URL field "Open in new Window" or else the very new option from Sunday to open in popup?

    That way the original report is still sitting there.  The user will have an extra tab or popup to to close though.  But maybe that is the lesser evil.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JonathanSpence1's avatar
      JonathanSpence1
      Qrew Member
      Hi Mark
      I thought of that, but as I said the users have a lot or records to edit; they're not very IT-savvy either, so they'll get confused with a lot of new windows.

      ------------------------------
      Jonathan Spencer
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        When your users are editing the record I assume they are doing more than just checking a box or  setting a date field to today but they are actually entering data by hand? The reason I ask is if it was possible to edit the record by pushing a button and then there would be a good solution.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------