Embedded button: URL Syntax
I think my syntax is wrong, but I am unsure as to where exactly. I have a URL button in a child table that edits a few fields. I have that button in an embedded report in the parent form. My goal...
Forum Discussion
Hi Andrew,
What is the error message that you are getting? The RUrl will not work in this instance. You are using the EditRecord API, which will edit the record without any user interaction beyond pressing the button. This means that you would need to use "&rdr=" & URLEncode(URLRoot() & "db/" & DBID() & "?a=dr&rid=" & Primary Key Field) or you would need to use "key " instead of rid if you are using a primary key other than the default record id. This should get you back to the parent record.
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
What is the error message that you are getting? The RUrl will not work in this instance. You are using the EditRecord API, which will edit the record without any user interaction beyond pressing the button. This means that you would need to use "&rdr=" & URLEncode(URLRoot() & "db/" & DBID() & "?a=dr&rid=" & Primary Key Field) or you would need to use "key " instead of rid if you are using a primary key other than the default record id. This should get you back to the parent record.
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legend.. or here is alternate syntax
var text URL =
URLRoot() & "db/" & Dbid()
& "?act=API_EDITRecord&rid=" & [Job ID#]
& "&_fid_177=" & Now()
& "&_fid_178=" & UserToName(User(), "FF");
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text URL =
URLRoot() & "db/" & Dbid()
& "?act=API_EDITRecord&rid=" & [Job ID#]
& "&_fid_177=" & Now()
& "&_fid_178=" & UserToName(User(), "FF");
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thanks Mark!
I will give this a try.
I keep reading over and over in different places that JS is currently unofficially supported by QB And that QB could remove any use of JS from QB at any time.
How "safe" is it to use JS code when it could be dropped at any time from QB?
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------- Mark, thanks for the code, it worked great!
Is it possible to have the re-direct take me back to the same tab I was on initially?
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------- MarkShnier__YouSo far, no one on this Forum knows how to redirect to a particular tab. At least not remotely natively with simple code.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- MarkShnier__YouI do not believe that they will turn off javascript as it will break thousand of apps. But I think that they will give the IT manager at your company the ability to tun off javascript as Quick Base cannot guarantee security if it is allowed.
Quick Base does plan to introduce "New Forms" - when who knows maybe they will announce or even demo at EMPOWER. My guess is that new forms will not allow javascript, but old forms will be supported forever.
In the case of this refresh javascript, the alternative is that rdr syntax. So theoretical worst case is that Quick base gives yuo a heads up that they will be block javascript in a year, presumably they will give us a tool to identify the fields with javascript, and then we will have to convert the fields.
Meanwhile I continue to use that javascript refresh for now until it becomes clearer.
I believe that Quick Base Product Managers see the need to be able to execute an API and refresh the page. maybe they will give us a build in toggle setting on the field property to do that.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
