by Variance InfoTech Pvt Ltd

Need to auto populate value based on the value of related field? For this requirement Auto Populate is the perfect solution. The advanced configuration tools allow you to clearly define what should happen whenever a related field value changes.

Cancel at any time!
Free Trial

Introduction

Introduction

Auto Populate Fields add-ons used to auto fill up fields depending on relate field of particular module.

Features

  • Auto Populate Fields add-ons supports on Editview of the particular module.
  • Auto Populate Fields add-ons also supports on Quick Create from Subpanel as well.
  • You can able to map multiple fields for auto fill up by configuration.
  • Auto Populate fields value based on related field using Mathematical and Logical functions(Addition, Subtraction, Multiplication, Add Month, Add Year, Sub Month, Sub Year etc)
  • Auto Populate fields value from Module Subpanel as well
  • Auto Populate Fields support Multi Languages
    (German,English,Spanish,French,Hungarian,Italian,Dutch,Portuguese,Russian,Ukrainian)

Functions syntax for Calculate Field

  • Add : add(field1,....): Returns the sum of given numbers in field. For e.g : add(1,5,3) = 9
  • Subtract : sub(field1, field2) : Returns the subtraction of given numbers in field. For e.g : sub(4,2) = 2
  • Multiply : mul(field1,...) : Returns the multiplication of given numbers in field, For e.g: mul(2,3) = 6
  • Divide : div(field1_numerator_field, field2_denominator_field) : Returns the field1_numerator_field divided by field2_denominator_field. For e.g: div(20,2) = 10
  • String Length : strlen(Stringfield) : Returns the total length of string. For e.g : strlen('SuiteCRM') = 8
  • Concatenation : concat(Stringfield,...) : Returns the string that results from concatenating the arguments. For e.g : concat(Auto, ,Populate, Fields) = Auto Populate Fields
  • Log : log(numberField,base) : Returns the logarithm of a number with applied base. For e.g : log(1000,10) = 3
  • Ln : ln(numberField) : Returns the natural log of a number. For e.g. : ln(10) = 2.302585
  • Absolute : abs(numberField) : Returns the absolute value of a number. For e.g : abs(-24) = 24
  • Average : avg(numberField,...) : Return the average of provided numbers. For e.g : avg(2,4) = 3
  • Power : pow(numberField1, numberField2) : Returns numberField1 raised to the power of numberField2. For e.g : pow(5,2) = 25. (by default the power will be 0).
  • Date Difference: date_difference(dateField1,dateField2) : Returns the date difference. For e.g : date_difference(17/05/2019, 20/05/2019) = 3 days
  • Percentage : percentage(numberField1,numberField2): Returns the field2 percentage of field1. For e.g : percentage(100,30) = 30
  • Mod : mod(numberField1,numberField2) : Returns the remainder (modulo) of field1/field2. For e.g : mod(20,3) = 2
  • Minimum : min(numberField,...) : Returns the minimum value passed in function. For e.g : min(2,5,0,1,-5) = -5
  • Negate : negate(Number n) : Returns the negative value of the number passed in function. For e.g : negate(8)= -8
  • Floor : floor(Number n) : Rounds a number DOWN to the nearest integer. For e.g : floor(2.1) = 2, floor(-7.1)= -8
  • Ceil : ceil(Number n) : Rounds a number UP to the nearest integer. For e.g : ceil(2.1) = 3, ceil(-4.1) = -4
  • Add hours : add(dateField, Hours): Returns the sum of given date and hours. For e.g : add(05/20/2019 11:00,5 hours) = 05/20/2019 16:00
  • Add day : add(dateField, Days) : Returns the sum of given date. For e.g : add(05/20/2019,1 days) = 05/21/2018
  • Add week : add(dateField, Weeks) : Returns the sum of given date. For e.g : add(05/20/2019,1 week) = 05/27/2019
  • Add month : add(dateField, Months): Returns the sum of given date. For e.g : add(05/20/2019, 1 month) = 06/20/2019
  • Add year : add(dateField, Years): Returns the sum of given date, For e.g : add(05/20/2019,1 year) = 05/20/2020
  • Sub hours : sub(dateField, Hours): Returns the sub of given date and hours, For e.g : sub(05/20/2019 11:00,1 hours) = 05/20/2019 10:00
  • Sub days : sub(dateField, Days): Returns the sub of given date, For e.g : sub(05/20/2019,1 days) = 05/19/2019
  • Sub week : sub(dateField, Weeks): Returns the sub of given date, For e.g : sub(05/20/2019, 1 week) = 05/13/2019
  • Sub month : sub(dateField, Months): Returns the sub of given date, For e.g : sub(05/20/2019, 1 month)= 04/20/2019
  • Sub year : sub(dateField, Years): Returns the sub of given date, For e.g : sub(05/20/2019, 1 year) = 05/20/2019
  • Diff days : diff(dateField1, dateField2): Returns the diff of given days, For e.g : diff_days(05/20/2019,05/21/2019) = 1 days                    
  • Diff hour : diff(dateField1, dateField2): Returns the diff of given hour, For e.g : diff_hours(05/20/2019,05/21/2019) = 24 hours                
  • Diff minute : diff(dateField1, dateField2): Returns the diff of given minute, For e.g : diff_minute(05/20/2019,05/21/2019) = 1440 minute
  • Diff month : diff(dateField1, dateField2): Returns the diff of given month, For e.g : diff_month(05/20/2019,06/20/2019) = 1 month                    
  • Week Diff : diff(dateField1, dateField2): Returns the diff of given week, For e.g : diff_week(05/20/2019,05/27/2019) = 1 week                
  • Diff year : diff(dateField1, dateField2): Returns the diff of given year, For e.g : diff_year(05/20/2019,05/20/2020) = 1 year

Getting started

Saving Comment Saving Comment...