adspmo
asked on
Form Formula revisited
I would like everyone to see the information in a view.
Currently on the people listed in Authors field are seeing the documents in a view, wever if they ry o open the document then hey are rediected o an other form
Here is what I currently have
@If(
@IsNewDoc;
@Unavailable;
@UserNamesList *= WhoCanSee : NameFull; "These are fields"
Form;
"ErrorMessage") "Error form"
Currently on the people listed in Authors field are seeing the documents in a view, wever if they ry o open the document then hey are rediected o an other form
Here is what I currently have
@If(
@IsNewDoc;
@Unavailable;
@UserNamesList *= WhoCanSee : NameFull; "These are fields"
Form;
"ErrorMessage") "Error form"
ASKER
ErrorMessage
ASKER
I would like everyone to see the information in a view.
Currently only the people listed in Authors field are seeing the documents in a view,
So in the view I want the regular users to see the info at the view level
If they try to open a document then they get the not autorized message("ErrorMessage)"
If they are authorized then the document opens as normal with either "leave_fm" or: LSF"
Here is what I currently have
@If(
@IsNewDoc;
@Unavailable;
@UserNamesList *= WhoCanSee : NameFull; "These are fields"
Form;
"ErrorMessage") "Error form"
I am trying to understand what this formula is doing
@If( @IsNewDoc; @Unavailable; "Delete what"
@UserNamesList *= WhoCanSee : NameFull; Form;"What does the * do"
@IsMember( @Name([Abbreviate]; @UserName); @Name([Abbreviate];@Author )); Form; "I do not get this part at all"
"ErrorMessage")
Currently only the people listed in Authors field are seeing the documents in a view,
So in the view I want the regular users to see the info at the view level
If they try to open a document then they get the not autorized message("ErrorMessage)"
If they are authorized then the document opens as normal with either "leave_fm" or: LSF"
Here is what I currently have
@If(
@IsNewDoc;
@Unavailable;
@UserNamesList *= WhoCanSee : NameFull; "These are fields"
Form;
"ErrorMessage") "Error form"
I am trying to understand what this formula is doing
@If( @IsNewDoc; @Unavailable; "Delete what"
@UserNamesList *= WhoCanSee : NameFull; Form;"What does the * do"
@IsMember( @Name([Abbreviate]; @UserName); @Name([Abbreviate];@Author
"ErrorMessage")
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It doesn't work
If they are not included in the WhoCanSee : NameFull then they should be able to see the field values in aview, If they try to open and are not members of WhoCanSee : NameFull then they are redirected to ErrorMessage(form name) If they are included in WhoCanSee : NameFull then the document opens with the form it was created with
If they are not included in the WhoCanSee : NameFull then they should be able to see the field values in aview, If they try to open and are not members of WhoCanSee : NameFull then they are redirected to ErrorMessage(form name) If they are included in WhoCanSee : NameFull then the document opens with the form it was created with
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry.... I missed a few posts while typing that!
It sounds like the formula is doing what its supposed to do. Two concerns though:
Are names in WhoCanSee : NameFull selected (ok), computed (ok) or typed. In that last case we may need to see if a typo (or case sensitivety) is causing your problem.
You also sound a bit like "not everyone is capable of seeing all doc's in the view". If so, do some doc's hold a readers field as well?
Are names in WhoCanSee : NameFull selected (ok), computed (ok) or typed. In that last case we may need to see if a typo (or case sensitivety) is causing your problem.
You also sound a bit like "not everyone is capable of seeing all doc's in the view". If so, do some doc's hold a readers field as well?
ASKER
There are no readers field
THe values are computed
THe values are computed
Are you testing it on local then?
Please give us detailed info on a specific case that goes wrong. Including the (important) values of those fields. You can copy those values from the propertybox!
Please give us detailed info on a specific case that goes wrong. Including the (important) values of those fields. You can copy those values from the propertybox!
Yes Crak..It Could be case sensitiveness
Pair-wise comparison is OK.. not a problem.
@UserNamesList *= WhoCanSee : NameFull
and
@Name([Abbreviate]; @UserNamesList) *= @Name([Abbreviate]; AuhtorsField1 : AuthorField2)
will work unless WHoCanSee, NameFull is of Names or Authors type (just ruling out readers in this case).
James, Goto the field properties of WhoCanSee, NameFull and list it here. Also the data type as seen from property box
Pair-wise comparison is OK.. not a problem.
@UserNamesList *= WhoCanSee : NameFull
and
@Name([Abbreviate]; @UserNamesList) *= @Name([Abbreviate]; AuhtorsField1 : AuthorField2)
will work unless WHoCanSee, NameFull is of Names or Authors type (just ruling out readers in this case).
James, Goto the field properties of WhoCanSee, NameFull and list it here. Also the data type as seen from property box
One morething WHoCanSee and NameFull should be multivalued :-)
Good point!
ASKER
Field Name: WhoCanSee
Data Type: Text List
Data Length: 98 bytes
Seq Num: 2
Dup Item ID: 0
Field Flags: SUMMARY READ/WRITE-ACCESS NAMES
"[Admin]"
"Abhinav Chandra"
"CN=Migaly Lopez/OU=North America & Caribbean/OU=New York/O=SITA/C=WW"
Field Name: NameFull
Data Type: Text
Data Length: 15 bytes
Seq Num: 1
Dup Item ID: 0
Field Flags: SUMMARY
"Abhinav Chandra"
Data Type: Text List
Data Length: 98 bytes
Seq Num: 2
Dup Item ID: 0
Field Flags: SUMMARY READ/WRITE-ACCESS NAMES
"[Admin]"
"Abhinav Chandra"
"CN=Migaly Lopez/OU=North America & Caribbean/OU=New York/O=SITA/C=WW"
Field Name: NameFull
Data Type: Text
Data Length: 15 bytes
Seq Num: 1
Dup Item ID: 0
Field Flags: SUMMARY
"Abhinav Chandra"
And the user is....?
Does he/she have [Admin]?
Can he/she see the doc in the view?
What form is used when opened by the user?
Does he/she have [Admin]?
Can he/she see the doc in the view?
What form is used when opened by the user?
Sorry about me "he/she"-ing.... I can't tell from those names.
ASKER
THe user is the person in the NameFull field
They do not have Admin
They can see the doc and it opening with the right form
I have temporarily removed the form formula as this is driving me nuts
I do need one that will work
Authorized
Can Read /Edit
Not Authorized just sees the info in a view
They do not have Admin
They can see the doc and it opening with the right form
I have temporarily removed the form formula as this is driving me nuts
I do need one that will work
Authorized
Can Read /Edit
Not Authorized just sees the info in a view
Try this one
@IF(
@IsNewDoc; @Return(Form);
@isMember( @Name([CN];WhoCanSee : NameFull) ; @Name([CN];@UserNamesList) ); @Return(Form);
"ErrorMessage"
)
Let me know
@IF(
@IsNewDoc; @Return(Form);
@isMember( @Name([CN];WhoCanSee : NameFull) ; @Name([CN];@UserNamesList)
"ErrorMessage"
)
Let me know
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
CRAK,
> "A":"B":"C"="B":"C" returns True since the list "B":"C" occurs in the the other list
This is an incorrect explanation.
The comparison is unbalanced, since "A":"B":"C" has three eleemnts and "B":"C" has only two. So, Notes "doubles" the last element on the short side to fill it in. The following two comparisons are identical:
> "A":"B":"C"="B":"C"
> "A":"B":"C"="B":"C":"C"
ANd what BOTH of these do internally is:
"A"="B"? False, continue... (element #1 on left compared to element #1 on right)
"B"="C"? False, continue... (element #2 on left compared to element #2 on right)
"C"="C"? True, return true! (element #3 on left compared to ****VIRTUAL**** element #3 on right)
> "A":"B":"C"="B":"C" returns True since the list "B":"C" occurs in the the other list
This is an incorrect explanation.
The comparison is unbalanced, since "A":"B":"C" has three eleemnts and "B":"C" has only two. So, Notes "doubles" the last element on the short side to fill it in. The following two comparisons are identical:
> "A":"B":"C"="B":"C"
> "A":"B":"C"="B":"C":"C"
ANd what BOTH of these do internally is:
"A"="B"? False, continue... (element #1 on left compared to element #1 on right)
"B"="C"? False, continue... (element #2 on left compared to element #2 on right)
"C"="C"? True, return true! (element #3 on left compared to ****VIRTUAL**** element #3 on right)
Hmmm..... yep! Thats why it returned true.
My mistake!
Anyway.... I try to avoid situations like that in general. Though explained well now, it causes undesired (unexpected for most) side effects.
My mistake!
Anyway.... I try to avoid situations like that in general. Though explained well now, it causes undesired (unexpected for most) side effects.
Whoa!
Suddenly the question is closed with an A, but I haven't seen any changes!
What's cooking, James?
Suddenly the question is closed with an A, but I haven't seen any changes!
What's cooking, James?
@If( @IsNewDoc; @Unavailable;
@UserNamesList *= WhoCanSee : NameFull; Form;
@IsMember( @Name([Abbreviate]; @UserName); @Name([Abbreviate];@Author
"ErrorMessage")
~Hemanth