Create the first filter: "Birthday is greater than January 31, 1962".
Create a second filter using "And" to
combine it: "Birthday is less than March 1, 1962".
How can I copy information from one database to another?
There is no single command to copy data from one database to another. Instead, you need to follow a two-step process of first exporting your data from one database to a file, and then importing that data from the file into the second database. If the two databases have identical structure, the process is very simple. If, as is more likely, the databases differ, consider the following prior to starting:
What data from the first database do I need in the second? You can create a view in the first database that contains all the data you need, and only the data you need. Then, export using that view.
How do the fields in the first database map to the fields in the second? It often helps to write down this mapping in advance, prior to starting the import operation.
How are the results of a search determined?
Search results are performed by doing a text search of all the fields in the database for which the Searchable property is enabled (read more). If a search is performed in the search box at the top right of your site, all records in the database are searched. If the search is performed from a view using the search box inside the database, only those records that match the view's filter are searched. In this case, the search is really a sub-search inside the view. If Advanced Search is used, any specific field in the database view can be searched.
Why didn't my file import correctly?
There are many reasons why data import may not work correctly. Here are some of the most common problems:
You can only import from a text file in either "tabbed-text" or "comma separated value" formats. Read more.
Be sure the First row contains field names setting matches the import file you are using. This setting is in step 1 of the import process on the first page. If your import file does not have field names in the first row, uncheck this box.
If data is turning up in the wrong fields, check your import field mappings. Read more.
A frequent source of import errors is failing to supply a value for a required field. You can fix this by entering the values into the text file, or by changing the database so that the field is not required.
To learn more about data import, click here.
Why don't my reports print out as they appear on the screen?
The reports make use of both background colors and images. If you use Microsoft's Internet Explorer, please make sure that the browser is configured to print using background colors and images. To turn on this option:
Select Internet Options from the Tools menu.
Select the Advanced tab.
Scroll down in the Settings: window until you can see the Printing section.
Check Print background colors and images.
Click OK.
How do I change the field type for an existing field?
Once you have saved a field, you cannot change the field type. If there is no data in the field, just delete the field and then recreate it with the field type you want. If there is data in the field that you wish to preserve, first export the data to a text file. Then, delete and recreate the field with the new type. Then, import the data back into the field.
How do I filter on a Checkbox field?
The value of a Checkbox field is either "True", if it is checked, or "False", if it is not checked. You can read more about filtering on Checkbox fields in the Field Types help.
How do I filter on a Date field?
The simplest method of date filtering is to use the "equals" or "not equal" operators and then select from one of the tailored date options in the dropdown that appears. Date filtering options include:
Exact Date
Days in the Future
Days in the Past
Today
This Week
This Month
Next Week
Next Month
Previous Week
Previous Month
In this instance, you could create a straightforward filter that displays all your records containing a purchase date of 12 days in the past, which would show today’s entries and two weeks worth of your purchase history.
Another method of date filtering is to make a comparison between two dates. For example, show all the items whose purchase date is before June 30, 2001. If you wish to compare the dates in your database with a specific date, use the appropriate comparison operator. The comparison operators you can use are:
is equal to
is not equal to
is less than
is less than or equal to
is greater than
is greater than or equal to
When using a comparison operator in a filter, you must use the date format mm/dd/yyyy. For example:
Purchase Date is less than 06/30/2001
The contains and does not contain operators work differently. When you create a filter that uses either of these two operators, you do not have to enter the entire date. You can use any part of the date string. You can use just the month, for example, to show only birthdays in the month of April. Be sure to enter the month in the correct format. That is, you must enter the month as Apr and not as 04. The filter for April birthdays would be:
Birthday contains Apr
You can also use containment operators to filter on the year portion of the date; however, you must use the Mon dd yyyy format, so would enter the year as 2003 and not as 03. And while it is possible to use the containment operator to filter on a specific date, it's better to use the "equals" or "not equal" operators, as these are specifically designed for date searching.
You can read more about filtering on Date fields in the Field Types help.
How do I filter on empty or NULL field values?
There are two filter operators that are designed to help you filter in or out blank, empty, or NULL fields value. The operator "is empty" will be true if the field value is blank, NULL, or empty. The operator "is not empty" will be true if the field value contains some data. Please note that a value that is just spaces, such as " ", is not empty. A good use of the "is empty" filter is to filter records where data has not been entered into a field.
How do I view records within a specified date range?
You can create a view with a filter that is the date range you wish to see. For example, if you wish to see all records where the Birthday field is in February of 1962, then:
Create the first filter: "Birthday is greater than January 31, 1962".
Create a second filter using "And" to
combine it: "Birthday is less than March 1, 1962".
Learn more about view filters.
How do I create a shared list?
To add a shared list field to your database:
On the Manage Database page, click Fields to display the Modify Fields page.
Click the New button in the Command Bar.
Set the basic properties for the field. When selecting the field Type, choose the List option from the drop-down list.
Continue setting your field properties as usual. For more information about setting these properties, click here.
In the Additional Properties section:
|
Choices |
Select the Create new list option. Enter your list choices in the box provided. Be sure to put each choice on a separate line. |
|
Options |
Share list with other databases indicates whether to make the list accessible to other databases. When a list is available to other databases, it will appear in the set of existing lists for List fields. |
|
Display Format |
Indicate whether to display this field as a drop-down list or as a group of radio buttons. If this field is displayed as a group of radio buttons, the field must be required. |
Click Save.
How much data can I store in the database?
There is no limit to the amount of information you can have in a database.