Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoYou 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
------------------------------
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
------------------------------
- MichaelTamoush5 years agoQrew CaptainThanks 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
------------------------------ - MichaelTamoush5 years agoQrew CaptainMark,
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__You5 years ago
Qrew Legend
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
------------------------------ - AdamKeever12 years agoQrew Commander
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
------------------------------