Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

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
0
adspmo
Asked:
adspmo
  • 4
  • 4
  • 3
1 Solution
 
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
0
 
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
0
 
HemanthaKumarCommented:
Is this EditButton on the form or view ?

Where does EditRights come from.. in document ? and a Readers field ?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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")
0
 
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..
0
 
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.
0
 
qwaleteeCommented:
What was the fix?
0
 
adspmoAuthor Commented:
Multiple Values not being set
0
 
qwaleteeCommented:
Man, I wasted five extra paragraphs there!
0
 
adspmoAuthor Commented:
Sorry
0
 
qwaleteeCommented:
adspmo,
> Sorry
LOL
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now