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 ...
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
      ------------------------------
    • AdamKeever1's avatar
      AdamKeever1
      Qrew Commander
      2 years ago

      Does this help, Mike?


      URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_7=Approved" & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl())


      URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_EditRecord&rid=42&_fid_7=Approved"&"&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=dbpage&pageID=30")

      Reference:
      https://helpv2.quickbase.com/hc/en-us/articles/4570366896532-Configure-URL-Fields-



      ------------------------------
      Adam Keever
      ------------------------------