[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1152
  • Last Modified:

How can i hide a field from Document properties ...Second Tab ?

Hi ALL Notes Gurus,

I have a Social security field in the document which i want to hide from being seen using Document Properties Second Tab .
Requirement is
1. I dont wanna use readers fields .
2. Dont wanna use Design Hiding feature ..as       database corruption have been reported.
3 tried using password field but on documnet properties it actually shows the text..


I dont know how does notes hide the bcc field from being seen ?


Any solution is welcome ...
0
pkesarwani11
Asked:
pkesarwani11
  • 14
  • 10
  • 4
  • +1
1 Solution
 
zvonkoCommented:
additionally you have to enable Form's encryption keys, like described here:
http://doc.notes.net/domino_notes/5.0.3/help5_designer.nsf/f4b82fbb75e942a6852566ac0037f284/da2aef0c18c36b158525687e00583070?OpenDocument&AutoFramed

Or create a field on the form with the name: SecretEncryptionKey
Make the field Computed with the name of user. All fields with enabled encryption will be encrypted with the public key of saving user. Of course only this user can afterwards read this field content after next time saved with this form. If you like to have more peoples reading this field content (what I assume) then you have to create and distribute the encryption keys for people allowed to read the content. Then is the encryption key not the public key but this application encryption key which you have distributed to content editors/readers.
Here is described how to create this encryption keys. On this key dialog tab is also a mail option for distributing the key:
http://doc.notes.net/domino_notes/5.0.3/help5_designer.nsf/f4b82fbb75e942a6852566ac0037f284/c71076eafcea81808525687e00583054?OpenDocument&AutoFramed


Good luck

0
 
zvonkoCommented:
By the way: Memo field BlindCopyTo is not hidden.

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ArunkumarCommented:
Right on the money buddy!
0
 
zvonkoCommented:
:)

this time I tell him in advance: please an A+ <:-)

0
 
ArunkumarCommented:
haa haa haa You deserve it buddy!
0
 
snocrossCommented:
You guys are funny... Zvo have you been taking begging lessons from Arun?
0
 
zvonkoCommented:
Yeap :)

I learn fast; perhaps I do outrun him whit my methods :)
0
 
snocrossCommented:
Add your points together and you have already achieved that.
0
 
pkesarwani11Author Commented:
Well my problem right now is that these field show up in certain views i still want to use that...Encryption Keys isnt possible to manage for us right now , as there are too many users....
And less skilled users.

What i want is if you hide it from design tab of document properties .?
0
 
pkesarwani11Author Commented:
My application is complete ..


The SSN is hidden field when you open a document. But hidden fields still show up on the design tab of the document properties ...which i dont wanna happen.
0
 
pkesarwani11Author Commented:
I dont want to use encrption Keys ..just want to hide the field ..Its hidden on the form ..wish i can hide it from the Document Properties Second Tab .
0
 
zvonkoCommented:
To achieve this you have to write a new Notes client :-)

Believe me, it does not matter how it is hidden on the form. User can create a new view and new form to show all items that are not encrypted in saved documents.

But there where another approach...
If there are defined only a few places where this SSN is entered and fetched for further processing, then you have a chance to use a trick: encrypt the SSN whit your discrete functions and decrypt it again where needed

So my question is: how many places are in your application where this SSN is handled?

0
 
pkesarwani11Author Commented:
Well SSN is only in one form and single field..

Some developers are getting ideas about using another database to store SSN and..Get it on the requried form using dblookup.But its adding a little over head in te sense if a report is to generated the one has to lookup SSN .

tell me about

"encrypt the SSN whit your discrete functions and decrypt it again where needed"

I also wanted to know how bcc works ..if theresome scope to do that.

I know its a challenging question and thats why i added 100 points.

Prashant
0
 
pkesarwani11Author Commented:
Well SSN is only in one form and single field..

Some developers are getting ideas about using another database to store SSN and..Get it on the requried form using dblookup.But its adding a little over head in te sense if a report is to generated the one has to lookup SSN .

tell me about

"encrypt the SSN whit your discrete functions and decrypt it again where needed"

I also wanted to know how bcc works ..if theresome scope to do that.

I know its a challenging question and thats why i added 100 points.

Prashant
0
 
pkesarwani11Author Commented:
If "encrypt the SSN whit your discrete functions " you mean run the it through function then again when ever we have to to some reporting stuff or trying to use it ..............it again becomes a overhead.

I wish some one must be having a better solution ..
0
 
pkesarwani11Author Commented:
If "encrypt the SSN whit your discrete functions " you mean run the it through function then again when ever we have to to some reporting stuff or trying to use it ..............it again becomes a overhead.

I wish some one must be having a better solution ..
0
 
zvonkoCommented:
The overhead generates less complication compared to ACL and database naming and path relocation problems when you try this @DbLookup method. And with the @DbLookuped database is the same problems: SSN is still plain text.

Do you prefer LotusScript or @Formula encrypt and decrypt functions?

