Forum Discussion

UrsulaLl's avatar
UrsulaLl
Qrew Assistant Captain
8 years ago

Create URL formula that redirect and also calls a script

I need to create a button that will update a record and redirect back to the edit form, and at the same time, trigger a script to run in the background.  The orginal URL formula field states the foll...
UrsulaLl's avatar
UrsulaLl
Qrew Assistant Captain
8 years ago
Ended up doing some funky stuff to get it working right. I am posting it here just in case anyone else comes across this issue. 

var Text encoded = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#];
var Text linkBase = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&AppToken=XXXX&rid=" & URLEncode ([Record ID#])& "&_fid_233=yes&_fid_254=" & Now() & "&rdr=" & $encoded;

"<a class='Vibrant' href='#'
onclick=\"javascript:
$.getScript('" & URLRoot() & "db/" &Dbid() & "?a=dbpage&pagename=SCRIPT.JS&rand='+Math.random());
$.get('" & $linkbase & "',function(){" & "location.reload(true);" & "});"
& "void(0);\">
</a>"

Whew, this one took a lot of brain use, glad I got it working
  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    8 years ago
    Hi Ana,

    I have a scenario where I need to first refresh the record then, edit the same record and update the parent record. Can you please help me with that?

    If you want, you can take a look at my question here.

    Do let me know if you need any further information.

    Thanks,

    Gaurav