I am working with Greenhouse ATS (Application Tracking System). I have a Notion Database where I log every job details coming from greenhouse. This helps our team to track all related data without searching on greenhouse. This DB is called Job Board DB
I am trying to build multiple databases with the data from Job Board DB. These databases are KPI related and it is important to keep them private, therefore I am trying to automate the process where every change affects related KPI Databases.
I also have a backup Job Board DB so that I can compare two Job Board DB and watch the changes and update related KPI Databases. I want to use CRUD operations for KPI Databases.
I have created a BPMN Diagram for these operations.
Basically I created a DB for every recruiter or sourcer and I created their DB by filtering “Sourcer” and “Recruiter” attribute in Job Board DB, and I would like to add Create, Update and Delete functions to these DBs.
What I have now.
This is soo repetetive and I had to create Delete Item, Search Item, Update Item for every person in our team.
I am searching for solutions which are not repetitive and covers all of them. I am open to any question.