LastDayInMonth – XpressDox
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
Tutorial videos are available here.
Visit our User Forum for discussions and solutions
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
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
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
The XpressDox Rule command can be used to validate a NINO in a template. You have a template which needs to capture and use a NINO (National Insurance Number) as described in NIM39110 –
The When command can be used when the text to be included or excluded is small, is text only (i.e. contains no further data elements) and requires no MS Word formatting. Example 1: Plurals This fax
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 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
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 =
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.
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
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
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
If you want to compare two dates, then typically you want to know whether one date is later than another. The default way that dates are stored in XpressDox is in the format yyyy-MM-dd (e.g.
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.
Suppose you have defined a set of folders to contain clauses for insertion using the My Clauses or Shared Clauses features in the XpressDox ribbon. Normally you would group clauses together into folders containing clauses
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
Using the IsTrue function in Document Logic in your XpressDox template When an XML dataset is sourced from a data source, or perhaps from an XML text file which has been populated by user
Increment a date by a certain number of days, months or years. Command structure: «IncrementDate(DateOfBirth,25, “y”)» The above will add 25 years to the value in the data element ‘DateOfBirth’. Some simple examples:
Embed a spreadsheet into an assembled document Using the IncludeSpreadsheet command, you can embed a spreadsheet into the assembled document. This uses Microsoft’s OLE technology, which means that when you view the assembled document
Now() inserts the current date and/or time into the document. It can be formatted in the same way as FormatDate. Command structure: «Now(“d MMMM, yyyy”)» Examples of usage: «Now(“d MMMM, yyyy”)» yields “2
The fillpoint «SecondsBetween(Later,Earlier)» will return the number of seconds between the value in data element Later, and that in Earlier. For example: The race started at «ChooseUsingTimePicker(StartTime)»«FormatTime(StartTime,’hh mm tt’)» and ended at «ChooseUsingTimePicker(EndTime)»«FormatTime(EndTime,’hh mm tt’)».
When there is conditional logic in a template which removes or adds text, then some of the Word constructs such as Word fields (like page numbers and other fields) are not updated automatically. Normally user
Today inserts the current date into the document. It can be formatted in the same way as for FormatDate. Command structure: «Today(‘MMMM d yyyy’)» Examples of usage: A template run on the
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