1

Prohibit Deletion

I Heve  a task that will prohibit deleting tables and records, APP mac. Found how to hide the delete icon in the bar
html("
<style>" +
if not HUD then
    ".i-setting-print{display:none;}"
end +
"
    .i-setting-trash{display:none;}
    .i-setting-copy{display:none;}
    .i-setting-add{display:none;}
</style>
")

But this is not a solution to the problem, because you can delete a record already in the table itself, we exit the record and delete. Does anyone have a solution to what problem? to restric any deletion?

Thanks

10 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    When you edit a table you can set Delete Records to whomever you want.

      • demo3678
      • 1 yr ago
      • Reported - view

       Hi, thank you for responding to my situation

      I don’t see such a function in the table settings, as I know it is in the cloud version

      Can you write in more detail what formula and where to insert it?

    • Mel_Charles
    • 1 yr ago
    • Reported - view

    You can do this at the foot of table setting page in edit mode

    Create New record or Delete Record at the table level by user status

      • demo3678
      • 1 yr ago
      • Reported - view

       Hi, thanks for taking part

      But you are talking about the cloud version, but I need the desktop version. This situation arises due to the fact that the desktop version does not have users, so there is no way to limit the capabilities

      • Fred
      • 1 yr ago
      • Reported - view

      It makes sense that you wouldn't need to worry about deleting records if you are the only user of the DB. If you are trying to protect the DB from yourself, which I do myself. Then you can use dashboards to control your input of data and deleting of records.

      • demo3678
      • 1 yr ago
      • Reported - view

       Several people have access to the database. Therefore we need protection

      • Fred
      • 1 yr ago
      • Reported - view

      So you have multiple computers with the same iCloud account accessing the DB? This is not really a multi-user situation. If multiple people are sharing the same computer, then there is no way to tell one user from another. There is no way to keep anyone from clicking on the wrench and becoming admin.

      You should consider buying two starter accounts so you can have one and give one to the user and then you can start doing permissions properly.

      • demo3678
      • 1 yr ago
      • Reported - view

       Thanks for your advice, this is probably the solution. But I'm thinking of securing the tables and creating a password for them. And to view information you can simply use the VIEW

      I'll try to solve the problem this way

      • Mel_Charles
      • 1 yr ago
      • Reported - view

       What happens when two users log in at the same time with presumably the same logon credentials and try to edit the same record? Might this potentially cause a conflict and effect the record integrity?

      • demo3678
      • 1 yr ago
      • Reported - view

       I think that such a coincidence is not entirely realistic, that they coincided in time accuracy down to the second to second. But we are not planning a cloud storage, just app version 

Login to reply

Content aside

  • Status Answered
  • 1 Likes
  • 1 yr agoLast active
  • 10Replies
  • 147Views
  • 4 Following