Platform

 View Only

 How to use 'disable edits' functionality for editable tables exposed to reporting surface?

Jump to  Best Answer
  • TBMStudio
Apptio Community Member's profile image
Apptio Community Member posted 10/25/22 03:45 PM
I am trying to disable the editability of a table for non-admin and non-finance roles for a number of editable tables exposed to the reporting surface. I see there is an option on the advanced ET settings to do this but I do not know how to actually use the option.
There is an input box that requests "code" to evaluate as true. My first thought was to leverage $CurrentUser details but I couldn't get it to work. Any help would be appreciated!
#TBMStudio
Dan Kelly's profile image
Dan Kelly posted 10/25/22 04:04 PM  Best Answer

Hi Jason, try this:

<%=If(eval("=$CurrentUser:Users.Role") IN ("Admin", "Role A","Role B"),"false","true")%>

#TBMStudio
Apptio Community Member's profile image
Apptio Community Member posted 10/25/22 07:20 PM
@Dan Kelly Works like a charm! Glad to see I was going down the right path—I just didn't think to use the eval function. Thank you for your quick response.​
#TBMStudio
Ed Hayman's profile image
Ed Hayman posted 10/26/22 09:57 AM
Currently, in the Editable Table menu, one can assign permissions to Editable Tables by role including actions to: Add Row, Delete Row, and Publish.  A new permission feature, "Edit Row", will be added in an upcoming release.  This will allow you to assign Edit Row permissions by role without using ApptioScript.
#TBMStudio

Related Content