Problem hiding some column in form view

[Mohd_Nur_Arief]

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.

[Aleksi]

Both Admin and User should see that column in the table view?

[Mohd_Nur_Arief]

yes sir

[Aleksi]

Try something like…
OR(
NOT(CONTEXT(“ViewType”)=“Form”),
AND(CONTEXT(“ViewType”)=“Form”,USERROLE()=“User”)
)

[Mohd_Nur_Arief]

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.

[Aleksi · Accepted solution]

You can check the status when adding a new record with a formula… IN([KeyColumn],TableName[KeyColumn])

[Mohd_Nur_Arief]

Got it. Thank you again

[Aleksi]

You’re welcome