Specifying cell permissions
The gadget spec URL could not be found



In the previous section, we configured the visibility and editability permissons for the "Add Product" button. In this section, we will configure the visibility and editability permissions for the "Make Active" and "Make Inactive" button.

  Conditions to be configured in the permissions
  • "Make Inactive" button
    • Write: When? Existing product (Added equals 'Yes') and product is active (product status equals 'Active')
    • Hide: When? New product (Added equals 'No'), or Existing product (Added equals 'Yes') and product is inactive (product status equals 'Inactive')
  • "Make Active" button
    • Write: When? Existing product (Added equals 'Yes') and product is inactive (product status equals 'Inactive')
    • Hide: When? New product (Added equals 'No'), or Existing product (Added equals 'Yes') and product is active (product status equals 'Active')

Configuring write permissions for "Make Active" button
  
Select the "Make Active" button.

Click on the "X" mark below "Write" to enable permissions for defauly activity. "fx" formula button will now be displayed for "Write".

Click on the "fx" formula button for "Write".
   
"Grid Cell Permissions" dialog box will be displayed.

Click on the add criteria "+" button.

First parameter: Select "Added" from the public cells dropdown list.

Second parameter: Select the option "Equals".

Third parameter: Select the option "Value".

Fourth parameter: Enter the value as "1".

Click on the "Done" button.

Click on the "+" add condition button. A new row for condition will be displayed.
   
Add the condition to check if "Product_Status" equals "Inactive".



Configuring hide permissions for "Make Active" button
  
Click on the "X" mark below "Hide" to enable permissions for default activity."fx" formula button will now be displayed for "Hide".

Click on the "fx" formula button for "Hide".
   
"Grid Cell Permissions" dialog box will be displayed.

Add the condition to check if "Added" equals "0".
   
Select the "or" radio button.
   
Click on the add criteria "+" button.

Add the condition to check if "Added" equals "1".

Click on the "+" add condition button. A new row for condition will be displayed.

Add the condition to check if "Product_Status" equals "Active".

Click on the "Done" button.



Configuring write permissions for "Make Inactive" button
  
Select the "Make Inactive" button.

Click on the "X" mark below "Write" to enable permissions for default activity."fx" formula button will now be displayed for "Write".

Click on the "fx" formula button for "Write".
   
"Grid Cell Permissions" dialog box will be displayed.

Click on the add criteria "+" button.

Add the condition to check if "Added" equals "1".
   
Click on the "+" add condition button. A new row for condition will be displayed.

Add the condition to check if "Product_Status" equals "Active".
   


Configuring hide permissions for "Make Inactive" button
  
Click on the "X" mark below "Hide" to enable permissions for default activity."fx" formula button will now be displayed for "Hide".

Click on the "fx" formula button for "Hide".
   
"Grid Cell Permissions" dialog box will be displayed.

Click on the add criteria "+" button.

Add the condition to check if "Added" equals "0".

Select the "or" radio button.

Click on the add criteria "+" button.

Add the condition to check if "Added" equals "1".

Click on the "+" add condition button. A new row for condition will be displayed.

Add the condition to check if "Product_Status" equals "Inactive".

Click on the "Done" button.
   
What's the next step?

Add the form to the menu and deploy.