Automations

I use Airtable to track and schedule vaccinations for the animals in my calf barn. Using the birthdate of the calf, I have formulas in the due date fields to calculate the appropriate date to give each vaccine to each animal. Then I have a field with a checkbox to indicate when that vaccination has been completed. I use the calendar view with this table to show me what I need to complete on any given day. This works well, but what I want to create is an automation that removes the item from the calendar view after I check it off as being completed in the grid view. I would even settle for the date of that item being changed to a date 6 months in the past or something, just as long as it doesn’t keep showing up and cluttering my current calendar. But most automations I have tried can’t alter a “calculated date”, which most of my fields are because they are all based on the birth date of the calf. I have been puzzling over this for a week now and am hoping someone out there has a potenti

Looking to use a button that when clicked, links that associated record to other selected records.   

Hi Airtables Community!I'm wondering if this is even possible with Airtables?I have 2 separate bases ["Shipment Report" & "Customer Report"]Shipment Report Base has tables to keep track of all our shipments [Air, Ocean, Ground, etc.]Customer Report Base has tables specifically for each customer so they can view and keep track of what's going on with their shipments [customer #001 table, customer #002 table, etc.]Our office only edits tables inside Shipment Report. I set up each table with the primary field "Customer ID". I have created a unique identification code for each of our customers. For example, "001" is tied to "customer #001". So, when a record is created the first thing we input is the Customer ID to know who the customer is."Customer #001" will have their own tables in Customer Report Base. I would like to have each customer's table be linked to the shipment report but only pull records that pertain to them. For example, if we have 10 records in our shipment report and

is there a way to copy records between tables in different bases or how to switch the current base a little example would be helpful thx

I am wondering if it is possible to create an automation where a pool of 10 freelance job candidates are prioritized according to distance from an added Japan Postal Code, and then emailed one after another with a 24 hour deadline to respond if available or not for the job. So if Candidate #1 marks himself as unavailable, then the system would then email Candidate #2. If the entire automation is not feasible, how far could the automation be taken? Would it be possible to do with a free Airtable account? Thank you.

Hi,I have a table that contains Tasks. These are assigned to User using the User/Collaborator field.I want to be able to create an automation that runs daily, finds all the tasks in a view (Follow-up today) and then send an email to each User that is found in this view with a list of all there tasks. I'm trying to think of the best way of doing this without different views for each user. I was thinking I need to find a unique list of users that are in that view and then have a repeating step  to find all tasks in that view associated to that user and then send them an email. I'm not sure how to find unique users that have tasks in that view as there will be multiple tasks for the same users.Any advise appreciated? Jason      

I would guess this question has been asked and answered before, but I can't find an answer.I have a table of contacts and a table of campaigns. I would like to be able to filter the contacts by whatever criteria, and then add a bulk cross reference to that filtered group in a row of the campaigns table, populating the 'Link to another record' field.For example, I have a group of individuals I would like to contact for an event mailing. I have a row in the campaigns table that has details of the event mailing (description, date, etc), and I want to keep a record of everyone who was contacted.If that makes sense as a requirement, is it a job for an automations?

Bonjour Madame , Monsieur je suis nouveau sur air table , j'ai du mal avec ma base , est ce que quelqu'un peut m'aider s'il vous plait.Je voudrais réaliser des conditions sur les automatisations , est ce que je peux faire call avec une personne ?

I have an airtable base with two fields : name and website. Some of the orgs have website filled and some don't.  I want to do the following1. Check if the website column is empty.2. If no, nothing should be done.3. If yes, look for the name of the org in the 'Name' column               See if it matches with the name in an excelsheet/google sheet               Find the corresponding website from the excel               Update it back in airtable against the nameHow can I proceed with this? I read about API calls. Would the update to each record be considered as 1 API call? Is there a way to find records in bulk, match and then update records in bulk? I am okay to do this using Python script as well. However would like to first know if this is possible through airtable automation , automation using make or airtable script (extension) before looking to write a Pyt

Hi all,I'm using the 'Find Records' automation to get a grid of records to email to other people. Though my table is sorted by date, the records are being returned in a completely random order (see attached, specifically the Overtime Worked Date column). Any thoughts on how to make the grid return information that's ordered chronologically instead?Thanks so much !!

Hi guys! Do you experience any issues with the automations these days? Recently, I’m experiencing the slowness of automations. Literally, it takes ages to write anything in the past few weeks. I’ve checked the issues on other machines of my colleagues and they also experienced slowness. Thanks!

Hi everyone, here is my situation: I'm working with KPIs and must record the people whose projects have been trained.  I'm using forms to collect the participant's data. So I have:Table 1 "People trained": the table where I have the forms and the data collected about people trained is stored.Table 2 "projects":  which is the one where I have the project data and want to update their KPIs when a form is summited. So my idea is to have in the table "projects" a count of people by the different KPIs registered in the table "people trained," for example, I'm looking to have in each project record the number of women that have been trained under the framework of that project. So, it means that every time a form is submitted, each project record needs to be updated.I already have linked table 2 with Table 1 by the projects field using the "Linked records" type, so when a person fills out the form, they can manually select the project that belongs to the activity they are parti

Hey everyone,I am slowly moving forward in my airtable scripting journey. What a ride so far. I would need some advice on best proceeding to finalize my script.Context:I created a script triggered from a button, to match client records with potential real estate properties, based on a set of preferences such as the number of bedrooms, the type of view, or some house features. The script does the following steps:- Fetch the criteria value from the record used for the automation (the client)- for each record in my property listings, it calculates a base score for each criterion (0 to 10)- It applies a weight point system to the criteria scores and outputs a Total property score (normalized from 0 to 10)- I then slice the top 10 properties and link the IDs to the client record under a specific linked field. Can't lie, as a no-code person, it took me a few days to get there.Currently, the criteria weight points are fixed, and stored in a const. This works but some extra flex

Hi Everyone! For our base, we do a lot of emails out to external people (students, contractors, etc.) . We generally want them to reply to our emails and so we set up other automations to bump them if they do not fill out a form. One issue we have is that often times people will reply to our email but not fill out the form. We're not currently able to address that - and so have to manually record that they've replied in the base so that we don't bump them. Has anyone found a workaround to track "email replies" such that we don't keep bumping them? I know usually this is done by attaching some sort of cookie to an email or similar. I know this is possible in Hubspot sequences, but I haven't found a similar solution in Airtable. This would be a big win if we could have something like this! 

Hey! Thanks in advance for the helpThis is my problem, and I know how basic it sounds but I haven't been able to get this done! I'm creating an automation and Im setting it up so when a record matches a condition (WPM (numbers column) is not empty AND is less (<) than 35) updates a record (Candidate stage (simple selection) to --> Rejected)But what it does is its sending all numbers (less, equal, higher) to Rejected except when WPM is empty (at least that worked) I've troubleshoot as a maniac and nothing seems to work out - Any idea?

I am confused. I set up an UPDATE RECORD AUTOMATION that seems to work in my 2 test tables, but it still creates error messages sent to me by Airtable.I have two tables to test this: The first one is CONTACTS MAIN with the following fields: This is the second table: CONTACTS AUTO with the following linked field and lookup fields. This is an alternate version of CONTACTS MAIN with EMAIL as the primary field, which I need for certain tasks. The second CONTACTS AUTO table links to the primary NAME field of CONTACTS MAIN and pulls in all the other information as lookup fields.I need to keep the two tables in sync. So, I created automation. Whenever I add a record to the main table, it creates the same record in the second one. I also set up an automation that updates every record in the second table that I tweaked in the first one. This automation also works, but it creates Airtable error notifications.Would someone with automation knowledge be kind enough to review what I did? I

Hi there,I want to create a new field called "Original Start Date" and this will be populated from the "Start Date" field when someone enters in a new project.  Like a lot of projects the Start and End date moves a lot.  We want to reference back to when it was first originally entered in.Where do I start?  Do I create a new field in the "Projects" table called "Original Start Date" and then create an automation the populates this from the "Start Date"?I was referencing this article that mentions creating an automation.But I don't know the steps in connecting the two.Any help is greatly appreciated.Thanks!

Hello! Can you plese help me with automations and billing? I switched to the Pro plan and cannot run the script.

Hello,I am designing a base that needs URLs with markdown in this format:[text to display](https://my.url.com)However, when I try that... that's exactly what it looks like. I'm using long text fields with rich text enabled. I've tried a bunch of variants, including many I've seen in this forum, and it never shows display text -- always just the text exactly as entered. Whether or not the URL is interpreted as a URL is also an issue. It works sometimes, but no others. I'm using google Chrome for what it's worth. Is there an issue with my syntax?Regards,Scott

I've got an issue with my account, as Airtable is displaying that I reached my automation limit (50.000 / 50.000)Actually, I only have one active automation in my whole workspace, triggered by the creation of a record, and I only create approximatively a dozen record a day.I dont understand how my limit can be reached that quickly, and apparently this is the case every month, my automation limit is reached after 2 or 3 days.Have you already faced something like that ? I currently have the Pro Plan, and I don't know if this is the good place to reach someone that can fix my problem and more importantly explain to me why this is happening. Thanks you very much !

Hello, I am using Automations to keep my Base in sync with a Google Calendar. Specifically, I am importing Google Calendar events into AirTable. For one-off events, it works great! Creations, updates, and deletions get mirrored pretty well. However, when I create a recurring event in Google Calendar, only one row gets created in my base. My automation trigger is set for “when an event is created in Google Calendar” and the action is “create a new row”. If I create an event in Google Calendar that repeats every Monday for one month, I would like 4 rows to be created in AirTable Does anyone know if this is this possible with Automations? Thanks so much!

Is anyone else having problems with slack sending an actionable message? 😣everything was working fine until Monday. My regular slack message automation is working fine! I disconnected and reconnected the my slack account to airtable. I also ensured my Slack had the airtable app integrated. All I see is the following message but I do not see what the actual error is. The channel and slack account is correct. The trigger also works perfectly. SOS. 

Hi, My organisation is on the Team Plan with budget allowing for only one collaborator. We need to email read-only users and / or external emails (max 50 recipients per email) but I'm unable to find out so far if this is possible without being charged. I'm also struggling to find the limits on these type of emails. I've attached a basic example of a select number of records which I wish to share in an email. Would appreciate if someone could advise / tell me a better approach! Thank you. 

Hello! I would like to set up automation using "Run a script" that adds to a table new rows from a name that I give with running numbers. For example:"Good Morning 1""Good Morning 2""Good Morning 3"......This is the script that I use now, the output is"Good Morning 24""Good Morning 25""Good Morning 26"......output.text('Create Saga Tasks');const assetBuilds = base.getTable('Asset Builds');const sagaLanes = base.getTable('Saga Lanes');const sagaEpisodes = base.getTable('Saga Episodes');const tasks = base.getTable('Tasks');const taskBundles = base.getTable('Task Bundles');const sagaBundleTasks = await taskBundles.selectRecordsAsync({fields: [    'Automation Type',    'Summary',    'Scope',    'Product Default',    'Copy Default',   

I am new to Airtable. I have created an interface, but I am struggling to figure out how to display alerts or message boxes to the user in the interface if they are open and not taking any actions for a certain interval (like five minutes). Ideally, I would like to display a help dialog where they can search for or see a link to another page. I don't know if this is possible, but I would greatly appreciate it if anyone could guide me.