UniformSoftware main content

Consultant Template Sample: New Company Name Field

Template#: c4048

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
436 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

The screen shot for Consultant Template Sample: New Company Name Field

Detail

This form demonstrates how to add a new field, "Company Name", to an existing template.

This template is based on the Simple Consulting Invoice Template (c4034).

  1. Backup your template.
  2. Open the template in Excel.
  3. Click the "Design Mode" button on the ribbon.
  4. Now click the heading cell of row 11, then choose "Insert". A new row is inserted between the rows that have the text labels "Name" and "Address".
  5. Enter the text "Company Name" into cell $I$11.
  6. Click the cell next to the label "Name" and then click "Format Painter" on the Excel Home ribbon tab.
  7. Click the cell $J$11. This pastes the format into the target cell.
  8. Enter the cell name "oknClientCompanyName" for $J$11. To do this, first make sure the $J$11 cell is selected, then click the name box on the formula bar, and then enter the cell name "oknClientCompanyName" (without quotes).
  9. Click "Design Mode" again to exit design mode.
  10. Click the "Customers" command on the ribbon tab.
  11. Click "Custom Fields".
  12. Click "Add Field".
  13. On the New Custom Field dialog box, define the new field as below:
    • Name: ClientCompanyName
    • Type: Text
    • Size: 100
  14. Click "OK" to create this custom field.
  15. Now it returns to the "Custom Field Manager" dialog box.
  16. From the "Database Table" drop-down list, choose "Invoice Header".
  17. Click "Add Field".
  18. On the New Custom Field dialog box, define the exact same field:
    • Name: ClientCompanyName
    • Type: Text
    • Size: 100
  19. Close the dialog boxes and return to the Excel sheet.
  20. Save your template.

Format and Specification

Template#c4048
Belongs to

Consulting

Format (XLS or XLSX).xlsx
Columns4
Lines6
Line Height (Points)30.00
Print Area$F$3:$N$46
Papaer OrientationPortrait
Default Margins (Points)
Left30.96
Right30.24
Top67.68
Bottom65.52
PriceFree