I am trying to automate a flow for creating a brand new database using filtered data from a master database.
Since Notion is not supporting giving only access to views, I need to create bunch of different databases using master database.
To give more clarification, We have a database with all our sales people and we want to track their sales data. Problem is that we need to create different databases using our master database to keep anonymity. We do not want people to check sales data other than themselves.
For this I thought this workflow,
Search Database to get filtered data that I will append to new database,
Get Database to get database properties,
Create a Page to create a page for every salesperson,
Create a Database, to create a new database for every salesperson,
Create a Database Item, to create a database item,
The problem is that when ācreating a databaseā it does not accept properties value that is coming from āget databaseā.
I am not sure what to put in properties value when creating a new database.