1. In a new report or an existing one, create a custom calculated column. To do so, click on "Custom Options" in the "Additional Options" section and check off the box to "Define a custom formula column for this view".

In the expanded area of this section, set the field "Type" to "Checkbox". Enter the following in the Formula box:

To accomplish this, you'd design your report with a custom formula field that combines values in all three contact fields and then (though they won't know it) let users search that field.

For reports with grouped data, clicking a column heading sorts the data within each group based on the selected column. It does not change your groupings.

QuickBase doesn't set the width of columns in reports. Since the program has no way of knowing what font and font size a user's browser is configured to, we leave it to the browser to determine the appropriate widths for each column and the appropriate width for the entire view. Usually the browser does a pretty good job of this.

1. In a new report or an existing one, create a custom calculated column. To do so, click on "Custom Options" in the "Additional Options" section and check off the box to "Define a custom formula column for this view".

In the expanded area of this section, set the field "Type" to "Duration". Enter the following in the Formula box:
[Start Date] - FirstDayOfMonth(Today())

1. Create a new view or edit an existing one. On your Repot Builder screen, click on "Custom Options" in the "Additional Options" screen. Check the "Define a custom formula column for this view" box to further expand this section.
2. In the "Type" drop-down list, select "Checkbox."
3. In the "Formula" box, enter the following formula:
[Field 1]=[Field 2]

You have a choice of Normal (HTML), Plain Text, Comma Separated Values, Tab Separated Values, or XML. To change your view output format:

1. On the overview page of your application, click on the "Customize" drop down list and select "Views".

2. Click the view's name you want to modify.

3. Under the "Additional Options", click on "Custom Options" to expand the section.

In the following query:

query={'8'.OAF.'3-13-02'}AND{'8'.OBF.'4-13-02'}

I am asking QuickBase to return me only the events that contain the dates
between 3-13-02 and 4-13-02. Is it possible to ask for the events that contain the dates between 'todays date' and 'todays date+5'?

Yes the way to do this is as follows:

query={'8'.OAF.'Today'}AND{'8'.OBF.'-5%20days%20ago'}