Discussions

Expand all | Collapse all

How to go to a specific page/record when you hit 'save'?

  • 1.  How to go to a specific page/record when you hit 'save'?

    Posted 05-10-2017 19:07
    I have one record that ends up having a relationship with another table that leads you to another table. Once you save a record on the 3rd table (two relationships away from original record) how do I get QB to take the user back ot the original record instead of the previous page?


  • 2.  RE: How to go to a specific page/record when you hit 'save'?

    Posted 05-10-2017 20:10
    There is a syntax which involved suffixing a URL with &NextURL = .... to control where a record goes after the save, but that has to to built into where the user launches off of to add a record.  

    Can you tell me where the user launches off of to get to that third record?  Is there a URL we can modify such as one which is doing act=API_GenAdRecordForm?


  • 3.  RE: How to go to a specific page/record when you hit 'save'?

    Posted 05-10-2017 20:16
    URLRoot() & "db/" & [_DBID_DOCUMENTS] & "?a=API_GenAddRecordForm&_fid_13=" & URLEncode ([Record ID#])& "&z=" & Rurl()


  • 4.  RE: How to go to a specific page/record when you hit 'save'?

    Posted 05-10-2017 20:26
    Ah, so we are in luck :)

    var text URLONE = URLRoot() & "db/" & [_DBID_DOCUMENTS] & "?a=API_GenAddRecordForm&_fid_13=" & URLEncode ([Record ID#]);

    var text URLTWO = Urlroot() & "db/" & [_DBID_TABLE name of where you want to land the user] & "?a=dr&rid=" & [Related Table 1 record # field for the record to show];

    $URL
    & "&rdr=" & URLEncode($URLTWO)