How to hide a Related List

And I didn't even know you could do that...

      You know that Related List that displays the people who can approve or reject a document?
      The other day a scenario came up where the developer needed to prevent the employee who created a record from approving that document.
      It wasn't common because usually the operational level creates the document while a manager approves it.
      Leaving this question of personas aside and focusing on the problem, how would be a possible solution?


      The first workaround that came to mind was simply inhibiting the Approval list if the user who registered was viewing his own record.
      A workaround is not the ultimate solution. Just a palliative one while we find time to think about the ideal solution.


The action plan

      1) Every record has a field called sys_created_by;
      2) On the front-end (client side) we have access to an API called Glide User that has some information about the logged in user. Among them is the name in the userName property.
      What if we create a Client Script of type onLoad* that compares these two fields and, if they are the same, simply hides the Approvers related list?
      To see the related list name created for your table, you can access the platform and go to System UI > Related lists.

      Now that you know the related list name, your Client Script would look like this:

function onLoad() {
   
   var createdBy = g_form.getValue('sys_created_by');
   var loggedUser = g_user.userName;

   if (createdBy == loggedUser) {
      g_form.hideRelatedList('put your related list name here');
   }

}              
                    
      To get the value of the sys_created_by field it must be in the form. You can leave it read-only or even hidden but it must exist on the form.


      

__________
*A Client Script of type onLoad is executed whenever the form is opened.

Back