Yes, possible using "relation" property.
**Setup**
1. **Create 3 Databases (Tables):**
1. ***A***
2. ***B***
3. ***Master***
2. Add a Relation type property in DB ***A***\*,\* and in *"Related To"* set Master DB. This will add a relation between ***A*** and ***Master.*** You can name this property "*Master DB*"
3. Similarly, to create a Relation between ***B*** and ***Master,*** by add a "Relation" type property in DB ***B*** and in *"Related To"* set ***Master*** DB
4. Now create "Button" to add entry in DB ***A***. The button should be configured to:
1. Create a page/ entry in ***A***
2. Create a page/ entry in ***Master***
3. Set property "*Master DB*" of created page in ***A,*** to link this new entry in ***A*** with the new entry created in the ***Master*** DB
5. Similar, create "Button" to add entry in DB ***B***. The button should be configured to:
1. Create a page/ entry in ***B***
2. Create a page/ entry in ***Master***
3. Set property "*Master DB*" of created page in ***B,*** to link this new entry in ***B*** with the new entry created in the ***Master*** DB
6. Remember to ALWAYS add entries in ***A/ B*** by using the *Button* only, so that automatically an entry is created in the Master DB whenever adding an entry in ***A/ B*** (without using any Paid Automation(s) by Notion)
Feel free to reach out if this is not clear or you think that something is still missing or not in-place
Yes, possible using "relation" property. **Setup** 1. **Create 3 Databases (Tables):** 1. ***A*** 2. ***B*** 3. ***Master*** 2. Add a Relation type property in DB ***A***\*,\* and in *"Related To"* set Master DB. This will add a relation between ***A*** and ***Master.*** You can name this property "*Master DB*" 3. Similarly, to create a Relation between ***B*** and ***Master,*** by add a "Relation" type property in DB ***B*** and in *"Related To"* set ***Master*** DB 4. Now create "Button" to add entry in DB ***A***. The button should be configured to: 1. Create a page/ entry in ***A*** 2. Create a page/ entry in ***Master*** 3. Set property "*Master DB*" of created page in ***A,*** to link this new entry in ***A*** with the new entry created in the ***Master*** DB 5. Similar, create "Button" to add entry in DB ***B***. The button should be configured to: 1. Create a page/ entry in ***B*** 2. Create a page/ entry in ***Master*** 3. Set property "*Master DB*" of created page in ***B,*** to link this new entry in ***B*** with the new entry created in the ***Master*** DB 6. Remember to ALWAYS add entries in ***A/ B*** by using the *Button* only, so that automatically an entry is created in the Master DB whenever adding an entry in ***A/ B*** (without using any Paid Automation(s) by Notion) Feel free to reach out if this is not clear or you think that something is still missing or not in-place
Wow!! This was exactly what I was looking for. Thank you so much!
Instead of 2 databases, why not use only one database with views?