Encripting specific data going out of appsheet

[Jasper2]

Hi, 

I'd love to know if anyone has suggestion on how to encrypt data that appsheet is capturing and sending to outside databases like smartsheet so that only appsheet knows what the real values of those columns are. For instance, if someone’s enters their personal ID number, that data is captured using a form, then only that column is encrypted in a way that only appsheet can unencrypt it, so that when it is stored on the smartsheet database, people with access to the database sheet cant see the real ID Number, but on appsheet, you can.  If there is no built-in system for this, what i was thinking was to store the ID in the form on appsheet and have a column with a formula fetches the entered ID and very basically encrypts it with some maths, then deleting the number in the original column. And when appsheet wants to view the ID, it just runs that maths in revers to un-encrypt it to show it in a new virtual column.

[Steve]

Not possible.

[themacboy]

In my login application I used a bot to trigger an App Script that received the new data, encrypted it with Sha256 + a Salt and returned the new value.

This value is what I store in my AppSheet database or another.

It takes a few seconds, but it greatly reduces the exposure of sensitive data, such as passwords