When you need to hide fields through various conditions within the Grid, we can do it through a query.  
  
The first thing we are going to do is a query and we will store it inside a variable.  
  
Then we use the macro sc\_lookup.  
  
After using said macro, we proceed to store it in an array, since within a Grid it is not possible to directly reference the field to make comparisons.  
  
So in this example we are going to be using the macro sc\_field\_display which is the one that allows to show or hide a said field based on a condition.  
  
Next the example:

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=k97k95cf531d84b134cafa644159a79f4fcfd)