Can I create a Formula URL or Formula Text Button that will perform an action, without the need to navigate away from the current dashboard/report/record??I have several checkboxes/dates/users that are stored via a Formula-Text button (I like to put images on the buttons instead of the normal gray ones). However, when clicked these must navigate away and redirect somewhere.Is there a way to avoid this, being able to click the button and have it execute the command (API_EditRecord) without having to refresh the page.

This format will work on a record or a report.var text URL = URLRoot() & "db/" & "?act=API_EditRecord&_fid_80=1&rid=" & [Record ID#];"javascript:" &"$.get('" & $url & "',function(){" &"$.jGrowl('This Item has been put on PO CANCEL snooze', {life: 5000, theme: 'jGrowl-green'});" &"});" &"void(0);"The 5000 means it will display the pop up for 5 seconds before it fades away on its own.I have never tried this on a dashboard in part because the button needs to know which record to act on.

Just what I needed!! FYI, it works like a charm in reports as well!!BIG THANKS!

Is there a way to implement this from a Formula-Text button, instead of a Formula-URL ??Thanks

It took me a while to get this working as there were some recent posts from Laura Hillier and Matthew Neil which i needed to cobble together. But now i have it for myself too. There is some crazy syntax for sure.This workedvar text Update= URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_188=" & ToText(Now());var text URL = "javascript:" &"$.get('" & $Update & "',function(){" &"$.jGrowl('This Item has been put on PO CANCEL snooze', {life: 5000, theme: 'jGrowl-green'});" &"});" &"void(0);";"<a class='Vibrant Danger' href=\"" & $URL &"\"" & ">Button name goes here" & "</a>"The choices for the button color are:"<a class='Vibrant'>Vibrant</a>", // regular grey button :( "<a class='Vibrant Alert'>Vibrant Alert</a>", // yellowish "<a class='Vibrant Danger'>Vibrant Danger</a>", // red "<a class='Vibrant Primary'>Vibrant Primary</a>", // blue "<a class='Vibrant Snowy'>Vibrant Snowy</a>", // white "<a class='Vibrant Success'>Vibrant Success</a>" // green)

Mark, CarlosI cannot get either script to work. I am using a _fid_### of my own choosing, but not getting it populated. Here is the formula URL script I'm using:var text URL = URLRoot() & "db/" & "?act=API_EditRecord&_fid_158=1&rid=" & [Record ID#];"javascript:" &"$.get('" & $url & "',function(){" &"$.jGrowl('This Item has been put on PO CANCEL snooze', {life: 5000, theme: 'jGrowl-green'});" &"});" &"void(0);"Here is the formula Text script:var text Update= URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_158=" & ToText(Now());var text URL = "javascript:" &"$.get('" & $Update & "',function(){" &"$.jGrowl('This Item has been put on PO CANCEL snooze', {life: 5000, theme: 'jGrowl-green'});" &"});" &"void(0);";"<a class='Vibrant Danger' href=\"" & $URL &"\"" & ">Button name goes here" & "</a>"Any assistance is appreciated. Chris

Formula URL or Formula Text Button that will perform an action, without the need to navigate away from the current dashboard/report/record?

37 Replies

QuickBaseCoachD
Qrew Captain
8 years ago
This format will work on a record or a report.

var text URL = URLRoot() & "db/" & "?act=API_EditRecord&_fid_80=1&rid=" & [Record ID#];

"javascript:" &
"$.get('" &
$url &
"',function(){" &
"$.jGrowl('This Item has been put on PO CANCEL snooze', {life: 5000, theme: 'jGrowl-green'});" &
"});" &
"void(0);"

The 5000 means it will display the pop up for 5 seconds before it fades away on its own.

I have never tried this on a dashboard in part because the button needs to know which record to act on.
- CarlosCarlos
  Qrew Assistant Captain
  8 years ago
  Just what I needed!! FYI, it works like a charm in reports as well!!
  
  BIG THANKS!
- CarlosCarlos
  Qrew Assistant Captain
  8 years ago
  Is there a way to implement this from a Formula-Text button, instead of a Formula-URL ??
  
  Thanks
- QuickBaseCoachD
  Qrew Captain
  8 years ago
  It took me a while to get this working as there were some recent posts from Laura Hillier and Matthew Neil which i needed to cobble together. But now i have it for myself too. There is some crazy syntax for sure.
  
  This worked
  
  var text Update= URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_188=" & ToText(Now());
  
  var text URL =
  "javascript:" &
  "$.get('" &
  $Update &
  "',function(){" &
  "$.jGrowl('This Item has been put on PO CANCEL snooze', {life: 5000, theme: 'jGrowl-green'});" &
  "});" &
  "void(0);";
  
  "<a class='Vibrant Danger' href=\"" & $URL &"\"" & ">Button name goes here" & "</a>"
  
  The choices for the button color are:
  "<a class='Vibrant'>Vibrant</a>", // regular grey button :(
      "<a class='Vibrant Alert'>Vibrant Alert</a>", // yellowish
      "<a class='Vibrant Danger'>Vibrant Danger</a>", // red
      "<a class='Vibrant Primary'>Vibrant Primary</a>", // blue
      "<a class='Vibrant Snowy'>Vibrant Snowy</a>", // white
      "<a class='Vibrant Success'>Vibrant Success</a>" // green
  )

ChrisChris

Qrew Assistant Captain

8 years ago

Carlos,

Did you do anything differently to the code to make the buttons work in your reports? I applied the apptoken parameter to the query string and the buttons work with apptokens enabled, but in a report the buttons do not work.

Chris

CarlosCarlos

Qrew Assistant Captain

8 years ago

Chris, no nothing different.

Here's the code to one of the buttons I did:

var text action = URLRoot() & "db/" & Dbid() & "?a=API_editRecord&key="& [Item] & "&_fid_699=1" & "&_fid_700=" & URLEncode(User()) & apptoken=abcdefg1234567;
var text url = "javascript:" & "$.get('" & $action & "',function(){" & "$.jGrowl('Growl notification text goes here', {life: 5000, theme: 'jGrowl-green'});" &"});" &"void(0);";
var text button  = "<a class='Vibrant Alert' href=\"" & $url &"\"" & "> Do action and Growl " &  "</a>";

$button

QuickBaseCoachD
Qrew Captain
8 years ago
The buttons should work identically on a report or form.
- CarlosCarlos
  Qrew Assistant Captain
  8 years ago
  Are you aware of any changes to this? after this weekend's update this no longer seems to be working from reports or records
- QuickBaseCoachD
  Qrew Captain
  8 years ago
  It's working for me.
  
  This is working, for example.
  
  var text Update= URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_188=" & ToText(Now());
  
  var text URL =
  "javascript:" &
  "$.get('" &
  $Update &
  "',function(){" &
  "$.jGrowl('This Item has been put on PO CANCEL snooze', {life: 5000, theme: 'jGrowl-green'});" &
  "});" &
  "void(0);";
  
  "<a class='Vibrant Danger' href=\"" & $URL &"\"" & ">Button name goes here" & "</a>
StephenStephen
Qrew Assistant Captain
8 years ago
I modified and used in my report but pressing the button shows no reaction.
my fid is 10 and it's a checkbox. I simply want to be able to press the button in a report to mark the checkbox checked because I don't want to have to use "grid edit" which would render another button I have (to open at the URL of the record in a new window) useless.
var text Update= URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_10=1";
var text URL = "javascript:" &"$.get('" & $Update & "',function(){" &"$.jGrowl(�Item Marked Completed�, {life: 5000, theme: 'jGrowl-green'});" &"});" &
"void(0);";
"<a class='Vibrant Danger' href=\"" & $URL &"\"" & ">Mark Completed" & "</a>"
QuickBaseCoachD
Qrew Captain
8 years ago
To test this, I suggest that you make a temporary formula URL field with just this.

URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_10=1"

My guess is that when you click that it will fail on something, likely a complaint about the application token is missing.

I suggest that you then go to the settings for the App and then Advanced settings and either disable the need for Application Tokens or else create one and include the extra line

URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_10=1"
& "&apptoken=xxxxxxxxxxxx
StephenStephen
Qrew Assistant Captain
8 years ago
Thanks Coach. The Formula URL button did show it needed an app token, and now the test button works fine (although it shows the XML result and doesn't finish the button, refresh and return to the same report screen).
So while that line was fixed, the next two don't work either. When I click the button nothing happens, so there clearly are issues with the next two lines of code.

Perhaps I need to load the jGrowl first? I don't see that in this thread but I've toyed with other people's code (like the tabbed forms) and used an "onload" field to load the javascript..I"m a newbie and can't really code in javascript, I can just tweak simple stuff from other people sometimes.
QuickBaseCoachD
Qrew Captain
8 years ago
I know that this will work, but the button will be grey. I'm not sure that I have working code to easily post to get the jgrowl to work as a Vibrant colored button.

var text URL = URLRoot() & "db/" & "?act=API_EditRecord&_fid_80=1&rid=" & [Record ID#];

"javascript:" &
"$.get('" &
$url &
"',function(){" &
"$.jGrowl('This Item has been put on PO CANCEL snooze', {life: 5000, theme: 'jGrowl-green'});" &
"});" &
"void(0);
QuickBaseCoachD
Qrew Captain
8 years ago
Can you post your current code that is not working?
StephenStephen
Qrew Assistant Captain
8 years ago
This is what I had before your last post in a formula-text button

var text Update=URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_10=1"& "&apptoken=xxxxxxxxx";

var text URL = "javascript:" &"$.get('" & $Update & "',function(){" &"$.jGrowl(�Item Marked Completed�, {life: 5000, theme: 'jGrowl-green'});" &"});" &"void(0);";

"<a class='Vibrant Danger' href=\"" & $URL &"\"" & ">Mark Completed" & "</a>"
StephenStephen
Qrew Assistant Captain
8 years ago
Do I have to onload anything? Does the jGrowl just work?

Forum Discussion

Formula URL or Formula Text Button that will perform an action, without the need to navigate away from the current dashboard/report/record?

37 Replies

Related Content

Introducing New Quickbase Navigation (beta)

Conditional formula url

Year Formula help

Formula URL - Edit then Add

Create a formula duration over 5 years

Recent Discussions

Average last 30 days

Help Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting

(Pipelines) Get Users in Role / Process XML from HTTP API

Save & Redirect in a Formula URL Using API_GenAddRecordForm

Formula Builder Cursor Position Incorrect