Create two summary fields in the Projects table. 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". It should be configured to also count the number of related Tasks with a condition to include only the Task records where the "Status" field is "Completed".

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.

You can indeed make one dropdown list dependent on the user’s choice in another dropdown list. The dependent list is called a conditional dropdown list.

This article provides a quick overview of the most common and recommended method for creating conditional dropdown lists. For detailed instructions and tutorials you can follow, see these QuickBase online help topics:

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.

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#]))