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
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
    ------------------------------