Currently, I have an app that stores user balances as a numeric field in the Users table. I don’t want developers to be able to modify the database field and change user balances to whatever they want.
So, I’m thinking of creating a third-party API that encrypts user balances with their ID and returns the encrypted message to store in the database. This way, anyone with access to the database can see it, but they won’t know how to decrypt and change it because the encrypt key is on third party server.
However, the problem is that anyone with access to the editor can also see the API endpoint and call it themselves. They could do this either inside the app (by creating a hidden site or workflow) or outside the app (using Postman) to send their ID and desired balance, and then set the returned encrypted message to the database field.
How can I solve this? Or, is there any feature in Bubble that hides the balance field like the password field?