Redirect to report in another table

Question

1st let me apologize for the post if this answer has been provided in another post.&nbsp; I Just Cant Get It. (Head ban on wall)!!!
Scenario:
in  default page allows users to select a list from a combobox. (List 1, List 2, etc)_.
Each list has different records.&nbsp; Each record has a button that locks record x to the user that clied it and keeps others from editing that same record
Regardless of the list/record in the list that is selected, the default .Form is displayed.
Form contains Formula URL field displayed as a button [Add Record] containing the following formula.
If(="List 1",URLRoot() &amp; "db/" &amp; [_DBID_TABLE_B] &amp; "?a=API_GenAddRecordForm&amp;_fid_29=" &amp; URLEncode ([CID])&amp; "&amp;z=" &amp; Rurl(),"")
When clicked 's default form is opened, CID is populated into that form, and other fields are displayed.&nbsp; When saved, user is redirected back to .Dafault Form where the [Add Record] button was clicked.&nbsp; What I want is for the user to be redirected to the list they initially selected.I've tried:
If(="List 1",URLRoot() &amp; "db/" &amp; [_DBID_TABLE_B] &amp; "?a=API_GenAddRecordForm&amp;_fid_29=" &amp; URLEncode ([CID])&amp; "&amp;z=" &amp; Rurl(https://quickbasecomain/blah),"")
__________________
URLRoot() &amp; "db/" &amp; [_DBID_TABLE_B] &amp; "?a=API_GenAddRecordForm&amp;_fid_29=" &amp; URLEncode ([CID])&amp; "&amp;z=" &amp; Rurl("https://quickbasecomain/blah"),"")
__________________
var text RedrctURL = "https://...";URLRoot() &amp; "db/" &amp; [_DBID_TABLE_B] &amp; "?a=API_GenAddRecordForm&amp;_fid_29=" &amp; URLEncode ([CID])&amp; "&amp;z=" &amp; Rurl(RedrctURL),"")
__________________
var text RedrctURL = "https://...";URLRoot() &amp; "db/" &amp; [_DBID_TABLE_B] &amp; "?a=API_GenAddRecordForm&amp;_fid_29=" &amp; URLEncode ([CID])&amp; "&amp;z=" &amp; Rurl($RedrctURL),"")
I clearly need a URL Redirect for super dummies
So much for wanting to be a QB app developer.
Any help would be GREATLY appreciated.
Thanks
------------------------------Rene Jamis------------------------------

markshnier__you · Answer

I'm trying to understand your terminology here when you say this.&nbsp;&nbsp;

in  default page allows users to select a list from a combobox. (List 1, List 2, etc)_.

Are you referring to the user selecting a dynamic filter on that table homepage report?

------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

renejamis1 · Answer

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

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() &amp; "db/" &amp; [_DBID_TABLE_B] &amp; "?a=API_GenAddRecordForm&amp;_fid_29=" &amp; URLEncode ([CID])
&amp; "&amp;NextURL=" &amp; URLEncode(URLRoot() &amp; "db/" &amp; dbid() &amp; "a=q&amp;qid=" &amp; $ReportNumber)

------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

renejamis1 · Answer

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.&nbsp; The only difference is the actual list name.at the end.
https://jlodge.quickbase.com/db/somestring/tablereport?a=q&amp;qid=11&amp;nv=1&amp;v0=List+1https://jlodge.quickbase.com/db/somestring/tablereport?a=q&amp;qid=11&amp;nv=1&amp;v0=List+2
I presume the ids you wanted me to change for the code were "q&amp;qid=11"?
Is the ampersand "&amp;" the issue with just using one of the links I showed here as a redirect URL?------------------------------Rene Jamis------------------------------

markshnier__you · Answer

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.&nbsp;

I believe that the Table Home Page report where you are starting is in fact an &lt;ask the User&gt; 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() &amp; "db/" &amp; [_DBID_TABLE_B] &amp; "?a=API_GenAddRecordForm&amp;_fid_29=" &amp; URLEncode ([CID])
&amp; "&amp;NextURL=" &amp; URLEncode(URLRoot() &amp; "db/" &amp; dbid() &amp; "a=q&amp;qid=11&amp;nv=1&amp;v0=" &amp; )
------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Redirect to report in another table