Forum Discussion

AndrewFry's avatar
AndrewFry
Qrew Assistant Captain
5 years ago

Edit, Save, redirect

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