Forum Discussion

JonathanSpence1's avatar
JonathanSpence1
Qrew Member
5 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_XXX...
APIs and custom code
Buttons
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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
    5 years ago
    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
      5 years ago
      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
      ------------------------------
      • JonathanSpence1's avatar
        JonathanSpence1
        Qrew Member
        5 years ago
        Yes they've got to enter some data by hand.

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