Give me also an example for a SSN.

So long,
zvonko



0
 
pkesarwani11Author Commented:
Can u give me both ?
0
 
zvonkoCommented:
and this all for 100 points :-)
I expect at least 300, better 500 points.

Give me please a SSN example.

And I have to drive away over the weekend. On Monday I can give you at least this JavaScript method.

If you prefer ready to use DLLs then I can recommend you Microsoft CAPICOM. Here I described encryption:
http://www.experts-exchange.com/lotusnotes/Q.20302437.html

and decryption works the same way.

This Microsoft encryption can be this short:
Function EncryptMessage(Byval TobeEncrypted As String, Byval hidden As String) As String
     Dim message As Variant
     Set message = CreateObject( "CAPICOM.EncryptedData" )
     Call message.SetSecret(hidden, CAPICOM_SECRET_PASSWORD)
     message.Algorithm.Name = CAPICOM_ENCRYPTION_ALGORITHM_DES
     message.Content = Tobeencrypted
     EncryptMessage = message.Encrypt(CAPICOM_ENCODE_BASE64)
End Function

You call this function like this:
myHiddenValue = EncryptMessage(valueToHide, "myPassword")

And you put as prefix or suffix special characters to mark this value for you as encrypted. Like the @Password function does.

Nice weekend,
zvonko


0
 
zvonkoCommented:
Hello Prashant,

please increase the points.

Is SSN a 9 digit number with two dashes in between?
Like this: 333-22-4444

The simple formula to encrypt SSN would be then:
FIELD SSN:=SSN;
@If(@Left(SSN;1)="x";"";
@SetField("SSN";"x"+@ReplaceSubstring(SSN;"0":"1":"2":"3":"4":"5":"6":"7":"8":"9":"-";"q":"w":"ec":"rv":"tbn":"zm":"ul":"ih":"o":"p":"s")))

Best place for encryption formula would be the Form’s QuerySave event.

For decryption use this formula:
FIELD SSN:=SSN;
@If(@Left(SSN;1)="x";
@SetField("SSN";@ReplaceSubstring(@Right(SSN;"x");"q":"w":"ec":"rv":"tbn":"zm":"ul":"ih":"o":"p":"s";"0":"1":"2":"3":"4":"5":"6":"7":"8":"9":"-"));"")


Because you have not stated when SSN has to be in plain format I can not recommend when to decrypt your SSN.

This was a simple method do hide from first view the content. In most cases that would be enough. Next step would be to recalculate the SSN number before translating. But this is mostly not necessary.

In LotusScript I use much more elegant XOR functions to encrypt and decrypt any ASCII content. But please increase first the offered points.

So long,
zvonko

0
 
zvonkoCommented:
Hello Arun,

does your SSN start with: 386

0
 
ArunkumarCommented:
Nope mine starts with a 1 !

Whatever....pkesarwani, 100 pts is too very much for this question so, dont bother to increase it...

;-)
Arun.
0
 
zvonkoCommented:
OK,

then it can be either 134 or 158
I think yours is: 134 :-)

0
 
zvonkoCommented:
Hi Arun,

is it now 134 or not?

0
 
pkesarwani11Author Commented:
Well SSN can start with any number like my start like
157989954 so will the formula work .?

I will increase the points as soon my team is OK with the solution points is not an issue as long as the solution works. This Question is open and Arun if u have a better solution pl come up with it......Even if both solutions r good i will get u both points some or the other way.

Prashant
0
 
zvonkoCommented:
The @Formula is working for numbers and for the dash char; Other chars stay visible.

The LotusScript I have to prepare for you so it takes time.

If Arun can help you it would be good for me, because just now I am preparing for vacations and have not enough time for this :-)

0
 
ArunkumarCommented:
oh boy i lost track of this question completely for a while.

Zvo,
SSN is the social security number and it is of 9 digits
in the format something like

123-45-6789

Each individual has a unique SSN here in the US and if i give out my ssn it could be misused. I know you wont but its better not to give out right ? Its more valuable than your credit card number you know what i mean buddy ? thats why i did not give it out in this forum :-)

Dont bother ! I can give it across Groove. Is it secure enough ?

:-)
Arun.
PS: By the way i dont think i have a solution for this question though. If YOU dont have then WHO will have ?
0
 
zvonkoCommented:
Thank you Prashant for the points :-)

Is your problem now solved?

I mean the big advantage (and the disadvantage :-) of this LotusScript encryption method is that even the code is only readable by real programmers :)
Real programmers mean: able to explain why two times XOR recreates the original value :)

I have found a list of these first three digits in SSN dedicated to locations in USA, and there where only two triples starting with a "1": 134 for "New York"
and 158 for "New Jersey"




0
 
pkesarwani11Author Commented:
Well we r trying to yuse for formila method but will be interesting if you can send me the lotusscript code too....



Just that will have to convince the administartor to put that in..

Thanks
Prashant
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 14
  • 10
  • 4
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now