Hey everyone,I aim to enhance my CRM by achieving the following:Establish a connection between my Gmail account and an Airtable for contacts. I'd like every new contact's email to automatically create a record in Airtable or Google Sheet/Excel, facil...
Hi all!Maybe someone has solved a similar problem.I'm making a kind of task tracker, but I can't solve the following problem. I want to do the following in the task picker interface:1. You can select a record from the database (already done)2. For th...
I am trying to set up an employee scheduling table. The table has links to my events table and to my employee table. The events have a "Start date" and "end date". Is there a way to create new records in the scheduling table pulled from events in the...
Hi all.I've created an airtable that is populating customer subscription changes via a Zapier integration with our revenue tool, Chargebee.The changes occur in the "Subscription Status" column in the airtable base:This is working, however when I try ...
I am working with a Marketing Agency that is using Airtable to manage task work. Currently, we have a table with tasks, grouped by frequency (daily, weekly, bi-weekly, monthly, quarterly). For each task, if the task is applicable to a client - that c...
I am very new to airtable and just learning. I am building a base for a company that delivers pet food (B2C). and each record in the base is a client with some specific info like (the date of the first scheduled delivery, the day of the week that del...
Hello, I need some help to find a solution for this task:I have two tables, on contain a columns called small, tall and month. The second table contains the columns small_december and tall_december.I need to write a script that looks for the record m...
Using airtable for project management, so far the set up etc is fine. One thing I am trying to set up is a script (can be put into a field as a button) that deletes the record that the button is in but also deletes all linked records in the sub task ...
I have a "main" table, call it A. It holds client names. I have a second table, call it "B." It will hold deadlines. For every A record, i.e. client, Table B should have one corresponding record where a lookup field (call it "Name") populates wit...
Dear AllI am trying to automate "master project status" in the base, hopefully through creating a formula. "Master project" is a made of all small "projects". Logic as below: - If all of "project status" is "concluded", then "master project status" i...
