WebData Pro Tutorials: Multi-Value Fields (AKA "repeatable" fields)

WebData Pro will allow you to enter multiple values within a field by utilizing the comma as a delimiter. When using a textbox field or a comment field, separate each value using a comma. In certain cases (see below), you may also need to enclose each value within quotation marks. Several examples are provided below.

IMPORTANT NOTE:

When creating a field that will hold multiple values, YOU MUST make sure that the maximum character length for the field is large enough to accomodate ALL of your values. If the maximum character length for your field is not large enough to accomodate your longest record, then truncation will occur when you input your records, which will result in problems.

So when defining a field that will contain multiple values, consider the total length of the longest possible record, and make sure your field is long enough to accomodate that record. In order to do this, you'll need to plan your records and your field values in advance, or alternatively choose a relatively large maximum character length when defining the field in order to accomodate possible uncertainty.

For example, if you have a record with seven comma-separated values and the total length is 70, then your field must at least accomodate a maximum character length of 70 characters. Otherwise truncation will occur when you input that record.

EXAMPLE #1: Multi-Value Color Field

STEP 1: Create a textbox field named "color" and add the following three records:

STEP 2: Create a search layout which includes the color field, and then use the search layout to run the following searches:

EXAMPLE #2: Multi-Value Author Field

When adding multiple authors to a single field, you may use a comma between the values, but also be sure to enclose each author's name in double-quotes. This will allow you to use commas and apostrophes within each author's name, as well as other special characters. Your data is being stored in Unicode and so hopefully you should be able to use a wide range of special characters in the author's name. If you run into any problems with particular special characters, then please report the problem using the WebData Pro Tech Support form.

Here is an example of a multi-value author field.

STEP 1: Create a textbox field named "author" and add the following four records:

STEP 2: Create a search layout which includes the author field, and then use the search layout to run the following searches:



A SCHOOL WITHIN THE COLLEGE OF APPLIED SCIENCES AND ARTS