Weird problem with "Author" field

Hi all,

I have a little problem with the author field and would like to know how I can resolve this.

The form is in the EDIT MODE for that user, and his name DOES APPEARS in the AUTHOR FIELD on the form.

He’s able to see all the text on that row, but DOES NOT SEE that “EDITABLE FIELD” on the same row that he’s supposed to edit that particular field.

I use the SAME formula for the ENTIRE row, but that field is NON-EDITABLE (or DOES NOT SHOW UP) when the

user is in “Edit Mode”. So basically, he CAN NOT SEE whatever EDITBABLE FIELD he’s supposed to EDIT on this form.

AUTHOR field’s type is: AUTHOR - COMPUTED WHEN COMPOSED and intialized to “”

However, if he goes into another form, it shows that the form is in “Read Mode” only, and he can’t edit anything, which is right

since his name is not in the author field. He’s able to see whatever he’s supposed to see in the “Read Mode”, and he can’t edit anything on this form.

He has access as the “AUTHOR” in the ACL.

The problem is the usename is not unquie as you think. It’s dynamic. I have used these two lines to put the username in the the “RQ_Author” field.

Doc.RQ_Author = Arrayappend(Doc.RQ_Author, Doc.PAdmin(0))

Doc.RQ_Author = Arrayunique(Doc.RQ_Author, 5)

The RQ_Author field type is authors and computed when composed and is initialized to “” in the field.

The PAdmin field type is names and editable.

There is no value in the “PAdmin” field.

Here is the hiddenformula I used for the Editable field “NMember” that the user is supposed to edit !(@Name([CN]; @UserName) = PAdmin_1)

The type of PAdmin_1 is names and computed for displayed with the following formula

@Unique (@Trim (@ProperCase(@Name([CN];PAdmin))))

The type of PAdmin is names and editable

There is no value in the “PAdmin” field.

User’s keep complaining about this issue.

Does anyone have any idea? Please let me know if you need more information.

Thanks,

Mike Woo

Subject: Weird problem with “Author” field

How can a computed when composed field be initialized? It is a computed field and will comput to whatever is specified in the computed section of the field, which in this case would compute to nothing (“”). Shouldn’t you rather enter the username ie…@Name([CN];@UserName). This would put the current username in the author field when composed.

Subject: Re: Weird problem with “Author” field

Hi Brian,

The problem is the usename is not unquie as you think. It’s dynamic. I have used these two lines to put the username in the the “RQ_Author” field.

Doc.RQ_Author = Arrayappend(Doc.RQ_Author, Doc.PAdmin(0))

Doc.RQ_Author = Arrayunique(Doc.RQ_Author, 5)

The RQ_Author field type is authors and computed when composed and is initialized to “” in the field.

The PAdmin field type is names and editable.

Here is the hiddenformula I used for the Editable field “NMember” that the user is supposed to edit !(@Name([CN]; @UserName) = PAdmin_1)

The type of PAdmin_1 is names and computed for displayed with the following formula

@Unique (@Trim (@ProperCase(@Name([CN];PAdmin))))

The type of PAdmin is names and editable

There is no value in the “PAdmin” field.

Thanks,

Mike Woo

Subject: RE: Re: Weird problem with “Author” field

This is just for readability sake, but it is easier to understand when hide-when’s are coded like this:@If(@Name([CN];@UserName != PAdmin_1); @True; @False)

Now back to your original problem; Since there is no name in the PAdmin field which is the value you use to populate PAdmin_1 then your formula [ !(@Name([CN]; @UserName) = PAdmin_1) ] is “True” and the field is HIDDEN.

Subject: RE: Re: Weird problem with “Author” field

Hi Brian,

Since there is no name in the PAdmin field which is the value you use to populate PAdmin_1 then your formula [ !(@Name([CN]; @UserName) = PAdmin_1) ] is “True” and the field is HIDDEN.

If that is the case (or if it’s true and hidden), then when I type some text in same the cell (and other cells in the same row) next to the field, why the user able to see the text but not able to see the field?

Mike Woo

Subject: RE: Re: Weird problem with “Author” field

click inside the cells a see if the hide-when argument is the same as the field. check the hide when enabled box for the cell and see if it is checked

Subject: RE: Re: Weird problem with “Author” field

yes, brian. things appear as expected. All cells have same formula and the hidden box is checked. I can send you the form if you’d like. Have no idea, I guess that this is a bug then. if you have time (or perhaphs someone from IBM), please verify this?

Oh one more thing is I do use the querymodechange to prevent the users going to the “Edit Mode” and i don’t think that this causes the problem. Since the problem is the field is editable and type of names.

Thanks,

Mike Woo

Subject: RE: Re: Weird problem with “Author” field

Yeah, send it to me and I’ll take a look at it.bmart22@comcast.net