I am looking for is a simple 'jumble/encryption' so prying eyes cant read a field.
I tried using the built in Encryption which encrypted the text string, but Decryption failed with a long error and complaining that it couldn't because of double padding or something like that.
Basically looking for a mask of sort.
want to take "Purchase Order 123ABC" and mask it to "u7r4yt64y9y". *example*
BUT... then when I have "u7r4yt64y9y" in the field and want to read it back, i want it to 'unmask' and be "Purchase Order 123ABC" again.
Anyone have a function that can do that...???
0
Answers
Why do you have to encrypt the data, why you just simply work with permissions in here. If the user should not see the value in the field hide the value for him. If you check your new field in User Setup table for that user so he can see the value, the value will be shown.
For additional information you can read this post:
https://forum.mibuso.com/discussion/comment/314243#Comment_314243
Solution provided by @carbon
Regards
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
A simple function doing ROT-13 may look like this:
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03