Matching

Syndicate content

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:

February 5th, 2009 - 6:02 PM

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 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())

February 5th, 2009 - 6:02 PM

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]

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

© 1997-2012 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit