Problems with Author field and controlled access sections

HCL Domino Domino Forum
1

Here’s something I struggle with and I wonder how some of you handle this. I put an author field on a form and set it to use the address book. I also say to only allow values in the list, but that doesn’t stop anyone from just typing a name in that might not match a name as it exists in the address book. Also, when I create a document with the form, it puts the name of the person creating the document in the author field even though there is no default formula. Why does it do that? I want it to start out blank. So I enter “” as the default formula. Of course that causes a problem with the controlled access section which the author field populates because “” equates to anyone can access the section.

I’ve also tried making the field the user enters names into a dialog list and setting that to use the address book and then making a hidden author field which inherits its value from the dialog list field. That mostly works. But I’ve encountered a new problem. Somebody types in a name, i.e. Mickey mouse. But the real name is Mickey Mouse. The letters are all the same except for a capital letter, but the user won’t be able to see his approval button because Notes apparently doesn’t see Mickey mouse and Mickey Mouse as being the same. Although I think this used to work on earlier versions of notes. I have added @ProperCase as Input Translation formula to the dialog list field so maybe that will cure things.

2

Subject: Problems with Author field and controlled access sections

Make it a computed field computed to itself. Then use a graphic image next to it to show the Address dialig to get the choice and populate the field.

3

Subject: RE: Problems with Author field and controlled access sections

Found an easier way to do this:

FIELD projManName := projManName;

namesHolder := @PickList([Name]);

@Prompt([Ok]; “Value of namesHolder”; namesHolder);

@SetField( “projManName”; projManName : namesHolder )

One question though: Do you need to supply the server as part of the picklist in case the address book is located on a different server than the application

4

Subject: RE: Problems with Author field and controlled access sections

Well, I wasn’t sure how to do this but I came up with the following code:

server := “ElyCCG/CCG/ENGEL”;

DBName := “names.nsf”;

getPerson := @PickList([Custom]; server : DBName; “People”; “Name Selection”; “Select the department head from the address book”; 2);

@Prompt([Ok]; “Value of getPerson”; getPerson);

check := @If(getPerson = 1 | @IsError(GetCustomer); @Return(Quit); Continue);

FIELD projManName := getPerson;

@True

I have two problems that I’m not sure how to solve using the above code. First, I can only pick one name. How do I get it to allow me to pick more than one? Second, the names are added with the the last name first. I can write some code to search for the comma and then re-arrange. But is there some other way? And if I do re-arrange, will Notes still accept the value as a match under it’s security? Thanks.