0

I'm creating an accounting database.

Is there a way to lock records from editing???

13 replies

null
    • Support
    • 5 yrs ago
    • Reported - view

    Please enter in the field options "Writable if"

     

    'this field' = null

    then you can only insert a value and after that the field is locked.

    Best, Jörg

    • tgsbricks01
    • 5 yrs ago
    • Reported - view

    I don't get it, when doing that I can't enter anything in the field at all.

    Is there a way to make a whole record locked??? Eks. if you have 10 fields in a record, can I then have a buttom to change the whole record from editing??? And reverse of course.

    • Mconneen
    • 5 yrs ago
    • Reported - view

    Sure.. add a field.. 'Record Locked' ... default to False .. then create a button that is viewable only to you..that tolggles that value.  For each field .. in the Writable If ....   add

    'Record Locked' = false 

    or something like that.. 

    • tgsbricks01
    • 5 yrs ago
    • Reported - view

    Got it on Text fields, thanks. But it doesn't work on number fields, right??

    The next question is can I prevent a record from being deleted??

    • tgsbricks01
    • 5 yrs ago
    • Reported - view

    I Got it on number fields too.

    Now the only problem is to make records undeleteable.

    • Alexander_Koenig
    • 5 yrs ago
    • Reported - view

    Hi, in the table options you can define which user role has the permission to delete records.

    Be also invited to our special interest "accounting":

    https://zoom.us/webinar/register/WN_ETLUOTkqR3OVdve_Qe1Qug

    Best regards, Alex

    • Mconneen
    • 5 yrs ago
    • Reported - view

    Assuming you are using the Ninox Cloud version.. TableOptions

    • tgsbricks01
    • 5 yrs ago
    • Reported - view

    No, I don't, I'm the only one using the database. But maybe I have to use the cloud version, and have 2 usenames, so I can prevent my self from deleting a record.

    Can I transfer database from the free version to the cloud version without any problems?

    • Mconneen
    • 5 yrs ago
    • Reported - view

    Yes.. you can save your local database as an archive .. then restore that archive to the Ninox Cloud version .. and reorganize it so it is now owned by the cloud platform. 

    • Ninox partner
    • RoSoft_Steven.1
    • 5 yrs ago
    • Reported - view

    I've made an example database with passwordprotection.

    Please feel free to have a look at this :

    https://www.dropbox.com/s/9ne4b4csmw72z9j/ProtectWithPassword.ninox?dl=0

    • tgsbricks01
    • 5 yrs ago
    • Reported - view

    I don't fully understand that. But it doesn't seem to protect the records from accidentally beeing deleted.

    • Ninox partner
    • RoSoft_Steven.1
    • 5 yrs ago
    • Reported - view

    Ah, no it doesn’t. I thought it was to build a solution so no other persons could edit your database.

    Maybe in future updates? Or in the cloud version it is possible.

    • tgsbricks01
    • 5 yrs ago
    • Reported - view

    Thank you for trying to help me.

    It is possible in the Cloud version, but I don't need that version, as I'm the only one using the database.

Login to reply

Content aside

  • 5 yrs agoLast active
  • 13Replies
  • 3714Views