Get around delete permissions with API call?

Question

I want my users to be able to delete records from a certain table, but only in certain situations. Since they only ever view the records from a specific table, and there's no way to set up custom delete permissions, I thought that a way to do this might be to have a Formula - URL button that calls API_DeleteRecord, and use formula logic to have it only send the API call when certain conditions were true.

Is there a way to allow users to click this button to delete the record even if they don't have delete permissions for the table? I've been looking at usertokens and tickets because those seem like they might help, but I don't know too much about that.

------------------------------
Thanks,
Alex
------------------------------

markshnier__you · Answer

Great Question as you are close.So just setup an Automation.&nbsp; Automations run under the permissions of whoever last created or edited the Automation.&nbsp;&nbsp;Then depending on how fancy you want to get, you can just have a form rule to expose a checkbox field to delete the record or make a URL formula button to check a checkbox (where the URL formula will be null if the conditions are not met). Then the user triggers a "request deletion" type update and the Automation will do the delete.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

quickbasejunkie · Answer

Hi Alex!I like Mark's suggestion, but here is another possible way of approaching it. Especially if there is the possibility of an erroneous deletion.&nbsp;
------------------------------Sharon Faust (QuickBaseJunkie.com)Founder, Quick Base Junkiehttps://quickbasejunkie.com------------------------------

alexgale · Answer

Hi Sharon,&nbsp;I think that's a good idea, but I'm not actually worried about extraneous deletions in this specific case, because the table in question is just a join table. If something gets deleted, no information will be actually lost. Still, thanks for the suggestion!&nbsp;Alex------------------------------Thanks,Alex------------------------------

alexgale · Answer

Thanks Mark, that makes sense. In my case I'll use a checkbox to trigger the automation I think.------------------------------Thanks,Alex------------------------------

Forum Discussion

Get around delete permissions with API call?

Related Content

Delete Formula Button Error

Deleting Orphaned Children (records)

App-to-App Permissions/Relationships

Specific permissions needed to run a copy master and detail button?

Deleting Attachments