Auto-numbering in Quick Base Joe owns a construction company and is using Quick Base for project management. Joe wants tasks within a project to be numbered in sequential order 1, 2, 3, etc. He wants task numbers to continue, in order, even if tasks are deleted.
We can do this easily in Quick Base using a snapshot field, a formula field, and an automation. Let’s help Joe set up auto-numbering!
Joe’s app has two tables: Projects and Tasks, where projects have many tasks.
Step 1: On the Projects table create a numeric field called: Default Task #
Note: We will use the Default Task # in an automation in step 10 ...