Hi All
Just a quick question, is it possible to disable a data card based on who is looking at an edit form?
For example, in my internal audit app.
I create a non-conformance (which is just a SharePoint list item) and assign that to a person (group finder in SharePoint).
I have 2 fields which we can call 'Auditor Comments' and 'Employee Comments'.
Is it possible so that when a user presses Edit form, only the auditor can edit 'Auditor Comments' but still see what the employee put, and vice versa?
Hi @Anonymous,
There is a function which could use to get the information for the current user.
For example, if the list tiem is assigned to a person, and there is a field (person or group type field) used to display who owns this item, then we could take use of the User() function to "Hide" the Auditor Comments TextInput Box.
Under the Edit form, first select the Auditor Comments datacard, at the right pane, click Advanced, choose to un-lock this data card, then Insert a Label box into this datacard, change its text property with:
ThisItem.Auditor Comments
Then find its Visible property, change it with the formula below:
If(User().Email=ThisItem.Person.Email,false,true)
Person field here should be the Auditor field in the SharePoint item.
Besides, select the original Textinput Box, change its Visible Property with the following formula:
If(User().Email=ThisItem.Person.Email,true,false)
This would allow to show the Comments Label when user is not Auditor, and show the editBox when user is Auditor.
Post back if you need any further assistance.
Regards,
Michael
You can use the same if function "DisplayMode" property Disabled.
User | Count |
---|---|
252 | |
104 | |
94 | |
50 | |
39 |