Help & Support
Contents
Display Legacy Contents

Search:

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"
Else
    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

HostApplication.ApplicationState.CurrentContact.Fullname
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



Properties
Article ID:
math_syntax
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
Actions
Print This Article
Bookmark
Email This Article
Previous Article
Next Article