This extension was designed to allow field calculations to be made as you type (on the spot). It displays the formula field results instantly without having to save the record in order to see the calculation result (standard VTiger workflow functionality).
It supports standard & custom fields with ability to multiply, divide, add and subtract currency/integer/decimal values as well as concatenate text, perform functions/calculations on date fields and other custom functions to manipulate FieldX value based on FieldY.
Here are some of the key features that make our extension unique.
- Supports subtraction, addition, multiplication, power,& division
- Supports Text Concatenation (combine text fields)
- Supports Date Calculations (add_days, sub_days, difference_day, day variables and much more)
- Supports other field updates in real time (preset picklists, checkboxes or any other fields based on conditions)
- Compatible with Standard & Custom Fields
- Performs calculations/functions as you enter the field values (immediately)
- Supports Edit, Create, & Detail Views
- Supports all Custom & Standard VTiger Modules
- Module Manager Compatible
- Available on VTiger Marketplace
We provide a unique demo instance for all our extensions. Each demo instance is pre-configured to only show features available for the specific extension. It is likely that some of the standard vTiger modules have been disabled to make the demo more user friendly.
VTiger 7 Demo
Please use credentials below to access the demo.
- Link: https://demo7.vtexperts.com/fieldformula/index.php (Will open in new window)
- User: demo
- Pass: demo
VTiger 6 Demo
Please use credentials below to access the demo.
- Link: https://demo.vtexperts.com/realtimefieldformulas/ (Will open in new window)
- User: demo
- Pass: demo
If you are not able to access the demo or find an issue - please send us an email at support@vtexperts.com or via contact form.
All extensions come with an extensive user guide, which includes setup instructions, suggestions as well as usability tips. Please click the link below to access user guide for this extension.
User Guide: https://www.vtexperts.com/helpdesk/field-formula-concatenation (Will open in new window)
For assistance or any questions - please contact us via help@vtexperts.com.
3 reviews for Field Calculation/Concatenation in Real time (Date, Text, Math formulas & more)
Combine 2 Fields Into One In VTiger 7 April 13, 2018 - Field Calculation/Concatenation in Real time is designed to allow field calculations to be made as you type (on the spot). It displays the formula field results instantly without having to save the record in order to see the calculation result (standard VTiger workflow functionality). How to Combine 2 Fields Into One Go to Menu >> Settings >> CRM Settings >> Automation >> Workflows. Click on the "+ New Workflow" Button to create a new workflow. Enter a workflow name. Enter the conditions for this example anytime these fields are Not Empty we want to trigger the calculations then Add and an action which is Field Formula. Enter the action title. Check box the Execution on demands which means it calculates as soon as the user enters the value in the field. Then add the field and select the expression for this example we need Concat(a,b) and we add a fields and put it on the spot of a… Read More
Automatically Calculate Fields In VTiger 7 April 11, 2018 - Field Calculation/Concatenation in Real time is designed to allow field calculations to be made as you type (on the spot). It displays the formula field results instantly without having to save the record in order to see the calculation result (standard VTiger workflow functionality). How to Automatically Calculate Fields Go to Menu >> Settings >> CRM Settings >> Automation >> Workflows. Click on the "+ New Workflow" Button to create a new workflow. Enter a workflow name. Enter the conditions for this example anytime these fields are grater than equal to 0 we want to trigger the calculations then Add and an action which is Field Formula. Enter the action title. Check box the Execution on demands which means it calculates as soon as the user enters the value in the field. Then add the field and select the expression for this example we need to add the field and Arithmetic Function While creating… Read More
Calculate Days Between Dates In VTiger 7 April 10, 2018 - Field Calculation/Concatenation in Real time is designed to allow field calculations to be made as you type (on the spot). It displays the formula field results instantly without having to save the record in order to see the calculation result (standard VTiger workflow functionality). How to Calculate Days Between Dates Go to Menu >> Settings >> CRM Settings >> Automation >> Workflows. Click on the "+ New Workflow" Button to create a new workflow. Enter a workflow name. Enter the conditions for this example anytime these fields are not empty we want to trigger the calculations then Add and an action which is Field Formula. Enter the action title. Check box the Execution on demands which means it calculates as soon as the user enters the value in the field. Then add the field and select the expression for this example we need time_diffdays(a,b) and add the filed names on a and b. While creating a… Read MoreRelated products
This extension was designed to allow field calculations to be made as you type (on the spot). It displays the formula field results instantly without having to save the record in order to see the calculation result (standard VTiger workflow functionality).
It supports standard & custom fields with ability to multiply, divide, add and subtract currency/integer/decimal values as well as concatenate text, perform functions/calculations on date fields and other custom functions to manipulate FieldX value based on FieldY.
Here are some of the key features that make our extension unique.
- Supports subtraction, addition, multiplication, power,& division
- Supports Text Concatenation (combine text fields)
- Supports Date Calculations (add_days, sub_days, difference_day, day variables and much more)
- Supports other field updates in real time (preset picklists, checkboxes or any other fields based on conditions)
- Compatible with Standard & Custom Fields
- Performs calculations/functions as you enter the field values (immediately)
- Supports Edit, Create, & Detail Views
- Supports all Custom & Standard VTiger Modules
- Module Manager Compatible
- Available on VTiger Marketplace
We provide a unique demo instance for all our extensions. Each demo instance is pre-configured to only show features available for the specific extension. It is likely that some of the standard vTiger modules have been disabled to make the demo more user friendly.
VTiger 7 Demo
Please use credentials below to access the demo.
- Link: https://demo7.vtexperts.com/fieldformula/index.php (Will open in new window)
- User: demo
- Pass: demo
VTiger 6 Demo
Please use credentials below to access the demo.
- Link: https://demo.vtexperts.com/realtimefieldformulas/ (Will open in new window)
- User: demo
- Pass: demo
If you are not able to access the demo or find an issue - please send us an email at support@vtexperts.com or via contact form.
All extensions come with an extensive user guide, which includes setup instructions, suggestions as well as usability tips. Please click the link below to access user guide for this extension.
User Guide: https://www.vtexperts.com/helpdesk/field-formula-concatenation (Will open in new window)
For assistance or any questions - please contact us via help@vtexperts.com.
3 reviews for Field Calculation/Concatenation in Real time (Date, Text, Math formulas & more)
-
very responsive plugin
-
Thumbs up!
-
its super super fast
Combine 2 Fields Into One In VTiger 7 April 13, 2018 - Field Calculation/Concatenation in Real time is designed to allow field calculations to be made as you type (on the spot). It displays the formula field results instantly without having to save the record in order to see the calculation result (standard VTiger workflow functionality). How to Combine 2 Fields Into One Go to Menu >> Settings >> CRM Settings >> Automation >> Workflows. Click on the "+ New Workflow" Button to create a new workflow. Enter a workflow name. Enter the conditions for this example anytime these fields are Not Empty we want to trigger the calculations then Add and an action which is Field Formula. Enter the action title. Check box the Execution on demands which means it calculates as soon as the user enters the value in the field. Then add the field and select the expression for this example we need Concat(a,b) and we add a fields and put it on the spot of a… Read More Automatically Calculate Fields In VTiger 7 April 11, 2018 - Field Calculation/Concatenation in Real time is designed to allow field calculations to be made as you type (on the spot). It displays the formula field results instantly without having to save the record in order to see the calculation result (standard VTiger workflow functionality). How to Automatically Calculate Fields Go to Menu >> Settings >> CRM Settings >> Automation >> Workflows. Click on the "+ New Workflow" Button to create a new workflow. Enter a workflow name. Enter the conditions for this example anytime these fields are grater than equal to 0 we want to trigger the calculations then Add and an action which is Field Formula. Enter the action title. Check box the Execution on demands which means it calculates as soon as the user enters the value in the field. Then add the field and select the expression for this example we need to add the field and Arithmetic Function While creating… Read More Calculate Days Between Dates In VTiger 7 April 10, 2018 - Field Calculation/Concatenation in Real time is designed to allow field calculations to be made as you type (on the spot). It displays the formula field results instantly without having to save the record in order to see the calculation result (standard VTiger workflow functionality). How to Calculate Days Between Dates Go to Menu >> Settings >> CRM Settings >> Automation >> Workflows. Click on the "+ New Workflow" Button to create a new workflow. Enter a workflow name. Enter the conditions for this example anytime these fields are not empty we want to trigger the calculations then Add and an action which is Field Formula. Enter the action title. Check box the Execution on demands which means it calculates as soon as the user enters the value in the field. Then add the field and select the expression for this example we need time_diffdays(a,b) and add the filed names on a and b. While creating a… Read MoreInformation
- Ioncube & PHP SOAP (hands-on)
- Install & Setup (hands-on)
- Meeting Server Requirements
- Assisting with any issues related to plugins
Shane (verified owner) –
very responsive plugin
Sacha (verified owner) –
Thumbs up!
Lester (verified owner) –
its super super fast