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.
  • SumedhaWeerasur's avatar
    SumedhaWeerasur
    Qrew Cadet
    7 years ago
    Hey Mark, This neat! But for some reason i have having some trouble getting it to work. 

    I created a url button and pasted in your code. The Javascript executes and i see the green message. But the checkbox field i have in fid_24 is not getting toggled. 

    My modified code is below 

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

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


    can you spot anything weird with it? 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 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

     
  • SumedhaWeerasur's avatar
    SumedhaWeerasur
    Qrew Cadet
    7 years ago
    Hmm, this is still not working for me tho. I tried it with an with and without an apptoken. 

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

    "javascript:" & 
    "$.get('" &  
    $url &  
    "',function(){" & 
    "$.jGrowl('This Item has been put on PO CANCEL snooze', {life: 5000, theme: \n'jGrowl-green'});" & 
    "});" & 
    " oid(0);
  • SumedhaWeerasur's avatar
    SumedhaWeerasur
    Qrew Cadet
    7 years ago
    Is there a specific workflow that one needs to go through to get this to work? Like the record needs to be open? And the checkbox needs to be un checked may be? 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    what does it do when you debug it by simply running the URL and removing the javascript code temporarily? as per my suggestion above.
  • SumedhaWeerasur's avatar
    SumedhaWeerasur
    Qrew Cadet
    7 years ago
     I just tried it. I am getting this error. Also dose this formula only change the once? so the button wouldnt work after one click? 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    In my post above I said to include the line $URL after your formula variable line to run the formula.  That will expose the error.

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

    $URL
  • SumedhaWeerasur's avatar
    SumedhaWeerasur
    Qrew Cadet
    7 years ago


    Oh im sorry. Yes you did. Here is the error i am getting. [ Thank you so much for your help with this! ] 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    I cannot read that. Its too small to read. Please copy and paste the actual text.
  • SumedhaWeerasur's avatar
    SumedhaWeerasur
    Qrew Cadet
    7 years ago
    Here you go

    <qdbapi>
    <action>API_EditRecord</action>
    <errcode>32</errcode>
    <errtext>No such database</errtext>
    <errdetail>
    The application does not exist or was deleted. If you followed a link to get here, you may want to inform the author of that link that the application no longer exists.
    </errdetail>


    <dbid>-b</dbid>

    </qdbapi>