I was wondering if there was a way to add a button to a record that when clicked would change a field in that record without having to go into edit mode?For instance, I what to be able to change the status of a record from "On Hand" to "Retired" but just clicking on a button that is available from the report view. The reason this would be helpful is that if I am looking at a list of records that need to be retired, I now I could click grid edit and just change the status dropdown and then fill down, but I am trying to make the process as streamlined and simple for machine operators on the floor to do the updates.

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 likeURLRoot() & "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 oneDo 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

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

24 Replies

_anomDiebolt_
Qrew Elite
11 years ago
You are probably missing the application token. Be that as it may be, the only JavaScript you should put into a QuickBase formula is a $.getScript() call and place all of your functional JavaScript in a user defined page. module.js. You are just asking for trouble writing JavaScript in a formula as there will constantly be character escaping issues Moreover, even if you only want your JavaScript to run on a button click you should use the image onload technique and put an event handler in the user defined page module.js rather than jam a callback or or an inline onload handler in your formula.
QuickBaseCoachD
Qrew Captain
11 years ago
sorry Chris,

just updated my formula above
var text URL = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&_fid_9=1&rid=" & [Record ID#];
_anomDiebolt_
Qrew Elite
11 years ago
QBC>Dan Dielbolt would admonish us that that is a deficiency of this URL for Dummies approach.

Read the book:

http://i.imgur.com/NZP7Si2.jpg

https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294
Chris_MCDChris_
Qrew Member
11 years ago
I am now getting this error,

Formula syntax error

A variable declaration must end with a semi-colon.

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

"javascript:" &
"$.get('" &
$url &
"',function(){" &
"$.jGrowl('This Task has been completed', {life: 5000, theme: 'jGrowl-green'});" &
"});" &
"void(0);"
QuickBaseCoachD
Qrew Captain
11 years ago
var text URL = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&_fid_9=1&rid=" & [Record ID#];
Chris_MCDChris_
Qrew Member
11 years ago
Ok, I think I got it now. But let me ask you this... in testing this out, I have clicked the button, and then went into the record to make sure it worked, and the first time it did. But then once I have changed it back and then tried it again, it no longer worked. Why is that? I still worked on a different record when I tried it on that one.
QuickBaseCoachD
Qrew Captain
11 years ago
It should work consistently every time. No way it would not work for a simply update like that. Please test again.
Chris_MCDChris_
Qrew Member
11 years ago
I have actually tried it 3 times now, twice with my companies system an another with the other company I work with. It seems as though once you change a record using the button, then update that record back to its original state, when you go through the process again, the button no longer works on that record. Something must change about it. I don't see this really being an issue as once the button is used on a record, there really is no reason to change it back in most cases. I was just simply testing it out.
QuickBaseCoachD
Qrew Captain
11 years ago
maybe make this minor chnage
var text URL = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&_fid_9=1&rid=" & totext([Record ID#]);
_anomDiebolt_
Qrew Elite
11 years ago
Try Plan B: script using the image onload technique. It always works the first time!

Forum Discussion

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

24 Replies

Related Content

Previous and Next Record Buttons

Button to Add Record via Pipeline, and refresh Record

Add button to create record in different app

Button: save the new record and edit the new record

New Form - Show Create Record button