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