View/read only format a column based on a custom field | Community
Skip to main content
Level 3
October 3, 2024
Solved

View/read only format a column based on a custom field

  • October 3, 2024
  • 1 reply
  • 1020 views

Is it possible to format a column results in project report so that its view/read only?

 

I have an extensive report containing both custom data and calculated columns. Id like to restrict all users to change the custom data on this report.

Best answer by Sven-iX

Hi @lukaszmatyszewski 

 

yes, two approaches:

  1. If you use valueexpression instead of valuefield that column just prints out the value and is no longer connected to the field. 
    • valuefield=SomeField       >     valueexpression={DE:SomeField}
    • Note that if you have fields where the label/value are different valueexpression will print out both label and value

  2. you can add makeFieldEditable=false in text mode to leave it as is (ie. showing exactly what it does out of box) and you disable inline editing. 

In your case I'd start with #2 on the columns you want to make non-editable.

1 reply

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
October 3, 2024

Hi @lukaszmatyszewski 

 

yes, two approaches:

  1. If you use valueexpression instead of valuefield that column just prints out the value and is no longer connected to the field. 
    • valuefield=SomeField       >     valueexpression={DE:SomeField}
    • Note that if you have fields where the label/value are different valueexpression will print out both label and value

  2. you can add makeFieldEditable=false in text mode to leave it as is (ie. showing exactly what it does out of box) and you disable inline editing. 

In your case I'd start with #2 on the columns you want to make non-editable.

Doug_Den_Hoed__AtAppStore
Community Advisor
Community Advisor
October 3, 2024

 

Hi @lukaszmatyszewski,

 

Another option is to create a dedicated Read Only user account, ensure it has only view access to all of the information of interest, then update any such report to "Run As" that Read Only user.

 

Regards,

Doug

Level 3
October 3, 2024

Even better!

 

Thanks Doug!