Im trying to hide a certain column in the form view for USERROLE=“Admin” and show that column if USERROLE=“User”. And the table view will display all the information from all those column.
Solved! Go to Solution.
You can check the status when adding a new record with a formula… IN([KeyColumn],TableName[KeyColumn])
Both Admin and User should see that column in the table view?
yes sir
Try something like…
OR(
NOT(CONTEXT(“ViewType”)=“Form”),
AND(CONTEXT(“ViewType”)=“Form”,USERROLE()=“User”)
)
Thanks, it works like charm, but the problem now is that the admin can no longer edit the hidden part.
is there a way to just hide it only when adding n new report and make it editable during update?
Because the idea is for admin to prefill the form during adding a new report (admin should not see the user’s part) and the user will continue update the report during/after site visit (Users can see admin’s part but cannot edit).
I know that i can just create two separate section (Tabs) for the form but for some reason, i need to keep it simple.
You can check the status when adding a new record with a formula… IN([KeyColumn],TableName[KeyColumn])
Got it. Thank you again
You’re welcome
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |