There is the ENCRYPT function. I have never used it but it seems like it
could be used in work flow to encrypt the value before it is committed to
the db. Then you could have workflow that would allow certain people to use
the DECRYPT function based on permissions. You could even log using the
decrypt workflow to do a push fields to another form to log who decrypted
and when. I would imagine these could be used in combination with the mask
to still show ******* but would also scramble the data in the db.
ENCRYPT (pg 206 of Workflow Objecfts Guide):
Used in Set Fields filter actions only. Returns the encrypted value of a
text string (plaintext), using the encryption key (key). The return value is
larger than th size of the unencrypted string. For example, to encrypt the
string in Field1 using th key my_key, enter: ENCRYPT($Field1$, "my_key") To
encrypt a string using a key in KeyField, enter: ENCRYPT("wordToEncrypt",
$KeyField$)
Jason
On Fri, Jul 30, 2010 at 1:05 PM, LJ LongWing <[email protected]> wrote:
> Guillermo,
> There is an option of a character field to display it as type 'mask'...but
> be warned...it's nothing more than a visual mask...the data is still
> transferred across the line as its text and still stored in the db as its
> text and can be reported out as real text...the only thing it does is not
> display it on the screen...there is no way to mask anything else that I'm
> aware of.
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[email protected]] On Behalf Of Guillermo Alfredo Torres Barron
> Sent: Friday, July 30, 2010 1:52 PM
> To: [email protected]
> Subject: Mask information
>
> Hi dear lister
> In our organization we have some users that need to capture privileged
> information, p.e. id cards, therefore we need mask this information in
> the character or diary fields, how can we do it?
> For example, the user capture id card but when search and display ticket
> the id card apper mask with other character, can be "*"
> Any idea is appreciate
> Thanks in advance
> Greetings
>
>
>
> ............................................................................
> ...............
> Este correo electronico es confidencial y/o puede contener informacion
> privilegiada.
> Si usted no es su destinatario o no es alguna persona autorizada por este
> para recibir sus correos electronicos, NO debera usted utilizar, copiar,
> revelar, o tomar ninguna accion basada en este correo electronico o
> cualquier otra informacion incluida en el, favor de notificar al remitente
> de inmediato mediante el reenvio de este correo electronico y borrar a
> continuacion totalmente este correo electronico y sus anexos.
> Nota: Los acentos y caracteres especiales fueron omitidos para su correcta
> lectura en cualquier medio electronico.
>
> This e-mail is confidential and/or may contain privileged information.
> If you are not the addressee or authorized to receive this for the
> addressee, you must not use, copy, disclose, or take any action based on
> this message or any
> other information herein, please advise the sender immediately by reply
> this
> e-mail and delete this e-mail and its attachments.
>
> ............................................................................
> ...............
>
>
> ____________________________________________________________________________
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
