Forum Discussion

Qrew Trainee

4 years ago

JS code in the URL formula field

Hey, There are several URL formula fields in my application. They were created a couple of weeks ago and work great. Today I was surprised that QuickBase no longer allows me to edit them. How to so...

APIs and custom code

javascript

AndrewS

Qrew Trainee

var Number XXX = If([Active], 0,1);

var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=d7f7g4xdisdv7fdgjvh95d4d3xzc"
& "&_fid_99=" & $XXX;

"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);"

------------------------------
Andrew S
------------------------------

MarkShnier__You

Qrew Legend

4 years ago

this should work

var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=d7f7g4xdisdv7fdgjvh95d4d3xzc"
& "&_fid_99=" & $XXX;

var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();

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

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

AndrewS
Qrew Trainee
4 years ago
Thanks Mark, it works fine. Is it any way to redirect and scroll down to the record that was modified?

------------------------------
Andrew S
------------------------------
- MarkShnier__You
  Qrew Legend
  4 years ago
  ... no, not that I know of, unless it behaves that way in the old report style (ie use the old report), I don't have time to test that right now.
  
  ------------------------------
  Mark Shnier (YQC)
  mark.shnier@gmail.com
  ------------------------------