Discussions

 View Only
  • 1.  Edit, Save, redirect

    Posted 05-30-2020 07:57
    I am drawing a blank on this URL Formula.
    I am in the record's form and have a custom URL Formula button.
    When clicked, I need it to edit a field in that record, save, then redirect to the parent record in view mode.

    The code I have been using is the following:

    var text EditAssignment = URLRoot() & "db/" & Dbid()
    & "?act=API_EDITRecord&rid=" & [Assignment ID#]
    & "&_fid_157=" & "1";

    var text DisplayParent = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Assignment ID#];

    $EditAssignment
    & "&NextURL=" & URLEncode($DisplayParent)


    However, I get an error message. I have tried changing the second [Assignment ID#] to the [Related Job], as well as [Job ID#], but neither takes me back to the parent record.

    FYI, [Job ID#] is the unique record ID field for the parent record.

    What am I getting wrong in my formula?

    ------------------------------
    Andrew
    andrew.fry25@gmail.com
    ------------------------------


  • 2.  RE: Edit, Save, redirect

    Posted 05-30-2020 08:04
    It would help if you let us know the error message :)

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------