cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
David_Pezzoli
Advocate IV
Advocate IV

Rollup columns in Model-driven app editable grid are not read-only

Hi all,

the rollup columns (rollup fields) on editable grids aren't read-only!

See my idea: here

How can I make a rollup field on the editable grid read-only?

 

I'm not able to restrict rollup by Business Rule.

Is it possible by JavaScript?

Is it possible by Column (field) security?

Other possible tricks and workarounds?

 

Like my idea, thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
David_Pezzoli
Advocate IV
Advocate IV

I tested! Currently, it is possible to solve the issue setting rollup read-only using:

  • JS on views, but it doesn't work on the Dashboard lists
  • BRs on views, but they don't work on the Dashboard lists
  • Column Security (by Security Field Profile with update restriction): this solution work on both views and Dashboard lists

Calculated columns are not very effective: they still provide the illusion for the user to be able to edit the cell of the calculated column....although in reality they do not undergo temporary changes.

 

Please, support my idea! 

View solution in original post

2 REPLIES 2
dpoggemann
Super User
Super User

Hi @David_Pezzoli ,


Had to try it myself to believe it!  It should not be editable, you are correct.  I voted for your idea.

 

Thanks,


Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
David_Pezzoli
Advocate IV
Advocate IV

I tested! Currently, it is possible to solve the issue setting rollup read-only using:

  • JS on views, but it doesn't work on the Dashboard lists
  • BRs on views, but they don't work on the Dashboard lists
  • Column Security (by Security Field Profile with update restriction): this solution work on both views and Dashboard lists

Calculated columns are not very effective: they still provide the illusion for the user to be able to edit the cell of the calculated column....although in reality they do not undergo temporary changes.

 

Please, support my idea! 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,361)