auto-populate

Syndicate content

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 - 6: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 - 6:02 PM

In QuickBase we call what you refer to as a dependency, a relationship. A relationship always involves two tables.

In the example above one of the tables would be a table of users. The users table would have a field for email address and a field for phone number. The users table, in this relationship, is the master table.

February 5th, 2009 - 6:02 PM

Create a formula field of type "Formula URL - (Link)". Let's assume the first application is a list of action items, and the related application is a list of related files. Then you need to create a formula like the one below:

URLRoot() & "db/6k7gvdyw?act=API_GenAddRecordForm&_fnm_issue_id="
& URLEncode(ToText([Record ID#]))

February 5th, 2009 - 6:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

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