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.

4 replies

null
    • Mconneen
    • 3 yrs 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.

    • Vincenzo_Martusciello
    • 3 yrs ago
    • Reported - view

    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.

    • Mconneen
    • 3 yrs 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..

    • Vincenzo_Martusciello
    • 3 yrs ago
    • Reported - view

    Thnak you Mconnenn :)

Content aside

  • 3 yrs agoLast active
  • 4Replies
  • 564Views