Help & Support
Display Legacy Contents


Home > Impact Suite > Math > Math Syntax

Math Syntax

The Math formula's use Visual Basic as the syntax language. 

If [FIELD_A] <> [FIELD_B ]Then
    Return "TRUE"
    Return "FALSE"
End If

Compares two fields, if the are different true is returned.  If you want to see if two fields are the same use = instead of <>

RETURN (DateAndTime.DateDiff(DateInterval.Minute, [FIELD_A] , [FIELD_B] ))/60
Will return the difference in hours between two date fields

Get's the attached contacts full name.  This is usefull for custom tables.  The first or last name can also be retreived by using .firstname or .lastname instead of .fullname

Messagebox.Show("Database= " + HostFramework.CurrentDatabase)
Get's the name of the current database.

Messagebox.Show("Entity Is New = "+ SubEntityForm.GetIsNew.Tostring())
For a custom table this will return true if the record was just created

Messagebox.Show("EntityManager = " + SubEntityForm.GetEntityManager.ManagedEntity.Name)
Get the custom table entity manager.

Messagebox.Show("Record Manager = " + Durkin.Common.Classes.CustomSubEntity.GetFieldDescriptorByANYString("record Manager",SubEntityForm.GetEntityManager).getvalue(SubEntityItem))
Get's the record manager of the custom table record

See also

Article ID:
Views: 268
Created By: jimdurkin
Modified By: [Modified By]
Created Date: 3/24/2014 12:31 PM
Last Modified: 3/24/2014 1:47 PM
Print This Article
Email This Article
Previous Article
Next Article