Skip to main content
Question

Get around delete permissions with API call?

  • December 12, 2019
  • 0 replies
  • 54 views
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
------------------------------
Thanks, Alex

MarkShnierYou
Forum|alt.badge.img+24
Great Question as you are close.

So just setup an Automation.  Automations run under the permissions of whoever last created or edited the Automation.  

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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
    QuickBaseJunkie
    Forum|alt.badge.img+15
    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. 



    ------------------------------
    Sharon Faust (QuickBaseJunkie.com)
    Founder, Quick Base Junkie
    https://quickbasejunkie.com
    ------------------------------
      Terms & ConditionsAccessibility statement