XpressDox will insert a Word hyperlink into the assembled document. «InsertHyperlink(‘Our Company Web Site’,’www.abccompany.com’)» will put the text ‘Our Company Web Site’ into the document, underlined and coloured to look similar to a hyperlink inserted manually, and, when the user selects to open the link, will open the web page
Particularly in a situation where users of a template might want to use numeric values input according to different regions, this command can be used by the template author to make sure that template runners may not use the thousands separator when capturing numeric data in the interview.
This command is part of the XpressDox arithmetic feature set, and is explained in a better context in Arithmetic in XpressDox.
This is the command that is fundamental to ensuring that XpressDox arithmetic features apply regardless of the format of numbers specified in the Windows Control Panel or chosen by the user. A full explanation of this and related commands will be found in the Cookbook article Arithmetic in XpressDox.
This function can be used in more advanced arithmetic calculations, such as: If the side of a square is «Side» then the area will be «RaiseToPower(Side,2)». The second parameter does not need to be a constant or an integer, but can be a data element or other expression resulting in
If you have the command «WriteTimeStampToDataSet(Yes)» in the template, then when the document has been assembled, a data element containing the start and end times and elapsed time of the assembly operation will be written to the dataset.
The Command Editor empowers the template author by presenting an alphabetic list of all the XpressDox commands, with functionality which provides wizards for completion of the command as well as supplying examples of commands.
February is always a problem in that its last day depends on whether the year is leap or not. XpressDox has the LastDayInMonth function to assist with this. All that is required is to provide the function with a date and it will return the last day of the month in
This command enables the insertion of graphics from a file into the merged document. The picture is inserted into the document at the point where the command is encountered, and the size of the image is included in the command, for example: «IncludePicture(images:Logo.jpg,0.8in,0.8in)» or «IncludePicture(images:Logo.jpg,2cm,2cm)» The first measurement is the
You may have a situation where you have conditions that depend on the value of a data element during the lifetime of the interview. For example, the condition on an OnExitSet command, or a ReadOnly with a condition. This would be the case, for example, with a data source which
A Data Sheet can be merged for a template, showing just the data elements and their values. The link Data Sheets has a full description of the functionality around data sheet templates. The merging of a data sheet can be controlled by the user who runs the template, by including
You have a template which needs to capture and use a NINO (National Insurance Number) as described in NIM39110 – National Insurance Numbers. You would like to make sure that the value captured in the interview is a valid NINO. This can be done using the following Rule command: «Rule(NINO,soft,IsRegexMatch,’^[A-Z]{2}[0-9]{6}(A|B|C|D)$’,’The
PrefixWith This function is particularly useful in the situation where, say, you have an address consisting of data elements AddressLine1, AddressLine2, AddressLine3, and AddressLine4, but that perhaps lines 2, 3 and 4 are empty. Further, you want to present the address in a single line, with the different AddressLine data elements separated by commas. You
This function can be used to test the existence of a file. An example would be something like: «SetV(‘fileName’,concat(Directory,’\ExtraTemplate.xdtpx’))» «If(FileExists(GetV(‘fileName’)))» «MergeTemplate(GetV(‘fileName’))» «End(if exists)» This will construct the name of a file in the XpressDox variable named ‘fileName’, and, if the file exists, issue the MergeTemplate command for it.
These two commands address some of the frustration involved in trying to include or exclude columns and rows in a Word table. REMOVECOLUMNIF It is almost impossible to think of a way to tell XpressDox to include a column in a Word table using «If(condition)» and «End()» to delimit the column boundaries.
If you have calculated (or been supplied) an elapsed time in seconds, then you can format that into a nicely legible format without having to divide by 60 for minutes, etc. «FormatSeconds(‘3675′,’HH:mm:ss’)» will render as “01:01:15” Another example would be: «ChooseUsingTimePicker(StartTime)» «ChooseUsingTimePicker(EndTime)» The time I spent was «FormatSeconds(SecondsBetween(EndTime,StartTime),’HH:mm:ss’)» You could make
The command searches the template for any fillpoint which directly inserts text into the assembled document, and “paints” it with the specified color. Command structure: «PaintInsertedText(Yes,Blue)» Examples of usage: «PaintInsertedText(Yes,Red)» «Owner» (“Owner”) agrees to rent the property situated at «Property_Address» to «Renter» (“Renter”) for the term of this
Use one template to generate a letter to each of a set of clients whose contact details are saved in a database.
XpressDox has a powerful Relevance Engine which hides or shows controls (those areas where data for data elements are captured) on the interview. Take the following snippet: «ChooseFromRDBList(PartyType,Individual,Company)» The party is: «Name» and the «If(PartyType = ‘Individual’)»Identity Number is «IDNumber»«Else()»Company Number is «CompanyNumber» and Discount is «Discount»«End()» If the user chooses ‘Individual’
Please note that with effect from version 11.3, this function has been superseded by the RepeaterPosition function. For backward compatibility the use of PositionOfRepeater is supported, but is discouraged. Consider the commands OnExitSet and OnEnterSet. These commands are only executed during the lifetime of the interview, and also contain conditions
XpressDox can be directed to save the assembled document as HTML by using the following command anywhere in the template: «SaveAsHTML(Yes)»
In most cases after a template is run, XpressDox will save the Data Set (i.e. the XML file containing the data). Sometimes you might want to suppress the saving of the the data set. For example this might be when all the data for the data set are sourced from
When concatenating strings together (see Concatenating Strings), it is not always easy to visualize what the end result will look like. This is especially the case when the strings being concatenated are a mixture of fixed text and values of data elements and functions. This situation often arises when using
The InsertFormattedText command will accept HTML text as input, convert it to an XpressDox document and then include it as if it were done with an IncludeTemplate command. Sometimes the data in a data element is not an entire HTML document, but a snippet. This snippet then needs to be
Sometimes there are just too many choices of paragraph or clause to be included or excluded from a document. Using If and Else commands is inappropriate when there are hundreds of combinations. XpressDox has the powerful InsertDocument command to handle just this situation – where the user running the template chooses which clauses should be inserted.
901 S MoPac Expressway, Building 1, Suite #300, PMB 300127, Austin, TX, 78746, USA
85 Tottenham Court Road, London, W1T 4 TQ, UK
35 Anderson Road North, Cape Town, 7550, Western Cape, South Africa
Copyright ©2023 XpressDox. All Rights Reserved. | Website By Hello Fascination
