Zoho People now supports formula fields. This post illustrates it.
Formula fields are fields whose value is calculated instead of being entered by the user. Using this, number, decimal and date manipulations can be done. The value of this field could be numeric or date depending on the output of the formula. In date manipulations, the result will be given in milliseconds, which you can format as per you need. The operators we support are +, - , *, /. Formula fields get recalculated automatically whenever the formula is changed. It also gets recalculated, when a field involved in the formula is changed.
To add formula fields
i) Go to Customize form.
ii) Double click or drag formula field from the tool box.
iii) The fields which can be used for calculation are listed at the right side of the formula field popup.
To construct the formula
To select a field or operator for formula construction
i) Click at the position in the Specify formula text area where you need to insert the operator or field.
ii) Then click on the corresponding operator.
To enclose part of formula within brackets, select that part and then click on the brackets.
To insert current date or timestamp click on the icons (shown in red in the below picture) present near the operators
Sample formula expressions
1. Formula to calculate leave duration
( ToDate – FromDate ) / (1000 * 60 * 60 * 24)
2. Formula for PF calculation
( BasicPay * 12 ) / 100
To edit the formula field
While configuring formulas you can receive error messages like
i) Field name 'fdfdfff' does not exist in the form - Arises when you try to specify a field for formula construction which is not there in the listing.
ii) Found an error in the formula. Cannot add two date expressions - When you try to add two date fields.
- Project Management Software & Collaboration
- Remote Support & Web Meeting
- Document Management & File Storage
- Online Forums Software
- SharePoint Integration
- Collaborative Website with Wiki
- Actionable Insights For Social Media Marketing
- Online Contact Management
- Sales force Automation & CRM Software
- Applicant Tracking System
- Help Desk Software for Customer Support
- Online Form & Online Database
- Online Email & Social Marketing
- Bug Tracking
- Accounting Software
- Online Reporting & SAAS BI
- Invoice Software
- Email Hosting