Deleting grid-editable embedded records.

Question

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------------------------------

markshnier__you · Answer

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 · Answer

So I've been trying to use Authentication Tokens with my code.
var text URL= URLRoot() &amp; "db/" &amp; [_DBID_STATUS_LOG] &amp; "?act=API_DeleteRecord&amp;rid=" &amp; [Latest Child Record]
&amp; "&amp;apptoken= de8maaedeufhmicsjctspcgqy4ea";

$url​
However, even when I assign the token to the application, I get the following error message

&lt;qdbapi&gt;
&lt;action&gt;API_DeleteRecord&lt;/action&gt;
&lt;errcode&gt;24&lt;/errcode&gt;
&lt;errtext&gt;Invalid Application Token&lt;/errtext&gt;
&lt;errdetail&gt;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&lt;/errdetail&gt;;
&lt;/qdbapi&gt;
Does it take time for QuickBase to recognize an assigned token?&nbsp;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 · Answer

Remove the space. :)(been there done it).
&amp; "&amp;apptoken= de8maaedeufhmicsjctspcgqy4ea";​
Sorry , Copy Paste not working in my iPad over morning coffee.apptoken=de8 .....------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

markshnier__you · Answer

Here is the full code you need, as after you do the delete, you need to refresh the parent.
var text URL= URLRoot() &amp; "db/" &amp; [_DBID_STATUS_LOG] &amp; "?act=API_DeleteRecord&amp;rid=" &amp; [Latest Child Record]
&amp; "&amp;apptoken= de8maaedeufhmicsjctspcgqy4ea";​
(without the space in the app token, followed byvar text ReDisplay = URLRoot() &amp; "db/" &amp; [_DBID_of the parent table] &amp; "?a=dr&amp;rid=" &amp; [Related Parent];$URL&amp; "&amp;rdr=" &amp; URLEncode($Redisplay)------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

jamesdalton · Answer

Thank you!------------------------------James Dalton------------------------------

Forum Discussion

Deleting grid-editable embedded records.

Related Content

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

Embedded Grid Edit Report Pre-filtered Conditional Dropdown

embedded reports

Embedded Grid Edit Report help