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 LegendI'm trying to understand your terminology here when you say this.
in
No, the page has a dropdown that displays:
List 1
List 2
List 3
etc.
Each list generates a report with different records.
Each record has a button "Claim", which when clicked, takes the user to the Default form for the table the report and page the dropdown is in, where the user clicks a 2nd button that reads [Add Record].
The process itself works, but instead of the saved record returning to the Default Form where they clicked the Add Record button, I want to redirect the user to the list they clicked the "Claim" button.
The reason for this is so the user doesn't have to click "Reports and Charts">"Claims List">"Select list from the dropdown">"Display Report".
------------------------------
Rene Jamis
------------------------------
- MarkShnier__You
Maybe this is what you want.
// update the formula below to specify the Report ID to redirect to. ie change the10 11 and 12.
var text ReportNumber = Case(
- ,
"List 1", "10",
"List 2", "11",
"List 3", "12");
URLRoot() & "db/" & [_DBID_TABLE_B] & "?a=API_GenAddRecordForm&_fid_29=" & URLEncode ([CID])
& "&NextURL=" & URLEncode(URLRoot() & "db/" & dbid() & "a=q&qid=" & $ReportNumber)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------I'm not quite sure how this would work since, it would appear that all ID seem to the the same #.
Here are the report links for 2 different lists. The only difference is the actual list name.at the end.
https://jlodge.quickbase.com/db/somestring/tablereport?a=q&qid=11&nv=1&v0=List+1
https://jlodge.quickbase.com/db/somestring/tablereport?a=q&qid=11&nv=1&v0=List+2I presume the ids you wanted me to change for the code were "q&qid=11"?
Is the ampersand "&" the issue with just using one of the links I showed here as a redirect URL?
------------------------------
Rene Jamis
------------------------------- MarkShnier__You
OK, 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
------------------------------