How To Create Your Own Custom Fields
Add your own fields to Cetec records, for example a Conflict Free check box on parts. Cetec calls these custom fields bonus columns.Updated Nov 9 2026
Before you start
- Admin > Maintenance > Bonus Columns is shown to users with the Admin role. Without the Can Edit Maintenance permission, Cetec sends you to the home page with "Admin users only!".
- Plan the field first: the 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.
-
Add the field
- Go to Admin > Maintenance > Bonus Columns. The page is headed Add Bonus Columns and lists every record type you can add fields to.
- Click the record type, for example Part. The Bonus Columns For type page opens; its first table row is for the new field.
- Type the Title(displayed to user), for example
Conflict Free. This is the name users see. - Type the Technical Name, the unique name used behind the scenes (no numbers: write "twenty",
not "20"). If you leave it empty, Cetec builds it from the title. Cetec adds
_bcto the end (conflict_freebecomesconflict_free_bc). - Pick the Data Type for what the field will hold, for example Check Box (Check For 'Yes') for a yes/no field. The other types are Text, Up To 50 Chars, Text, Up To 100 Chars, Select Box, Multi-Select Box, Date, Radio Buttons (Check 'Yes' or 'No') and Textarea (large text input).
- Optionally type a Default Value. It fills every existing record when the field is added. The box says "(required, displayed to users)", but you can leave it empty; a check box then starts unticked (0).
- Click Add New. Cetec shows "Success: bonus columns created" and lists the field below.
-
Make the field searchable
- On Admin > Maintenance > Bonus Columns, click the record type.
- In the field's row, tick Searchable?.
- For a Select Box or Multi-Select Box, type the choices in Select Options (comma separated) under the row.
- Click Update at the bottom of the table. Cetec shows "Success: bonus columns updated".
The field is now offered as a filter on that record type's list. For example, go to Parts > Lists > Part List, click Filter or search…, type
Conflict, choose Conflict Free, pick Yes and click Apply (n) to see only conflict-free parts. -
Fill in the field
- Open a record of that type and edit it. For a part, open the part and click Edit in its left-hand menu.
- The new field is with the record's other fields; on a part it is in the General Information section. Set its value and click that section's Update. For a part, Cetec shows "Success: Part Updated successfully".