Previous Topic

Next Topic

Book Contents

Book Index

Custom Fields (Database Options)

QikKids provides a facility to add user defined fields to:

Up to 9 fields can be added for each type of record.

Custom Fields Details

Name

The name of the custom field. This will appear as the label for this field on the custom tab.

Attached To

Select the record type that the custom field will be added to.

Show On Accounts Screen

It the custom field is attached to a family record, ticking this box will show the custom field as a column in the family balances list.

Compulsory

Tick this box to make the field compulsory for all new records

Note: If you edit an existing record with a compulsory field that does not have any data, you will be prompted to enter a value for the compulsory field before the record can be saved.

Unique

Tick to enforce uniqueness checking on all newly added records.

Data Type

Choose from:

Keep History

Keeps an historical record of all changes to a field.

Log User Details

Stores audit details for the user that enters data into the custom field.

Allow Files

N/A.

Limit to List

Tick to restrict input in the custom field to the selection of items in the list. There should be one item per line.

ID

When writing custom reports you can retrieve this custom field by calling GetCustomData (). See Database Tables and Functions.

See Also

Options

General (Database Options)

Accounts

CCB (Database Options)

Display (Database Options)

Advanced (Database Options)

Petty Cash (Database Options)

Mail Server

Gateway (Database Options)

Maintenance (Database Options)

Rolls (Centre Options)

Receipts (Centre Options)

Advanced (Computer Options)

Database (Computer Options)

Debugging (Computer Options)

Birthday Notifications