Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Bi directional synced table

Topic Labels: Automations Base design Sync
610 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Guillaume_Soto
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi everyone,

The context is as follows:

We give trainings (among others) to many people. I would like to know who attended which trainings, get feedback on participation, etc....Each training is managed independently by a different team, with different constraints.

What I have set up :

I created a "CONTACT" database with all contacts in a shared table "PEOPLE ".

Each project has its own database "PROJECT1", "PROJECT2", etc... I connected the shared table "PEOPLE" in each project database, to retrieve the data of the persons (email, tel). This table is read-only in this database. I add data for each person: "grades obtained, participation, etc...). For now, at the end of the project, I copy the important data of the project (grades, certificates) in the main table "PEOPLE".

But obviously this is not ideal.

My need
Is there a simple way to automatically retrieve some data directly to the initial database? If needed, I can use MAKE, but I confess that my preference is to automate directly in Airtable.

 

Thanks to the community 🙂

 

Guillaume_Soto_0-1678176294466.png

 

 

 

0 Replies 0