Skip to main content
Question

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

  • February 11, 2021
  • 0 replies
  • 110 views
Forum|alt.badge.img+14
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
------------------------------

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • February 11, 2021
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement