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
No there is no onload required.

I see the problem. :)

�Item Marked Completed�,

Those quotes in your formula are curly 66 99 type quotes that get generated typically by Word.

The need to be the ' kind of single quote. ie not � � and but a ' and '.
StephenStephen
Qrew Assistant Captain
8 years ago
ARGH! That keeps happening to me and I figured out that was happening but thought I fixed them all. Thanks for catching it. In my case it's a mac "Notes" app where I keep all my code. I'll have to stop using it once-and-for-all. Gracias!
QuickBaseCoachD
Qrew Captain
8 years ago
:) That Syntax to get a jgrowl Vibrant button is particularly difficult.

I keep my cheat notes for code snippets in QuickBase back where it is easily searchable and always handy when I'm on line developing.
StephenStephen
Qrew Assistant Captain
8 years ago
It works great....I would just want to get it to refresh the page if possible? Although that would probably make the jGrowl not very useful....
- CarlosCarlos
  Qrew Assistant Captain
  8 years ago
  Indeed... Though a "background" refresh would be great, as linked buttons won't reflect changes performed through these jgrowl actions so you always need to refresh before clicking elsewhere
QuickBaseCoachD
Qrew Captain
8 years ago
:) One per customer. You get to choose a page refresh or the pop up, not both.
StephenStephen
Qrew Assistant Captain
8 years ago
How would I switch to a refresh then?
QuickBaseCoachD
Qrew Captain
8 years ago
Change the middle part to this

var text URL =
"javascript:" &
"$.get('" &
$Update &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);";
StephenStephen
Qrew Assistant Captain
8 years ago
amazing. Thanks.
CarlosCarlos
Qrew Assistant Captain
8 years ago
Anyone know if there are any more "jGrowl-COLORS" available?
I seem to get a yellowish one with no formatting if using any other color name other than jGrowl-green?
- HectorAubert
  Qrew Trainee
  6 years ago
  Were you able to figure out a way to get different colors?

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

Getting Familiar with Quickbase Navigation

New Nav, New Gains: Get Moving with Sidebar Navigation

The new "sidebar" navigation sucks.

Introducing New Quickbase Navigation (beta)

Side Bar Navigation SUCKS.