Link to home
Start Free TrialLog in
Avatar of adspmo
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"
Avatar of HemanthaKumar
HemanthaKumar

What is the name of the other form that author is presented with ?

@If( @IsNewDoc; @Unavailable;
@UserNamesList *= WhoCanSee : NameFull; Form;
@IsMember( @Name([Abbreviate]; @UserName); @Name([Abbreviate];@Author)); OtherForm;
"ErrorMessage")

~Hemanth
Avatar of adspmo

ASKER

ErrorMessage
Avatar of adspmo

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")



SOLUTION
Avatar of HemanthaKumar
HemanthaKumar

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of adspmo

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
SOLUTION
Avatar of CRAK
CRAK
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
 
Avatar of adspmo

ASKER

There are no readers field

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!
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
One morething WHoCanSee and NameFull should be multivalued :-)
Good point!
Avatar of adspmo

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"


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?
Sorry about me "he/she"-ing.... I can't tell from those names.
Avatar of adspmo

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
Try this one

@IF(
@IsNewDoc; @Return(Form);
@isMember( @Name([CN];WhoCanSee : NameFull) ; @Name([CN];@UserNamesList) ); @Return(Form);
"ErrorMessage"
)

Let me know
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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)
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.
Whoa!

Suddenly the question is closed with an A, but I haven't seen any changes!

What's cooking, James?