Automations

One feature I really miss in Airtable is automatically linking records. I know that I can manually link records, but I really need (OK, want) automation to do this. I’m wondering if experienced Airtable users have any advice to offer. Simplified use case: I’ve built a Quantified Self app in Airtable that uses IFTTT and Zapier (when necessary) to move data from the collecting app (Todoist, Strava, FitBit, etc) to app-specific tables. The data is ALWAYS timestamped. I also have a table of Monthly KPIs, where I set goals and measure progress. The Monthly KPIs table has twelve records: January, February, March, etc. To aggregate the data I am manually linking records from each app-specific table to the appropriate “month” record in the Monthly KPI table. I do this in order to bring the goals and the KPI data into the same table, where it can be analyzed and visualized using Blocks (which, I believe, can only take one table as a data source). On a per table basis, I can use Zapier to achiev

Hi all! First post here. Airtable has seriously changed my life. As someone who navigates the world with ADHD, this platform has, in the span of less than a month, changed the way I work and live. It is nothing short of a miracle. I absolutely love that you can automate tasks through Zapier, and I’d love to tap into that – but I have some questions about automating tasks without the use of Zapier, as I’m not in love with their price tag. $20/month for 1,000 tasks is a little steep, IMO, and, I’d also love to be able to customize the tasks more than Zapier will allow. Is it possible to automate tasks without the use of a platform like Zapier? Example: I’ve set up a marketing request system at my job, and when someone makes a request, Zapier places the request in my Asana To-Do list. I’d love to be able to do that without Zapier, but even more, I’d love to be able to add a checkbox in my Marketing Requests Airtable base (or in my Asana to-do list), and when I check the box to mark a task