Forum Discussion

RobinCC's avatar
RobinCC
Qrew Cadet
8 years ago

When pressing the native green save button, can I redirect to a report in a different table?

I have a URL formula button on a report in my TEAMS table that when pressed allows me to edit the current record by taking me to a secondary form (not the main form) in the TEAMS table.  Upon pressing...
Ask about Quickbase functionality
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Here is another solution which might be a better user interface as the user would not have to click a special save button.


var text URLONE = URLRoot() & "db/" & Dbid() & "?a=er&dfid=10&rid=" & ToText([Record ID#]);

var text URLTWO = URLRoot() & "db/" & [_DBID_my table name] & "?a=q&qid=xx";

$URLONE
& "&NextURL="  & URLEncode($URLTWO )
  • RobinCC's avatar
    RobinCC
    Qrew Cadet
    8 years ago
    Hi Mark,

    When I tried this method, it did not redirect to the TASK table.  It went back to the starting point in the TEAMS table.   Is there some other setting I need somewhere in my app or maybe I have a glitch?    


    var text URLONE = URLRoot() & "db/" & Dbid() & "?a=er&dfid=10&rid=" & ToText([Record ID#]);

    var text URLTWO = URLRoot() & "db/" & [_DBID_TASKS] & "?a=q&qid=7";

    $URLONE
    & "&NextURL="  & URLEncode($URLTWO )
  • RobinCC's avatar
    RobinCC
    Qrew Cadet
    8 years ago
    Strangely, if I go into the form properties briefly and then come back out, it DOES work.  .  I'm guessing this has to some kind of glitch......
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Ok, I just tested mine and it works. Maybe some weird temporary chaching issue.
  • JavierMartinez's avatar
    JavierMartinez
    Qrew Cadet
    7 years ago
    Where would you enter this formula?  Sorry for the "noob" question.  I'm new to app building and having issues when a certain role clicks save and close it is sending them to the wrong home page.  I've checked the role and home page settings and they are set up correctly.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    The formula I posted was to edit a record on a report on one table, but upon save redirect to a report on a different table.  That was the original question on this thread.  I will  respond to your question on its own thread as i see that you have a thread already going.