Each table documentation record has AddField link which can be used to add calculated field.




 Result of clicking link AddField 

Form Filled with Data :

  Added Calculated Field

Formula used : concat(FirstName, ‘ ‘, LastName)

FullName now shows FirstName followed by LastName

and blank space between FirstName and LastName

 Adding CalculatedFieldsExtn involves first adding record into CalculatedFields as above

Formula for CalculatedFields is dummy data e.g. ‘FullName2’

Then record is added into CalculatedFieldsExtn


Check structure of table to find ColumnName to use in CalculatedFieldsExtn

Our ColumnName = FullName2_51963

Add record into CalculatedFieldsExtn

InString = ColumnName = FullName2_51963

OutString = Formula = concat(Contacts_MYCRM.FirstName, ‘ ‘, Contacts_MYCRM.LastName)

From TableDocumentation record Menu click CalculatedFieldsExtn link

result of CalculatedFieldsExtn for Contacts_MYCRM table is as following :

Full_Name is result of CalculatedFields

FullName2 is result of CalculatedFieldsExtn



For Any Question please Contact MyDataOrganizer