UniformSoftware main content

Customization of Standard Fields

Template#: c4108

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.
408 KBDownload

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

Screenshot

The screen shot for Customization of Standard Fields

Detail

This sample shows how to change the definition of standard fields.

This sample is based on the Invoice Template with Long Product Description (c4020). Here are the steps to follow to change the standard fields:

  1. First, make sure you have made a backup of your current database file.
  2. Open your template as usual.
  3. Click "Customers" on the ribbon tab.
  4. Click "Custom Fields", and then "Advanced..."
  5. If you have not backed up your database file yet, click "Backup Database" to do so now.
  6. From the "Database Table" list, choose the table you want to modify. The "Fields" section shows the fields defined in this table.
  7. Double-click the field you want to modify, or click to select the field, and then click the "Customize" button.
  8. Click OK to apply the modification.

Note that if you change the size of the text field, you may also need to change the data validation of the corresponding cell. For example, if you change the size of the customer name field to 80, to change the data validation of the Excel cell, follow the steps below:

  1. Push down the "Design Mode" button on the ribbon tab.
  2. Click and choose the customer name cell that is named "oknWhoName".
  3. Go to the "Data" ribbon tab. Click "Data Validation".
  4. Specify the new validation. In this case, you just need to modify the "Maximum" field to 80.
  5. Exit design mode.
  6. Save the template.

Format and Specification

Template#c4108
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns4
Lines6
Line Height (Points)39.75
Print Area$E$2:$N$44
Papaer OrientationPortrait
Default Margins (Points)
Left36.00
Right36.00
Top77.76
Bottom88.56
PriceFree