<aside> <img src="/icons/info-alternate_gray.svg" alt="/icons/info-alternate_gray.svg" width="40px" />

This demo showcases an innovative approach to managing employee information and out-of-office (OOO) statuses using interconnected databases. While it specifically demonstrates an Employee Directory database linked with an OOO database, the core principle of automatically creating relations based on other properties has wide-ranging applications.

• More Info
• Loom Demo
• ERD Diagram </aside>

Employees

Employees

OOO Calendar

OOO

• Mapping Database

  Employee Mapping

Instructions

1. Setup two databases ( & )

2. Create a mapping database ()

3. Create a two way relation between the mapping database and the other two.

4. Setup a database automation so that each time a new page is added to the database it will get related to the single MAP item in the database.

   • Image

5. Setup a database automation in the database which will relate all new pages added to the MAP item in the database.

   • Image

6. Setup a database automation in the database which will relate new pages added to the correct person in the database using the formula below:

   /* Actual Formula */
   first(flat(map({"global":"button_page","source":"global"}.prop("MAP"),current.Employees)).filter({"global":"button_page","source":"global"}.prop("Name")==format(current)))
   
   /* Human Readable Formula */
   first(flat(map({Trigger page.Map,current.prop("Employees"))).filter({Trigger page.Name==format(current)))
   

   

   • Image

7. Now when a new item is created in the database the automations should trigger in order, starting from the bottom. First it should add the MAP relation to the page. Second it should check the name of the OOO item and if it matches a page in the database it should relate it to the correct page.

   • Image