Forum Discussion

JamesDalton's avatar
JamesDalton
Qrew Trainee
5 years ago

Deleting grid-editable embedded records.

Hello all, Is there a way to delete to a record from a grid-editable embedded report in a parent record and also have the page automatically refresh? ------------------------------ James Dalton...
APIs and custom code
Buttons
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
It would be possible to make a formula URL button to delete and redisplay the page.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • JamesDalton's avatar
    JamesDalton
    Qrew Trainee
    5 years ago
    So I've been trying to use Authentication Tokens with my code.
    var text URL= URLRoot() & "db/" & [_DBID_STATUS_LOG] & "?act=API_DeleteRecord&rid=" & [Latest Child Record]
& "&apptoken= de8maaedeufhmicsjctspcgqy4ea";


$url​

    However, even when I assign the token to the application, I get the following error message 
    <qdbapi>
<action>API_DeleteRecord</action>
<errcode>24</errcode>
<errtext>Invalid Application Token</errtext>
<errdetail>The Application Token de8maaedeufhmicsjctspcgqy4ea has not been assigned to this Application. To read about assigning an Application Token to your application go to https://help.quickbase.com/user-assistance/app_tokens.html</errdetail>;
</qdbapi>


    Does it take time for QuickBase to recognize an assigned token? 

    I would prefer to make tokens required if that means more security for my app.

    Thanks in advance for any insight.



    ------------------------------
    James Dalton
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      Remove the space. :)
      (been there done it).


      & "&apptoken= de8maaedeufhmicsjctspcgqy4ea";​

      Sorry , Copy Paste not working in my iPad over morning coffee.

      apptoken=de8 .....



      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        Here is the full code you need, as after you do the delete, you need to refresh the parent.

        var text URL= URLRoot() & "db/" & [_DBID_STATUS_LOG] & "?act=API_DeleteRecord&rid=" & [Latest Child Record]
& "&apptoken= de8maaedeufhmicsjctspcgqy4ea";​
        (without the space in the app token, followed by

        var text ReDisplay = URLRoot() & "db/" & [_DBID_of the parent table] & "?a=dr&rid=" & [Related Parent];

        $URL
        & "&rdr=" & URLEncode($Redisplay)




        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------