Hello  @Dabuskol ,

Please kindly review the url's below and hopefully help get what you are requesting for:-

Encrypting data in the K2 Database:

https://community.k2.com/t5/K2-blackpearl-Articles/Encrypting-data-in-the-K2-Database/ta-p/88003

Always Encrypted Feature on SQL: 

https://help.k2.com/support-services/kbt145231

PowerShell Commands to Encrypt and Decrypt Data: 

https://help.k2.com/kb002368

All the best.

Thanks for reply. I already read the links that is not what I need.

I guess, if there are no other solution I might go to custom broker.

Really appreciate.

Good day Dabuskol

Please see the following too.

“Password control”: https://community.k2.com/t5/K2-blackpearl-Articles/Password-control/ta-p/76613,

“Has anyone gotten SmartForm field masking to work?”: https://community.k2.com/t5/General/Has-anyone-gotten-SmartForm-field-masking-to-work/m-p/96957.

Best,

Sunrise

Hi Dabuskol,

I'm not sure if this is something possible out-of-the box. There is a similar feature for expression in K2.
I would highly suggest visiting the ideas.k2.com site and upvote the feature: https://ideas.k2.com/ideas/APIT-I-196. Perhaps, an option is to let SQL do the data encryption via stored procedures.

https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/sql-server-encryption?redirectedfrom=MSDN&view=sql-server-ver15