Difference between revisions of "Address Expressions"

From Keyfax Wiki
Jump to: navigation, search
(Created page with "{| class="wikitable" {+ Address Expressions !Expression !Databox Value !Result !Comments |- |AddrFull() |Inter•View Address question response |e.g. Mr P Graddon, 10, Station...")
 
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{| class="wikitable"
 
{| class="wikitable"
{+ Address Expressions
+
|+ style="text-align:left;" | Address Expressions
 
!Expression
 
!Expression
 
!Databox Value
 
!Databox Value
Line 25: Line 25:
 
|Name item from address (see 'Address Items' for a list of address field names - see below)
 
|Name item from address (see 'Address Items' for a list of address field names - see below)
 
|Item returns a named item from a multi-value DataSource such as an Address or an SQL data source returning multiple colunms where individual column values are returned using the column name e.g. Item("colName")
 
|Item returns a named item from a multi-value DataSource such as an Address or an SQL data source returning multiple colunms where individual column values are returned using the column name e.g. Item("colName")
 +
|}
 +
 +
{| class="wikitable"
 +
|+ style="text-align:left;" | Address Field Names
 +
!Field Names
 +
|-
 +
|Title
 +
|-
 +
|Inits
 +
|-
 +
|Surname
 +
|-
 +
|Forename
 +
|-
 +
|Department
 +
|-
 +
|Company
 +
|-
 +
|HouseNo
 +
|-
 +
|Address1
 +
|-
 +
|Address2
 +
|-
 +
|Town
 +
|-
 +
|County
 +
|-
 +
|Postcode
 +
|-
 +
|Country
 +
|-
 +
|ContactTel
 +
|-
 +
|Ext
 +
|-
 +
|Fax
 +
|-
 +
|HomeTel
 +
|-
 +
|WorkTel
 +
|-
 +
|MobileTel
 
|}
 
|}

Latest revision as of 12:25, 28 February 2018

Address Expressions
Expression Databox Value Result Comments
AddrFull() Inter•View Address question response e.g. Mr P Graddon, 10, Station Rd., Parkstone, Tel: 01202 733 767 The Address data is held in an XML packet
AddrMain() Inter•View Address question response e.g. Mr P Graddon, 10, Station Rd., Parkstone Formats comma separated list of address elements excluding then Name and any contact details Telephone nos, Fax and Email
AddrName() Inter•View Address question response e.g. Mr P Graddon Formats Title, Inits and Surname elements
Item("Name") Inter•View Address question response Name item from address (see 'Address Items' for a list of address field names - see below) Item returns a named item from a multi-value DataSource such as an Address or an SQL data source returning multiple colunms where individual column values are returned using the column name e.g. Item("colName")
Address Field Names
Field Names
Title
Inits
Surname
Forename
Department
Company
HouseNo
Address1
Address2
Town
County
Postcode
Country
ContactTel
Ext
Fax
HomeTel
WorkTel
MobileTel