Edit an Export to Word Template

Applies to
Note
Templates are managed in eWay-CRM Online and are then available in both eWay-CRM Online and eWay-CRM Desktop.

Contents

  1. Download a Template
  2. Edit the Content
    1. Insert data from the item
    2. Data from Related Items
    3. Tables with Items
    4. Add an Image
  3. Upload a New Template

Download a Template

  1. Open eWay-CRM Online > Settings > Templates.
  2.  

  3. Select a module, for example Bookkeeping.
  4. Select module

     

  5. Click the Download button next to the template.
  6. Download template

     

  7. Open the file in Word.
  8. Template in Word

Tip
If the template cannot be downloaded (which may happen with custom templates), open in eWay-CRM the item from which you want to create the template (e.g., a document, project, or company). Right-click it, select Export to Word, and choose the desired template. This will generate a file with live data, where you can fill in the placeholder fields.

Edit the Content

Insert data from the item

  1. Find the place where you want to insert data from eWay-CRM – for example, in the document header or the body of a quote.
  2.  

  3. Insert a placeholder. Placeholders are replaced by real data during export. The most common format is: $CURRENT_ITEM[FieldName]. For example, $CURRENT_ITEM[ValidUntil] will display the proposal’s expiration date. Learn more about placeholders in the article Create and Edit Templates.
  4. Note
    When writing the field name in the template, always use the correct capitalization — otherwise the placeholder will not work. For example, write FileAs, not fileas or Fileas.

    Placeholder

     

  5. If you don’t know the database field name you want to insert, hover the mouse over the field name in eWay-CRM Online – a tooltip will show its database name.
  6. Tooltip with database name

     

  7. Or open Admin Center > Fields, select the module (e.g., Bookkeeping), and copy the name from the corresponding column. This makes it easy to insert additional fields you want displayed in the template.
  8. Database name in Admin Center

Data from Related Items

  1. If you want to include data about a company or a contact person in the template, use this format:
    $Companies_CUSTOMER_RELATION_ITEM[CompanyName]

    For example:

    $Companies_CUSTOMER_RELATION_ITEM[CompanyName] – company name
    $Companies_CUSTOMER_RELATION_ITEM[VATNumber] – VAT number
    $Contacts_CONTACTPERSON_RELATION_ITEM[FirstName] – contact’s first name

Tables with Items

  1. If you want to list all items in a proposal (for example, a list of products), use a table. Insert placeholders into the cells, for example:
  2. $GoodsInCart_GOODSINCART_RELATION_ITEM[ItemName]
    $GoodsInCart_GOODSINCART_RELATION_ITEM[Quantity]
    $GoodsInCart_GOODSINCART_RELATION_ITEM[TotalPrice]

    CodeNameQuantitySales PriceTotal Price
    $GoodsInCart_GOODSINCART_RELATION_ITEM[Code]$GoodsInCart_GOODSINCART_RELATION_ITEM[FileAs]$GoodsInCart_GOODSINCART_RELATION_ITEM[Quantity] $GoodsInCart_GOODSINCART_RELATION_ITEM[UnitEn]$GoodsInCart_GOODSINCART_RELATION_ITEM[SalePriceExcludingVAT] $GoodsInCart_GOODSINCART_RELATION_ITEM[SaleCurrencyEn]$GoodsInCart_GOODSINCART_RELATION_ITEM[PriceTotalExcludingVAT] $GoodsInCart_GOODSINCART_RELATION_ITEM[SaleCurrencyEn]
    Total$CURRENT_ITEM[PriceTotalExcludingVAT] $CURRENT_ITEM[CurrencyEn]

     

  3. eWay-CRM will automatically create as many rows as there are items in the proposal.
  4. Table with items

     

  5. If a column in Word cannot be narrowed, go to the Table Layout tab and select Fixed Column Width.
  6. Column width

Add an Image

  1. Insert any image into the template (even a vacation photo) and set its desired position, size, text wrapping, and so on.
  2. Any image

     

  3. Right-click it and select View Alt Text.
  4. Editing Alt Text

     

  5. Insert a placeholder into the field, for example: $CURRENT_ITEM[ProfilePicture]
  6. New Alt Text

     

  7. During export, your sample image will be replaced with the real image from eWay-CRM.

Upload a New Template

  1. Open eWay-CRM Online > Settings > Templates.
  2.  

  3. Select a module, for example Bookkeeping.
  4. Select module

     

  5. Select the template you want to replace or create a new one.
  6. Upload template

     

  7. Upload your edited .docx file.
  8. Warning
    If you are editing a template that you exported to Word from eWay-CRM Desktop, your file may have the .xml extension. You need to resave it in Microsoft Word as a .docx file.

     

  9. Confirm saving. Done! Now you can right-click a proposal, select Templates > Export to Word, and verify the result.
  10. Export item

Final Tips
If the code itself appears instead of the value, there’s a typo in the template (extra space, wrong case, etc.).
 
If nothing appears, the field in eWay-CRM has no value.
 
Template editing is available from version 9.3 and requires a license that includes template management.