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, the following link explains how.

https://www.quickbase.com/help/adding_a_field.html

Once you've created your formula numeric field, your formula would look something like this.

QuickBase Desktop is a Microsoft Access database with some VBA code that mirrors QuickBase databases to MS Access tables and their attached files to your hard drive. It also features a sync button that posts changes made to the mirrored tables back up to the QuickBase server. The sync button also pulls down changes from the QuickBase databases to the local MS Access tables.

You will need (at least) two related data tables to achieve this result.
Assume that you already have a table called Projects with a User field called 'Assigned To'.

Yes.

Please read this help topic: https://www.quickbase.com/help/configure_date_fields.html

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.