Custom Fields Dialog
In this dialog box you can add custom fields to the current database tables Orders, Customers and Products. These custom fields will be added to the respective tables, and you can add/edit information for them using Order Edit Dialog and Product Edit Dialog. Custom fields are designed to enable you to store custom data which couldn't be stored in the existing table fields.
n order to add a new custom field, click on the Add button, and fill in the field's properties:
- Field Name - defines the name of the field. Don't use spaces and other special characters for the field name.
- Field Type - defines the type of the field. The types allowed are listed in the combo box drop down list for this property.
- Table Name - defines the table where this custom field will be added.
- Parser ID String - defines the parser identifier for this field. You can leave this empty if the parser shouldn't try to automatically find the value for this field when parsing orders. If you provide the value for this property, be sure to adjust the Parser Indicators settings, so as to allow the parser to retrieve the value for this field from the order source. When parsing Boolean fields any njn-empty value except: 0, No and False will be treated as True.
- Influences to order value by - available only for currency custom fields in the Orders table, and shows how the value of this field changes the total value of the order. It is useful for dealing with additional charges that are taken from the order and not handled by RegKeeper's standard fields; such as State Taxes, Affiliate Charges and others.
- Field order - indicates the order of appearance for this field and also the order of applicability. This means that fields with a lower order will apply earlier than those with a higher order to the Total value of the order, if applicable.
- Description - allows you to input the description of this custom field. To read the field's description just click on the button with ? near the field in View Order or Product Details dialog.
- Default Value - indicates the value to be used by default for this custom field.
After you have set the field's properties, click on the Apply button to store your custom field into the database structure.
In order to delete the custom field from the database, select it in the list and click on the Delete button.
When adding or deleting custom fields, RegKeeper will close the current database and re-open it in order to apply your changes. It is not possible to edit custom fields, therefore in order to change any information in a custom field, you will need to delete it first and then re-create a new one.