Forum Discussion

RobinCC's avatar
RobinCC
Qrew Cadet
10 years ago

What is the URL to edit a field, redirect to app homepage, and then display a pop-up message all with one button?

I already have the URL to edit the field and redirect to the app home page. That was easy and it works perfectly. I just need the extra part to also display a pop-up message. The URL thus far i...
APIs and custom code
Formulas and functions
roles and permissions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
10 years ago
Here is my current best version. This one is setting a checkbox to be checked.

var text URL = URLRoot() & "db/" & "?act=API_EditRecord&_fid_80=1&rid=" &
[Record ID#];
 
"ja ascript:" &
"$.get('" &  
$url &  
"',function(){" &
"$.jGrowl('This Item has been put on PO CANCEL snooze', {life: 5000, theme:
'jGrowl-green'});" &
"});" &
" oid(0);"

The 5000 means 5 seconds until it fades away. I like this version as it the same green color as the native QuickBase pop ups.

Note that when you do these kind of pop ups, the pop-up will show a success message even if the URL formula completely fails. So it's up to you to be sure that there is no possible way that the URL formula will fail.
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
It probably needs an apptoken or else you need to disable app tokens in the Advanced properties for the app.


The way to test that is to comment out or remove the whole javascript block and replace it with just 

$URL

That will run the edit and expose the XML error or success message.

If you need an app token the formula would look like

var text URL=URLRoot() & "db/" & "?act=API_EditRecord&_fid_24=1&rid=" & [Entry Number]
& "&apptoken=xxxxxxxxx";

The Advanced Properties of the app is where you manage app tokens.  App Tokens are an extra layer of security.   I usually turn them off unless my client has some super sensitive data, such as HIPPA health records