Using form pesonalization would like to display a different value in a column than what is fetched
Using form personalization would like to display a different value on the Form in a column than what is fetched from database. In our case credit card number in encrypted and stored in a column and in super user responsibility we would like to show decrypted values, without actually updating the column value in session.
We tried to implementing this by using select query and decrypting the value. This is updating the column value and while closing the Form it prompts to save data.
If by some mechanism we can discard changes done before closing the form, thus by avoiding accidental updates that is also fine with us.