Hide When problem with System edit button


Hi All


I am using the default Edit button with the following hide when and it does not seem to be working

(@IsNotMember(@Name([CN]; @UserName); WhoCanSee))

WhoCanSee is a Authors field which returns names based o the status of the form

"[Admin]":RequesterName:Approver_1:Approver_2:cur_SiteManager

Depending on the type of request there is no Approver_1

The return from the field is as follows:
"[Admin]"
"James Wood"
""
"Approver Two"
"Site Manager"


I would not think that this would be a problem for the hide when

Any Help

Appreciated

James
adspmoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HemanthaKumarCommented:
Try this formula
@IF( @IsNotMember(@Name([CN]; @UserName); @Name([CN]; @Trim(WhoCanSee)) )

You can quickly check the result of the formula by putting it in a temporary computed field

~Hemanth
adspmoAuthor Commented:
Nope that did not do it

I also went in and did an @Trim on the who can see field

There is two authors fields on this doc

WhoCanSee and Edit Rights
WhoCanSee is for form formula in the views

EDitRight controls who can see what when

Can this be a problem

James
HemanthaKumarCommented:
Is this EditButton on the form or view ?

Where does EditRights come from.. in document ? and a Readers field ?
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

adspmoAuthor Commented:
It is on the form
EditRights come from the document. I do not have a readers field as I think this would cause problems with the Form Formula I am using

@If(
     @IsNewDoc;
          @Unavailable;
     @UserNamesList *= WhoCanSee : RequesterName;
          Form;
          "ErrorMessage")
HemanthaKumarCommented:
How about WhoCanSee and RequesterName... they are also computed in the form ???

THis is not the right way to do it.. The form formula will always calculate when user clicks on document to open.. SO you have to place your computation in form formula section of the view.

Now what does Form Formula has got to do with Edit button's hide formula ?? Nothing.

ALso when you calculate whocansee in the form, it is not computed unless you place the doc in edit mode... So that is a caveat.. You have to calculate WhoCanSee values in Hide formula too..
qwaleteeCommented:
First thing I always check: for the field you are matching against, is the "allow multiple values" option turned on?

Next, I would place test formual on the form to see how the calulation is working.  These can be computed for display fields, computed text areas, or buttons with prompts.  these are the formulas I would use for checking:

WhoCanSee

@Elements(WhoCanSee)

@Length(WhoCanSee)

You might try these with EditRights and RequesterName as well.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
qwaleteeCommented:
What was the fix?
adspmoAuthor Commented:
Multiple Values not being set
qwaleteeCommented:
Man, I wasted five extra paragraphs there!
adspmoAuthor Commented:
Sorry
qwaleteeCommented:
adspmo,
> Sorry
LOL
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.