1 Button to update fields in two apps
I successfully created a button that updates fields in App2 from App1 but am wondering if I can also use this same button to update fields in App1. i.e. can a 2nd URLRoot statement be added to this ...
Forum Discussion
Thank you, I tried updating my button to the following. URLGOLD worked but not URLULH. Did I add to the javascript code correctly?
var text URLGOLD = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Project ID#] &
"&_fid_1778=" & URLEncode(Now()) &
"&_fid_1779=" & ToText(User()) &
"&apptoken=xxxxxxxxxxxxxxx";
var text URLULH=URLRoot() & "db/" & "ULHAPPID" & "?act=API_EditRecord&rid=" & [VZULH App Record ID]
& "&_fid_994=" & Now()
& "&_fid_992=" & Now() & " IRM Ready for Review per " & UserToName(User())
& "&apptoken=xxxxxxxxxxxxxxxxxx";
var text URLTHREE = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Project ID#];
"javascript:" &
"$.get('" &
$URLGOLD
& "&rdr=" & URLEncode($URLULH)
& URLEncode("&rdr=" & URLEncode($URLTHREE))&
"',function(){" &
"location.reload();"&
"});" &
"void(0);"
------------------------------
Christine White
------------------------------
var text URLGOLD = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Project ID#] &
"&_fid_1778=" & URLEncode(Now()) &
"&_fid_1779=" & ToText(User()) &
"&apptoken=xxxxxxxxxxxxxxx";
var text URLULH=URLRoot() & "db/" & "ULHAPPID" & "?act=API_EditRecord&rid=" & [VZULH App Record ID]
& "&_fid_994=" & Now()
& "&_fid_992=" & Now() & " IRM Ready for Review per " & UserToName(User())
& "&apptoken=xxxxxxxxxxxxxxxxxx";
var text URLTHREE = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Project ID#];
"javascript:" &
"$.get('" &
$URLGOLD
& "&rdr=" & URLEncode($URLULH)
& URLEncode("&rdr=" & URLEncode($URLTHREE))&
"',function(){" &
"location.reload();"&
"});" &
"void(0);"
------------------------------
Christine White
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendNo, that was my point. You cannot use the javascript refresh method with multiple API calls. or, at least if you can, the syntax is brutal.
var text URLGOLD = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Project ID#] &
"&_fid_1778=" & URLEncode(Now()) &
"&_fid_1779=" & ToText(User()) &
"&apptoken=xxxxxxxxxxxxxxx";
var text URLULH=URLRoot() & "db/" & "ULHAPPID" & "?act=API_EditRecord&rid=" & [VZULH App Record ID]
& "&_fid_994=" & Now()
& "&_fid_992=" & Now() & " IRM Ready for Review per " & UserToName(User())
& "&apptoken=xxxxxxxxxxxxxxxxxx";
var text URLTHREE = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Project ID#];
$URLGOLD
& "&rdr=" & URLEncode($URLULH)
& URLEncode("&rdr=" & URLEncode($URLTHREE))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text URLGOLD = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Project ID#] &
"&_fid_1778=" & URLEncode(Now()) &
"&_fid_1779=" & ToText(User()) &
"&apptoken=xxxxxxxxxxxxxxx";
var text URLULH=URLRoot() & "db/" & "ULHAPPID" & "?act=API_EditRecord&rid=" & [VZULH App Record ID]
& "&_fid_994=" & Now()
& "&_fid_992=" & Now() & " IRM Ready for Review per " & UserToName(User())
& "&apptoken=xxxxxxxxxxxxxxxxxx";
var text URLTHREE = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Project ID#];
$URLGOLD
& "&rdr=" & URLEncode($URLULH)
& URLEncode("&rdr=" & URLEncode($URLTHREE))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Got it. Thanks so much this worked. So what you were also saying is that this button will not work in reports (like a javascript version would) Correct?
------------------------------
Christine White
------------------------------- MarkShnier__Youright, so the button will "work" except it will land the user on the record. but the user probably expects to land back on the report. So it means that you need to COPY the button and change the URLTHREE to land on a report. So if you need the button on three reports then (yuck), three version of the button. So, not rocket science to do, just annoying to have to do)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thanks will give the report button a try. And sorry I haven't redirected to a report. Would you mind providing that line? Really appreciate all your help!
------------------------------
Christine White
------------------------------
- Works great. Thanks so much!!
------------------------------
Christine White
------------------------------