Create business logic for field calculations without needing to write custom code. You can select calculated field and create the formula that is automatically updated based on calculation you provide.
Grow your business using Calculated Fields to automate manual calculations & lessen the code for complex calculations
- Calculated Fields let you to automate your manual calculations used in your business production.
- You can give a field in your formula for dynamic calculations
- Available Functions :
Add, Subtract, Multiply, Divide, String Length, Concatenation, Log(Logarithm), Ln(Natural Log), Absolute, Average, Power, Date Difference, Percentage, Mod(Modulo), Minimum, Negate, Floor, Ceil ,Add hours,Add day,Add week,Add month,Add year,Sub hours,Sub days,Sub week,Sub month,Sub year,Diff days,Diff hour,Diff minute,Diff month,Week Diff,Diff year
- A rich conditional support we provide: you can make a big calculation here, a nested formula
- You can insert manual value or Field or both together to create formula. For e.g. add(field1,200,sub(100,field2))
- You can use calculated field also to make further formula
Download and Install the plugin
Admin-> Module Loader -> Upload & Install ‘SuiteCRM Calculated Fields’ -> Configure your License
Configure your license first
Admin-> SuiteCRM Calculated Fields -> License Configuration
After Configuring your License
Admin -> Repair -> Do 'Quick Repair & Rebuild'
Studio -> 'Module' -> Add Fields -> Select 'Data Type' : Calculated Field
- Click ‘Edit Formula’ to write your formula
Result of the above formula
- Calculate Percentage
Result of Percentage Formula
- Calculate Date Difference
Result of Date Difference
- Concatenation Example
Result of Concatenation
- Calculate Subtract Month
Result of Subtract Month
- Calculate Difference Minute
Result of Minute Difference
Other add-ons of interest
Glances - Integrate All Your Applications
Accomplish More Every Day. Spend your time on getting things done, not on finding information. Glances securely connects all of your apps and provides a simplified view of the data you need right when you need it, in real time.
Workflow Task Engine
Creating individual workflow processes and define detailed automatization tasks for your CRM. Break out of the standard SuiteCRM workflow frame and extend your CRM with your very own, personal BI. No need of hiring external consultants doing your customizations; stop dealing with compatibility probl...
Fed up of not being able to find important clients? Tag them! This plugin allows you to tag your records to identify them instantly. Color coded tags make it even simpler to catch them. Through Tag Management for SuiteCRM, the user can handle large amounts of records with similar attributes or type...