Table testing
From SmartWiki
This function will update a single transaction record.
Level 1
Application Name>
| Level 1 | Variable |
|---|---|
| level 1 name field | @name@ |
| level 1 type field | @type@ |
| level 1 status field | @status@ |
| level 1 start date | @startdate@ |
| level 1 end date | @enddate@ |
| level 1 contact | @contact@ |
| level 1 custom field | @customfieldname@ |
| Accounts | No variables |
| Activity List | No variables |
| Application Name | @name@ |
| Application Template Type | @type@ |
| Application Template Type Caption | @typecaption@ |
| Application Template Type Language | @type_lang@ |
| Archived | @archived@ |
| Branch | @branch@ |
| Branch ID | @branchid@ |
| Close Date | @closedate@ |
| Contacts | No variables |
| @name@ | |
| Application Template Type | @type@ |
| Application Template Type Caption | @typecaption@ |
| Application Template Type Language | @type_lang@ |
| Archived | @archived@ |
| Branch | @branch@ |
| Branch ID | @branchid@ |
| Close Date | @closedate@ |
| Contacts | No variables |
| Currency Name | @currencyname@ |
| Currency Code | @currencycode@ |
| Exchange Currency Name | @excurrencyname@ |
| Exchange Currency Code | @excurrencycode@ |
| Currency Exchange Rate | @exrate@ |
| Customer | @client@ |
| Description | @description@ |
| End Date | @enddate@ |
| End Time | @hour(fullenddate)@:@minute(fullenddate)@ |
| Folders | No variables |
| Modified By | @modifiedby@ (username); @modifiedbyid@ (userid) |
| Modified Date | @modifieddate@ |
| Owner (full name) | @owner@ |
| Owner (userid) | @ownerid@ |
| Person (full name) | @person@ |
| Person (userid) | @person.userid@ |
| Probability | @probability@ |
| Requirement | @requirements@ |
| Revenue | @revenue@ (to return unformatted number without comma separators, use @revenue.value@) |
| Start Date | @startdate@ |
| Start Time | @hour(fullstartdate)@:@minute(fullstartdate)@ |
| Status | @status@ |
| Status Caption | @statuscaption@ |
| Status Language | @status_lang@ |
Level 2
| Level 2 | Variable |
|---|---|
| level 1 name field | @name@ |
Level 3
|
[#(?object=contact;criteria=(roleid='10991' or roleid='10992');orderby=tbl_1359726.valuestr) Name : ~firstname~ ~lastname~<br /> Title : ~title~<br /> |
