I’ve started using Airtable to create an inventory for work, I’ve started working with creating multiple tables:
Employees | Devices | SecondDevices | Other Devices | Monitors | Group1 | Group2 | Budget
I need to sync all devices (Devices, SecondDevices, OtherDevices, Monitors) that have a tag within budget.
The case being that budget has 2 types, internal and external budget.
Goal 1: All external budgets should be exported or synced to Google Spreadsheet automatically.
Goal 2: Entries in one table should be duplicated when added a tag.
Question 1: What is the best (free) way to sync Airtable to spreadsheets automatically.
(register new entry’s and update old entry’s)
I tried Zapier & Automate.io and it is not possible with the free licensing.
Question 2: Can I create tags in Airtable?
Question 3: Is it possible to add an entry and that it get’s autofilled in another table by adding a tag or through another way?
A lot of questions, I know.
If there is something that’s unclear (which I suspect!). Let me know and I’ll adjust the question.