Redirect to report in another table
1st let me apologize for the post if this answer has been provided in another post. I Just Cant Get It. (Head ban on wall)!!!
Scenario:
in default page allows users to select a list from a com...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOK, we will try one more answer on this Forum and if that does not work I will have mercy on you and do a short one on one Zoom call.
I believe that the Table Home Page report where you are starting is in fact an <ask the User> report where you are prompted to select a "List" from not a "combo box", but in fact a drop down list of the List Choices.
I believe that your question is how do you return to that same report with the List pre-selected, as you don't want to return the user to the Table Home Page and have to re-select the list again.
Assuming that my assumptions are correct, the first thing required will be to ensure that the
- field from Table A is a lookup field down to Table B.
Then try this as a formula to add a Table B Child and return (on Save) to the same List.
URLRoot() & "db/" & [_DBID_TABLE_B] & "?a=API_GenAddRecordForm&_fid_29=" & URLEncode ([CID])
& "&NextURL=" & URLEncode(URLRoot() & "db/" & dbid() & "a=q&qid=11&nv=1&v0=" & )
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Hi,
1st let me say thank you so very much for your assistance Mark.
While the last code you provided didn't work, It was enough to help me think through what needed to happen and what was what.
After trying countless, ok well, maybe not countless but certainly a dozenish, I figured it out.
It came to me at 4ish AM, or at least the hunch that the following part of the formula was wrong.
URLRoot() & "db/" & dbid() & "a=q&qid=11&nv=1&v0=" & ).
I read the following in the URL Formula Buttons for Dummies app,
"& "?a=dr&rid=" this says "Action = Display Record and the Record ID is""
This morning as I tossed and turned trying not to think of work, it thought "WAIT! a=q&qid=11&nv=1&v0= is a string literal and I don't think it's the same as the report link and Voila "tablereport?" was missing from your string.
My DB Admin's gonna be impressed.
Again, thank you so so much for your patience and assistance.
Cheers
------------------------------
Rene Jamis
------------------------------
- MarkShnier__You
Actually, what was missing was the ? In the last line
"?a=q&qid=11&nv=1&v0=" &
- )
Glad we got there in the end.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
