URL button to trigger Automation
I've created a URL button that changes a check box field which in turn triggers an Automation to change values in certain fields. Everything works fine, however, I've now put these buttons into a...
Forum Discussion
Oliver,
I see from your posts you are making great progress in learning Quick Base. if you want to get the page to refresh, you will need to move from "no code" (Automations and Actions") to "Low Code" (URL formula buttons.)
I have put an app in the Exchange called URL Formuals for Dummies which explains some of what you would need to know. I suggest downloading that to read up on how they work.
Here is an example of updating a few fields on a record and refreshing the page
var text URL= URLRoot() & "db/" & [_DBID_TABLE_1] & "?act=API_EditRecord"
& "&rid=" & URLEncode ([Record ID#])
& "&_fid_7=" & URLEncode ([Status])
& "&_fid_8=1"
& "&_fid_9=" & URLEncode("the rain in Spain falls mainly in the plain")
& "&apptoken=" & "XXXXxxxx";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
The code above starts with a formula variable called URL. The formula URL text lays out the edit, specifying which record to be edited, and then it puts the value of the field [Status] into field ID 7 and then set the checkbox field ID 7 to be checked and puts a phrase into fid 8.
Then the javascript stuff below executes that URL formula and refreshes the page.
The app token will be required if you still have your app's Advanced Properties to require application tokens. Many developers turn that requirement off, but that is your call
You need to URLEncode where the text might have spaces or another characters which are not permitted in a URL.
Give it a try.
I see from your posts you are making great progress in learning Quick Base. if you want to get the page to refresh, you will need to move from "no code" (Automations and Actions") to "Low Code" (URL formula buttons.)
I have put an app in the Exchange called URL Formuals for Dummies which explains some of what you would need to know. I suggest downloading that to read up on how they work.
Here is an example of updating a few fields on a record and refreshing the page
var text URL= URLRoot() & "db/" & [_DBID_TABLE_1] & "?act=API_EditRecord"
& "&rid=" & URLEncode ([Record ID#])
& "&_fid_7=" & URLEncode ([Status])
& "&_fid_8=1"
& "&_fid_9=" & URLEncode("the rain in Spain falls mainly in the plain")
& "&apptoken=" & "XXXXxxxx";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
The code above starts with a formula variable called URL. The formula URL text lays out the edit, specifying which record to be edited, and then it puts the value of the field [Status] into field ID 7 and then set the checkbox field ID 7 to be checked and puts a phrase into fid 8.
Then the javascript stuff below executes that URL formula and refreshes the page.
The app token will be required if you still have your app's Advanced Properties to require application tokens. Many developers turn that requirement off, but that is your call
You need to URLEncode where the text might have spaces or another characters which are not permitted in a URL.
Give it a try.