Customizing database fields
Contacts, records, and fields explained
Everyone in your Wild Apricot database is a contact. A contact can be a member, an event attendee, a donor, a newsletter subscriber, or any combination of these roles.
Contacts can be added automatically through your website, added manually by an administrator, or imported in bulk.
Information about each contact is stored in a separate record, with each record storing different chunks of information in fields (e.g. first name, last name, email address).
You can customize your contact database – and your forms – by adding, modifying, reordering, and deleting database fields.
In addition to their contact record, each contact can also have a membership record, and one or more event registration records or donation records.
Common vs specialized fields
Wild Apricot database fields are divided into two classes: common fields – fields that apply to all records (e.g. first name, last name, email address) – and additional fields that only apply to membership applications, event registrations, or donations.
Each record is a combination of common fields and fields specific to that type of record. For example, a membership record will consist of membership fields and common fields, while a donation record will consist of donation fields and common fields.
The forms that appear to the user – and are used to create records – also combine both types of fields. A membership form, for example, will display both common fields and membership fields.
To customize a form, you can add or remove fields, either common fields or fields specific to the form.
The values entered in common fields on membership application forms will update the corresponding fields in the applicant's contact record (if one already exists), but the values entered in common fields on event registration forms are stored separately from the contact record within event registration records. Similarly, the values entered in common fields on donation forms are stored separately within donation records.
Adding and modifying database fields
You can add any number of common fields or other database fields.
You can set membership fields to apply only to members at specific membership levels. Since common fields are automatically added to all forms (membership, event, and donation forms), fields that apply to all forms should be created as common fields.
To view, modify, or add common, membership, donation, or event fields, follow these steps:
Common fields under the Contacts menu
Membership fields under the Members menu
Donation fields under the Donations menu
Registration form tab from the event's details page.
From the screen that appears, you can add, modify, reorder, and delete fields. Any changes you make will be immediately reflected on screen but will not be applied elsewhere until you click Save all changes. Once your changes are saved, they will be reflected on applicable online forms, contact records, and directories.
Adding a field
To add a new field from the Customize fields screen, click Add new field.
Modifying a field
To modify an existing field, click it within the list.
Deleting a field
To delete a field, click it within the list, then click the delete link on the right.
After you delete a field, it appears crossed out in the field list until you save your changes.
While the field appears crossed out, you can restore it by clicking the restore link.
To change the order in which fields appear, you can drag and drop fields within the list, or you can click the green up and down arrows beside a field.
You can only choose the field type when you create a new field. You cannot change the type for an existing field.
The following field types are available:
Simple text field, used for short entries (up to 200 characters).
Used for longer text entries (up to 3,000 characters).
A set of checkboxes (up to 100 characters per item). For instructions on adding choices, see Adding choices to multi-option fields below.
A set of mutually exclusive choices (up to 100 characters per item), arranged like buttons on a car radio. For instructions on adding choices, see Adding choices to multi-option fields below.
Multiple choice with extra charge
(Event and membership fields only) Allows you to provide optional extras (displayed as checkboxes) at an additional cost. For more information, see Extra membership costs and Extra event registration costs - dynamic event pricing.
Radio buttons with extra charge
(Event and membership fields only) Allows you to display a set of mutually exclusive options at an additional cost. For more information, see Extra membership costs and Extra event registration costs - dynamic event pricing.
|Extra charge calculation||( Event and membership fields only ) Provides the ability to order multiple items, or to charge an additional fee proportional to a value entered by the applicant or registrant. For organizational members, you might want to charge an extra fee based on their revenue, number of staff, or grants they've received. For more information, see Using the extra charge calculation field (below).|
A set of mutually exclusive choices, arranged in a drop-down list. For instructions on adding choices, see Adding choices to multi-option fields below.
(Common and membership fields only) Used to display a photo, company logo, or online avatar. For more information, see Adding member or contact pictures.
Rules and terms
Displays a calendar control that can be used to select a date.
Used to group and separate fields. The field label you choose will appear as a section heading, but only if there are fields below it.
You can change field settings for new and existing fields. Field settings appear when you click a field within the list.
The following settings are available for one or more field types:
The name used to identify the field, or the label for the section divider. You cannot use the same name as a common field.
All except section divider
Controls whether the field has to be filled out before the form can be submitted. For all self-service online forms, (member application, email subscription, donation, and event registration), the Email field is always required.
For administrator access only
All except section divider
Identifies this as an internal field that can only be seen or edited by an administrator. For more information, see Internal use fields.
Multiple choice, radio buttons, dropdown
Choose the options to be displayed. For more information, see Adding choices to multi-option fields below.
Extra charge membership fields
Indicate whether to include in new membership application forms. If enabled, you can also control whether the cost should be prorated over a partial period of time.
Extra charge membership fields
Indicate whether to include in membership renewal form. If enabled, you can also control whether members can change their original selection when renewing.
All membership fields except section divider
Controls whether the member is allowed to view or modify this field. The following choices are available:
All except section divider
Controls who is allowed to view this field. This is a default setting which can be changed by each member. For more information, see Member privacy settings.
All membership fields except
Determines whether the field applies to all membership levels or is restricted to one or more specific membership levels. For more information, Creating fields for different membership levels.
Amount donation field
Allows you to control how the donor indicates the donation amount. For more information, see Donation forms.
|Multiplier||Extra charge calculation||Determines the value to be applied to the visitor's entered value, and whether the multiplier is the unit cost or a percentage. For more information, see Using the extra charge calculation field (below) .|
|Limit order to||Extra calculation||For extra charge calculation fields where the multiplier is the unit cost, determines the minimum and maximum number of items that can be ordered. For extra charge calculation fields where the multiplier is a percentage, determines the minimum and maximum resulting charge. For more information, see Using the extra charge calculation field (below) .|
All except section divider
Instructions explaining how to use this field. For information on controlling the appearance of field instructions, see Adding field instructions.
Making fields required or mandatory
If you want to make a field required or mandatory, so that the field has to be filled out before the form can be submitted, click the Required field checkbox within the field settings. For all self-service online forms, (member application, email subscription, donation, and event registration), the Email field is always required.
Adding choices to multi-option fields
When you create a field using the Multiple choice, Radio buttons, or Dropdown type, you add items that represent choices for the user.
(Extra charges fields use a different approach. For information, see Extra membership costs and Extra event registration costs - dynamic event pricing.)
Using the Items text box, you add one item per line, up to 100 characters per item. (Press Enter on your keyboard to move to the next line). You can also paste text from another program to speed up text entry.
There are some pre-defined lists that you can use to add large sets of choices:
- U.S. states
- Canadian provinces
To use one of these lists, select the one you want to use from the list box labeled Select pre-defined value to insert then click Insert.
Once you are finished populating your list, click Done to save your list. You still need to click the Save all changes button at the top of the screen to finalize all the changes to this and any other fields you might have added or modified.
After you click Done, new options appear to allow you to manage your list.
The following options apply to the entire list:
Sorts the list by alphabetical order. The first click will sort it from A to Z. A second click will sort it from Z to A.
Add multiple items
Opens a window with a text box where you can multiple items one line at a time. Existing items will not appear in the list. New items will be added to the bottom of the list. You can move them individually or use the Sort button to re-sort the list.
Removes all items from the list.
If you click on an item within the list, you can change its text. As well, the following options now appear beside the item:
Moves the item up or down within the list.
Add a new item below the selected one. You can also add a new item to the bottom of the list by clicking on the Add new item link at the top of the item list.
Removes the item.
Select/deselect the item as the default choice. Radio buttons and drop-downs can only have one default selection, while checkboxes can have multiple items selected by default.
Using the extra charge calculation field
The extra charge calculation field is similar to the multiple choice with extra charge field and the radio buttons with extra charge field, but allows you to specify a unit cost for multiple orders, or apply a percentage to charge dynamic fees based on some factor.
For example, you might want to provide an option to purchase any number of t-shirts, or charge a variable membership or event fee based on organization size or income.
The unit cost or percentage is applied to the value entered by the applicant or registrant in the membership application form or event registration form.
The first step in setting up a calculated extra charge field is to choose whether to specify a unit cost or a percentage to be applied to the entered value. To do so, click the dropdown that initially displays the currency you choose in your online payment settings ...
...and choose the currency if you want to specify a unit cost, or percent if you want to apply a percentage to the entered value.
If you choose the currency so you can specify a unit cost, you can also specify the minimum and maximum number of items you visitor can order.
Values below the minimum or above the maximum will not be accepted.
If you are applying a percentage, you can specify a minimum and a maximum resulting value.
Values entered by the applicant or registrant that result in charge below the minimum or above the maximum will be automatically adjusted to fit within the limits.
Using the rules and terms field
Adding it to a membership form, for example, allows you to require applicants to acknowledge certain policies before applying for membership.
Restricting fields by membership levels
You can restrict membership fields to specific membership levels.
To restrict a membership field to one or more membership levels, follow these steps:
- Select the field within the list of membership fields.
- Under Use in, click Selected levels.
- Check each of the membership levels you want this field to apply to.
A lock icon will appear to indicate that the field is restricted to particular membership levels.
To quickly review which fields belong to what level you can filter the membership fields by membership level. You can display all fields, fields for a particular membership levels, or fields common to all membership levels.
Internal use fields
You may want to track information about your contacts without sharing the information with them or anyone else. To do so, you can set a field as internal use only.
- You want to track whether people attended the events they have registered for, so you create a field called Event attended and mark their attendance in the field on their Event registration details screen.
- You want to recruit more female members, so you add a field called Gender to track this information.
You can make any common or membership field you create an internal use field by setting access to For administrator access only (for common fields) or Internal use only (for membership fields).
Administrator-only fields are displayed under Internal use on the Contact details screen. You can click the Edit button to modify internal use field values for a contact.
Any time a contact fills out an application, records a donation, or registers for an event, the internal use fields and their values for that contact are copied to the registration, application, or donation record.
The following fields cannot be set as internal use only:
- User Id (aka Member Id)
There is no easy way to change the field type after creating a field. However, the following workaround can achieve this goal.
- Export your entire contact list to Excel. Though no changes are necessary to the export file, we recommended that you re-import only the User ID and the specific field(s) you want to update. All other columns/fields in your Excel file can be deleted.
- Within Wild Apricot, delete the field you want to change and save your changes.
- Create a new field with the same name as the deleted field, but with the field type you want, and save your changes. (Make sure the field name is not used anywhere in your system e.g. for an event field or a donation field.)
- Import the Excel file you created in Step 1.
On this page:
- Contacts, records, and fields explained
- Common vs specialized fields
- Adding and modifying database fields
- Field types
- Field settings
- Making fields required or mandatory
- Adding choices to multi-option fields
- Using the extra charge calculation field
- Using the rules and terms field
- Restricting fields by membership levels
- Internal use fields