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