Is there a way to add a button to a record that will cause a change to be made to the record when clicked?

I did a Blog Article which is about to be published and an App in the Exchange called URL formulas for Dummies. it has come examples, and my Blog article.


https://qdfc.quickbase.com/db/main?a=AppDetail&ID=1803&app_name=URL%20Formula%20Buttons%20for%20Dumm...

Post back if you have questions! Or even if you don't, let me know what you think of the article.

Ok, so this is pretty awesome! I just applied the 2nd example to what I was going for and it works swimmingly! The one question I do have is that instead of having it show the record after the function is complete, you had mentioned you could have it show a report instead? What part of the URL address for the report is the part I would need to substitute in for the [Record ID#]?

If you are using a conventrion of URLTWO for what it does next after the edit, then it would just be like
URLRoot() & "db/" & dbid() & "?a=q&qid=xx"

ie in English this says , go to my app and go to the table I am already in (that's the dbid() part) and the Action is to run a Query "a=q"  (QuickBase used to call reports "queries" and the Query ID number id xx  (&qid=xx).  So just run the report that you want to refresh and observe the Query ID number in the URL at the top of the browser.

e.g. URLRoot() & "db/" & dbid() & "?a=q&qid=22"

oh ok, yup that worked! This is really cool. I still don't have a perfect handle on it but I will continue to study your article. The only downfall for this particular application is that am using a report that utilizes the _ask1_ so a user can bring up several records at once. The issue there however is that if the user the clicks the button on the first one, it then takes them back to report with all the blank entry boxes versus the list of records that was previously pulled. But this in general will definitely come in handy down the road as I develop our system further. Thanks for the help!

There is an alternative, since you passed URL for Dummies with flying colors and are ready for Advanced URL formulas for Dummies.

Try this one

Do your URLONE formula except if you are just doing one thing, like editing one record, then let's just call it URL as the formula variable.

so you have var text URL = ........:

So it would look like this:

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);"

This will put up a fade away pop up and not refresh the report.  The fade will last for 5,000 miliseconds (5 seconds), and the box will have the words in those single quotes

Man, you are a friggin genius! That did the trick, thanks so much!!

Adding button to an app can really improve the ease of use for the users for those simple operations like flagging records as completed to updating a field with "Today()"  :)

The application below contains one table with fields for [Name], [Phone], [Email] and [RSVP]. If you click the button the [RSVP] will change to NO and the report will reload:

Update Clicked Record From Report
https://haversineconsulting.quickbase.com/db/bjdv4942n?a=q&qid=2

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=347

Note that if the fields you want to change would result in (1) the report displaying stale information, or (2) the record would no longer meet the report criteria you have to reload the page to keep the displayed report consistent with internal state of the table.

The formula for the image onload field [-] has the normal definition and is concatenated with the HTML for the button:

[iol] & "module.js" & [/iol] &
"<a class='Success Vibrant QBU_ChangeRSVP'>" & "Change RSVP" & "</a>"

You don't need to put any onclick handler on the button as you can detect the button was clicked in module.js. The class QBU_ChangeRSVP has no CSS definition associated with it and is only used to easily select the custom buttons that are inserted into the report.

So I was trying to incorporate this last formula to be used to mark a task as complete. And everything saved correctly for the field but when I click the button, it is not changing the checkbox field to checked. I do get the fade away popup though. Not sure what is wrong with the formula. Here is what I have.

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

"javascript:" &
"$.get('" &
$url &
"',function(){" &
"$.jGrowl('This box has been retired', {life: 5000, theme: 'jGrowl-green'});" &
"});" &
"void(0);"

I know I have the right field ID in there. Am I missing something?

The fade away poop up will always happen, regardless of if the actually update blows up like a nuclear bomb in the background.  Dan Dielbolt would admonish us that that is a deficiency of this URL for Dummies approach.

You URL is not telling QB which table to update!

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