auto

Syndicate content

If you create a formula numeric type of field, you can reference the built in field Record ID # to increment your number automatically. If you're not familiar with creating new fields, please see our Add a New Field help topic.

 

June 23rd, 2009 - 8:06 AM

There is a way to do this using Application Variables and a Formula User field.

The first thing you need to do is define the number of users that will be participating in the 'round-robin' by creating an Application Variable. For this example let s call the variable [number_of_reps]

February 5th, 2009 - 5: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 - 5:02 PM

Create two summary fields in the Projects table (To learn how, please see our Create a Summary Field help topic). The first summary field will be labled "Number of Tasks". It should be configured to count the number of Tasks. The second summary field should be labeled "Number of Completed Tasks".

February 5th, 2009 - 5:02 PM

Yes. QuickBase supports formula fields. The value of a formula field in a particular record is calculated from the value of other fields in the record.

There are many types of formulas. A numeric formula results in a numeric value and uses numeric operations and functions. You can also create text formulas, check box formulas, date formulas, and URL formulas.

February 5th, 2009 - 5:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

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