Help

How would you set this up?

Topic Labels: Base design
1026 1
cancel
Showing results for 
Search instead for 
Did you mean: 
gaexsz
4 - Data Explorer
4 - Data Explorer

How would you set this up?

Department 1 is in charge of sending contract to customer, receiving contract, sending invoice and receiving invoice for initial payment. Once initial payment is received, Department 2 is notified and now needs to complete a certain number of tasks for 'onboarding that customer'. When those tasks are complete, Department 3 is notified and they have their own number of tasks for that customer, and so on.

Thanks for any advice!

1 Reply 1
corb1
6 - Interface Innovator
6 - Interface Innovator

Probably several ways to do this and may get differing answers. Here is one way

Tables

  • Departments table
    • DeptID
    • DepartmentName
    • DepartmentContact
    • DepartmentContactEmail/Slack
    • Other Dept data
  • Projects
    • ProjectID
    • ProjectName
    • other project stuff
    • Contract stuff, payment status
    • TaskIDs (link to Tasks table, allow linking to multiple)
  • Tasks
    • TaskID
    • TaskPhase (Contract, Landed, In progress, Completed)
    • TaskStatus (Complete, assigned, etc.)
    • StartDate
    • EndDate
    • DepartmentID/Assignee
    • TaskStatus
    • Any necessary lookups to Projects table or Dept table
      -->Setup Kanban views on this table filtered by dept with the kanban being based on

Setup record template such that when a project is created, all associated contract (dept1) tasks are also created in an incomplete status in the Tasks table & automations such that dept1 is notified.

Then setup automations to handle the logic of...
If last task in contract (dept1) phase completes, spawn all tasks for dept2 in next stage with status of incomplete. Send email or other notification to dept2. Repeat for dept3.