Posts

Showing posts from April, 2023

Hide, Show, Disable Fields in a Zoho Form

We can Hide, Show, Disable Fields in a Zoho Form without using Deluge also. Select "Field Rule" when deciding  When to trigger workflow  ( Form Event )

Load of the form > Run Scripts - While Adding a Record

New Order > Created > Load of the form > Run Scripts - While Adding a Record disable Products.Unit_Of_Measure; disable Products.Unit_Price; disable Products.Total; //Assigning loggedin user details in 'Sales Owner' field input.Sales_Owner = Add_Employee[Email == zoho.loginuserid].ID; //Autofilling the order date with current date input.Order_Date = zoho.currentdate; productCount = Add_Product[ID != 0].count(); if(productCount == 0) { openUrl("#Form:Add_Product","same window"); }

Validations on form submission > Run Scripts - While Adding a Record (Deluge Script)

New Order > Created > Validations on form submission > Run Scripts - While Adding a Record (Deluge Script)  / /Validating date field if(Estimated_Delivery_Date < Order_Date) { alert "Please check the delivery date!"; cancel submit; } //Validating each product quantity here quantityExist = true; for each  eachRow in Products { if(eachRow.Quantity == 0) { quantityExist = false; } } if(quantityExist == false) { alert "Please check the product quantity to place order!"; cancel submit; }

Hide fields if User is not Admin

1) if(zoho.loginuserid != "sandeepsuperman777@gmail.com") { hide Application_Status; hide Interview_Date_Time; hide Comments; } 2) if(zoho.loginuserid != "sandeepsuperman777@gmail.com" || fields_link_name == "Isnull") { hide Application_Status; hide Interview_Date_Time; hide Comments; }

Roles & Permissions

Roles - What records user able to see. Records Access Control ~ record sharing settings. Records created by subordinates will be auto visible to the seniors in hierarchy. Permissions - Application (Read & Write) Control

One Liner Important Deluge Codes

Write these one line simply in the deluge editor for a workflow Hide fields in a form hide <field deluge name>; Ex: hide name; Disable a field in a form disable <field deluge name>; Ex: disable email_id;