Hello, looking for help on how to trigger the update of formula field when a record reaches a condition. My example is the following: I have a "Birth Date" field which contains the birthdate as Date. I have a formula field which calculates the curren...
I have an automation which sends a slack message at a scheduled time with a list of tasks due that week, sent in formatted single messages for display purposes.It's a repeating action which runs through a list found, but it never runs in chronologica...
Hi, I have a sales team that inserts every sale into a DB on to Air TableI would like 2 do an automation that sends me a daily report with1 - Sales on current month (how much)2 - Sales on current month (how many) 3 - Sales on current week (how much)4...
Hello!I have a base with 3 tables:a Contacts table,an Organization table, anda Membership table. In the Organization table, I have a linked field to the Contacts table called "All organization contacts" where I link all Contacts records associated wi...
Hi there - I have tried a few ways to do this but have been unsuccessful. Here is what we are trying to accomplish >> Matching one company to grants that have matching sectors, location and demographics and each can have a deadline or no deadline. Th...
Hi everyone,I want to build a "Billing Meter" table that generates invoices for Meter Readings.The value of the Meter Readings are sent via email and I have set up an email parser via Parsio, that parses the data (meter) in the email, and creates a r...
I have a table that I use to calculate expenses for a specific project. I would like the SUM of one of the columns to automate/sync/roll up/whatever?? to another record/field that is located in a different BASE (for invoicing purposes). Can this be d...
Hello Everyone,I would like to use Airtable to share order status with my teammates. Because the finished date or customers' requests often change, I need all members to follow up on the newest changed content.Though I can know when each project is c...
Hi all,The data from the table below is from another table using Automation:Once the status of a request ID is updated, then the update time of each status will be automatically recorded in this table.Is there any way to calculate the time difference...
Hello,Was curious if it was possible to set an automation to basically trigger an email if inventory is based on a % of x being low, rather than an exact number?QTY = < %So if I have 1000 labels, and I'm running low, and already utilized 50% of that,...
Hi guys,Hope you are well.I am trying to create an automation where I can get a notification when a record has not been updated for x amount of time.Is this something I can do in Airtable? I need to keep a list of items up to date, and I am not sure ...
When record text field is not empty, find records with similar text fields and link records? Is this possible? The similarity could be a partial match.
Hey everyone. I have an automation setup where it emails me anytime a record has been edited or updated within a base of mine. This is great, but I don't know which record or field has been updated so it's hard to figure that part out without created...
Hi, I have a table with tasks and would like to also manage subtasks in the same table. Currently, I have a linked field called "child". Using this field, I link to other tasks within the same table. So, a parent task record might show multiple linke...
Hi Y'all!First post. real problem. Have been trying for 2 days(script below text)I have a workplace problem that i am determined to solve using Airtable.In table: Product data i have 1500+ product records with a primary barcode field called 'BRCDP'In...
Hi, I would like to add +1 to a #Number column to a dedicated Name line in one table as soon as a record is created in another table including the same name. Is it possible?Thank you very much Example:Table/tab 1Name. Surname NumberYohan L...
Hello everyone I work for a school and some workshops are made in groups of students.For instance, I need the 6 people from the Thursday, 11am slot to receive the same e-mail, visible e-mails in the "To:" field, and to Cc their trainer.Is there a way...
I want to automate copying data from one field to another field in a different table.The Assets table has three fields:Asset NameNotesURL (where the asset is saved) Whenever a new asset is created, the user enters information into a form that creates...
Hi, I am new to Airtable and have a question. I have two tables, each with the same column (multiple select) for "Technology". Specifically, it is about funding programmes and investment measures. In the table of investment measures I would like to h...
Hello! I have an event workback schedule set up with a formula column to auto-generate a due date based on what date I specify in my date column (see ex. formula below). However, I would like to have the formula column auto-generate a list of due dat...
