302 Found

Found

The document has moved here.

Matching

Syndicate content

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.

February 5th, 2009 - 6:02 PM

1. In a new report or an existing one, create a custom calculated column. To do so, click on 'Custom columns' in the 'Columns' section. Once you've added all the columns you'd like to display on the report, check off the box next to 'Define a calculated column.'

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

February 5th, 2009 - 6:02 PM

1. In a new report or an existing one, create a custom calculated column. To do so, make sure that 'Custom columns' is selected in the 'Columns' section. Once you've added the normal columns you'd like to appear on the report, check off the box next to 'Define a calculated column.'

Set the field 'Type' to 'Duration,' and enter the following in the Formula box:

February 5th, 2009 - 6:02 PM

1. Choose a table from the Table bar.
2. Click REPORTS & CHARTS to open the reports panel, then click + New.
3. In the dialog, select Table and click Create.
4. In the Columns section, choose Custom columns and click and drag each column you want to include under Report columns.
5. Check Define a calculated column.

February 5th, 2009 - 6:02 PM

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'}

February 5th, 2009 - 6:02 PM
302 Found

Found

The document has moved here.