Skip to main content
Try for free

Bonus Columns

Bonus columns are custom fields you add to a type of record, such as parts, customers, quotes or vendors. Use Bonus Columns to add one, change its title or default, or drop it.

Updated Nov 9 2026

Bonus Columns

Allow external media cookies to watch this video.

Before you start

  • Bonus Columns is under Admin > Maintenance and needs the Can Edit Maintenance permission (the Maintenance role by default). Without it, Cetec sends you to the home page with "Admin users only!".
  • Plan the field first: a title users will see, a technical name with no digits in it, and the data type. A field's data type can't be changed after it is added.
  1. Choose the record type

    1. Go to Admin > Maintenance > Bonus Columns. The page is headed Add Bonus Columns.
    2. Find the record type in the Type column. Has Bonus Columns shows how many active bonus columns that type already has.
    3. Click the type (for example Part). The Bonus Columns For type page opens.
  2. Add a bonus column

    1. On Admin > Maintenance > Bonus Columns, click the record type. The Bonus Columns For type page opens; its first table row is for the new column.
    2. In that row, type the Title(displayed to user) and the Technical Name (the unique name used behind the scenes; no numbers, so write "twenty", not "20"). If you leave Technical Name empty, Cetec builds it from the title. Cetec adds _bc to the end, so color is saved as color_bc.
    3. Pick the Data Type: Text, Up To 50 Chars, Text, Up To 100 Chars, Check Box (Check For 'Yes'), Select Box, Multi-Select Box, Date, Radio Buttons (Check 'Yes' or 'No') or Textarea (large text input).
    4. Optionally type a Default Value (the box says (required, displayed to users), but it can be left empty). It fills every existing record when the column is added; changing it later only affects new records.
    5. Click Add New. Cetec shows "bonus columns created" and lists the column below.
  3. Change or drop a bonus column

    1. On Admin > Maintenance > Bonus Columns, click the record type.
    2. In the column's row, change the Sort Order, Title(displayed to user), Searchable? or Default Value. For a Select Box or Multi-Select Box column, type the choices in Select Options (comma separated) under the row, and tick Unset Option ? to offer an empty choice.
    3. To remove a column, tick Drop ? on its row.
    4. Click Update at the bottom of the table. Cetec shows "bonus columns updated".

Related

How-tos
Blog Posts
Docs