Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

Utilize Record ID of current record, during a URL Button Push in a Report Link

Is there a sneaky way to accomplish the following?

- Viewing a Record in Table A
- On subject Record is a Report Link for UNRELATED Table B. One of the columns in the report link is a formula URL button
-When Pressing that Formula URL button, one of the actions needs to use the Record ID of the record the user is currently viewing in Table A

Any way to somehow get that record ID to use in that button push? It feels like this can't be possible, but some people here have come up with some creative ideas before...

Among other things, I would simply like to return to the Record in Table A I left from...and I don't believe & "&z=" & Rurl(); works with API_EditRecord?

------------------------------
Mike Tamoush
------------------------------
APIs and custom code
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    You can use the User Focus technique to have the user press a button on the Parent record to write the Record ID# of the parent record into a table of users.  That focus Record ID# would be looked up back down to the parent record and based on a form rule the child table report link would be exposed to the user.  Those table records would then have access ot that record ID#.

    I could help you one on one to set this up, or maybe you recall how to set up that User Focus Technique form previous work we may have done together.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      5 years ago
      Thanks Mark. Yeah I remember and that was one of my thoughts, was to have them press a button that writes to the user focus and then redirects back to the form. This is one extra button push I was hoping to avoid, but clearly it's impossible for Table B to have any clue which record is being viewed when utilizing the Table B Report Link.


      ------------------------------
      Mike Tamoush
      ------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      5 years ago
      Mark,

      Do you know if this is possible?

      On Record in Table A, looking at Unrelated Report Link of Table B.
      Push a formula URL button in the Report Link (on Table B), that runs API-EditRecord.
      Return to the Record in Table A

      (I won't have the Record ID at this point, I was hoping & "&z=" & Rurl() would do it, but either I coded it wrong or this doesnt work in that type of case?

      ------------------------------
      Mike Tamoush
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        That's not gunna work ....  I never heard of using that z=Rurl() with API_EditRecord.

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