0

Update Customers DB

Is there a way to update the customer db without opening the db? it“s a question of privacy.

I need to add another Text Field in Patient Table.

Thnak you.

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Mconneen
    • Mconneen
    • 1 yr ago
    • Reported - view

    @Vincenzo...   It all depends on how your source application connects to the database.   If it is all one “application database”, then I am NOT aware of a way to do this.   If you are using Ninox Cloud .. you “could” architect it such that your source application uses an integration framework (or native REST API) to connect to a back end database.

     

    That said.. Ninox is “GDPR” compliant .. but from my understanding not HIPAA compliant.

    Like
  • Thanks for the reply.
    She is a psychotherapist, and she wants to be sure that I don“t read patient data if I have to change her db. But if I open her database, inevitably I read some data.  
    One way would be to have the blank copy of the db with the new field, and copy the content from one db to the new one.

    Like
    • Mconneen
    • Mconneen
    • 1 yr ago
    • Reported - view

    @Vincenzo

    Yes... providing a blank copy would work.. Assuming the client does not mind doing an export / import ...  and could get tricky if there are attachments.

    Being the “admin” .. You have the keys to the kingdom.. as Admin“s should.

     

    Another thought... Screen share with her.... you take over and she watches you open the database .. and go into admin mode .. data model .. and make the change.. then exit.   You can most likely provide her the steps.. unless you have the database protected because of any IP..

     

    If you have logic in the current trigger after open...  I often add a function called .. ”isMe()“ ... and then test within trigger after open.. if it isMe() .. then I either open a specfiic form.. or more often than not.. do nothing.. else ... do whater the client wants during the open..

    Like
  • Thnak you Mconnenn :)

    Like
Like Follow
  • 1 yr agoLast active
  • 4Replies
  • 540Views