Difference between revisions of "Address Expressions"
From Keyfax Wiki
(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" | ||
| − | + | |+ 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
| 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") |
| Field Names |
|---|
| Title |
| Inits |
| Surname |
| Forename |
| Department |
| Company |
| HouseNo |
| Address1 |
| Address2 |
| Town |
| County |
| Postcode |
| Country |
| ContactTel |
| Ext |
| Fax |
| HomeTel |
| WorkTel |
| MobileTel |
