Automations

Hey there, I’m not sure if this would be possible, but is there a way to take information from airtable and use it to fill in forms on other sites? I’m trying to set up a service where I offer to submit things to a list of websites for people (instead of having them do it manually themselves). I’d like to take submissions from my website, using an airtable form. Then take that information and fill out forms on other websites to submit those users. Not sure if there is any type of airtable integration/script for this or if I would need to use a combination of a script+zapier to make this work.

Hello the Best Community Ever!! Could you help me on my issue, please. Seems to be easy, but I spent hours on it without finding convenient solution. I use Zappier to collect some Client payment information from Payment tool to my Airtable. All the data collected arrive in my “Table1”. I have another Table, called “Table2”, with all general comments on my Clients. My need, is to check the “email” from my new record created in Table1 with the Client data base in my table2 to see if the Client is already in my Table1 or not. If not, I would like to add in Table2 the new email from Table1 and if yes, do nothing. I try to create an automation with “new record created” + “Find records” +“create records”, but when I test it, it works… but when I run it, it fails at “Find records” step. I don’t know if the automation is the right tool… Could you help me, please? Thanks a lot for your help!!! Damien

Hello! I’ve created a simple way to track time with clients using two forms. Basically using their mobile phone: The agent will complete the ‘Start Time’ form to record their start time with a client. When they are done they will complete the ‘End Time’ form. This creates two records as shown: What I would like to automate is when the ‘End Time’ form is submitted I would like it to update the previous record with that end time. So it looks like this after the automation: I’ve tried multiple triggers with actions but I can’t figure it out. :woozy_face: I would be most grateful for any insights the Airtable Ninja’s could provide! :pray:

Kia ora! I’m setting up an automation that watches one table for new records, and updates records in a second table with the information from the first. The specific use case is clients being able to update their personal information. This is done via a form in the first table with a range of optional fields - with the aim being that clients can only fill out what needs updating and leave the rest. However, when updating records in the second table based on these entries in the first, any empty fields in a record in the first table wipes the data from those fields in the second. Is there a way to leave fields alone if the fields in the new record are empty?

Hi all, This is my first time posting, hope the formatting of this is okay. I’m trying to create an automation where when a cell is filled in with a link to an action plan, an email with that action plan is sent to a contractor, whose contact information is connected by a look up field to another table. The layout I currently have in Table 1: A1 is the Link to Contractor Record in Table 2. B1 is the Trigger cell, in this Case a cell containing a URL to the action plan. The goal is that when cell B1 is filled in, the contractor in A1 is notified. The contractor’s information is already inputted way ahead of time, the only information needed is the URL that is entered into 1B. The contractor is not a collaborator, which I saw could be problematic on the plus plan, but I have the Pro plan so I should be able to send outside emails. I tested this by setting up an automation purely within that other table and it worked fine.

Kia ora! I’m trying to set up an automation so that when a record is created in one table, it updates a record in a second. Both tables are in the same base. Here’s the update step of the automation: Both tables have a name field, and entries in the first table (which is being watched for new records) will have names that match records in the second table. I think what I’m missing is what to put in the record id field of the update step - I’ve put the name field from the trigger but am getting an invalid inputs error message. Any thoughts? I know something like this is possible with a third party automation app, but I’m keen to keep it all in one place if possible! Edit: figured it out! I was missing a find records step.

Hi there! I’ve got a database which is presenting the same data but in different localisations. Everything is going well except for one aspect. The single select columns won’t transfer data in the same was a the multi-select (or any other data type I use). You can see in this picture, where I have got multi-select data transfer to work fine despite the selection IDs being different However, when trying to do something similar with single select, it will always add a new item. I have no idea how to sort this, and it’s really annoying (I have 24,000 cells to maintain, so I need this process to be automated) The picture below is an example (I only told it to use one cell so I didn’t have to clean up 16 columns) Does anyone have any ideas how

Hi, Thank you in advance for your help! I’m trying to create an automation trigger when a record is not created at 5pm on the day of the field “Due Date” (so that nobody gets offended if they plan on turning in their work by 4:59pm). Is there a way to do this without external integration (Zapier and the like)? Additionally, how do I adjust the time zone so that it’s reflecting 5pm US Pacific Time? Thanks, Peggy

I’m trying to set 2 different automations - one to trigger an email to team members every time a new task/record is created and also one that triggers an email to the assignee when the task is coming due. I have tried several different automations to accomplish this, with limited success. Initially, the test runs successfully, but once I turn it on and add new records to test, nothing happens. I’ve tried “when a record enters a view” with a filter of a due date, and only future dates and it initially works, but when I add test records, I get nothing?? The same is true for the automation I’ve tried for new records. I would also like to have an email triggered if a due date and/or assigned person is changed at any point in time within an existing record. No success here either after initial tests. It’s telling me something about my workspace reaching the limit of automation runs??? Will it reset February 1st and retro send any that failed for this reason?

Hi There. I was looking at the Airtable Automations. I can how to automate a record to update however is there a way to update on certain conditional logic? I have two bases. One for Projects and one for Tasks. Once all tasks associated with a project are marked as complete I want the Project Status to automatically mark as completed as well. Any ideas around the best way to tackle this. When I setup the initial automation as soon as it found one task as complete the project was marked as complete even if other tasks were still with the status in progress.

Hi everyone, I’m new to Airtable, and I’ve been doing a lot of research on this issue to try and solve my problem, but I’m not finding anything clear to me that answers it directly. I have a table set up with a list of people. Associated with each person is a Last Completed Job status essentially equating to “New” dates and “Old” dates. I have a view set up with filters to only pull the “Old” statuses. I would like to receive a daily email that shows me every individual on this view. I’ve explored Airtable Automations and I’ve explored using Zapier’s Digest solution. The Zapier option gets me the closest, but I’ve only ever been able to pull one record at a time, even though the New Record In View in Airtable testing triggers reveal, for instance, four records. Everything else just pulls the one. I’m sure it has to do with how I’m setting this up, but I just needed a bit of help. Using this:

We have created an automation that is triggers when someone creates a new record by entering it through the form. Every test we’ve run has been successful so we recently switched the email address to be the correct end locations. Upon switching only the to: email and keeping everything the same, the automation is still not running. (I’ve saved, updated, re-tested) and we are still not getting the email to actually fire off. Has anyone encountered anything similar? Thanks!

Hi there, I want all conversations from a specific Slack channel to be sent in real-time to a table’s field (long-text type). Is this possible? Thank you

This seems like a basic ask and I’m sorry to bother people with something this basic but I can’t accomplish this with my limited experience with Airtable. Tables Vendor List - one particular field (TCODE) is a number (2 digit integer) that corresponds to a county in Calif. Counties - 2 fields TCODE and TDESC which is string with the county name ie “Los Angeles” Use Case Import a spreadsheet of Vendors and their addresses which include the TCODE value Somehow (linked tables?) somewhere (same table new field, new table?) add the county name from the Counties Table TDESC field. My outcome so far… I can link the tables with the TCODE field. That column now show the highlighted TCODE. It also creates new entries in Counties table (not good). I can add a lookup field in “Vendor List” and point to “TDESC” in Counties table but nothing is populated until I manually add the record from Counties to the linked field in

Automation with set a trigger on a specific scheduled time is awesome and most of us are waiting for it. It’s still in Alpha but now we can sure that it’s will be fully-added in the near future. Another thing is Action with search records it’s an awesome feature to have while playing with automation and Scripts. This is also in Alpha. Thanks.

I’m making an automation that edits an Airtable record with a date pulled from a Google Forms submission. I know from this post that the formats are incompatible, but I didn’t know if there’s a way to convert the date in a script to a format that Airtable finds more palatable? Is there something like DATETIME_PARSE() for scripting? I could create a column for the incoming date and a column for the DATETIME_PARSE() formula, but I’d prefer to do it in a script and avoid cluttering my base.

Hi there, :wave: I’m hoping someone could help me out there with an automation issue. So here it is : I’m recruting people. So I manually create a new record in a TABLE A. This record contains several information : email, name, contact date… I’ve also created a “single select field” called “Document received ?”. The choice is between YES or NO. An Airtable form is sent to the candidate. It helps me gathering datas such as : ID Card, Licence driving, email, phone number, etc… Then, the form appears in a view : in a TABLE B. Here is the problem : When a new form is received in TABLE B, I want to automatically update the record that matches the name (or the email) of the candidate in TABLE A. So I want the field “Document received ?” to automatically turn “YES”. PS : I’ve created a “LINK TO” field in table A and

Because you can’t purchase more Automations on the Pro Plan in the event you run out (like integromat/zapier), what happens to your workflow? Is everything halted? Upgrading to enterprise would not be an option due to extreme price difference. For example - Say I have my automations set for my entire workflow working great, but I accidentally trigger an automation that uses a ton of unnecessary automations… oops… my fault and understand and wish I can buy more to pay for that mistake, but I can’t. Now I am out of automations and almost have an entire month left with zero automations :frowning: and all my workflows are stopped. I just want to find out the “what if” and hope never end up in that situation :slightly_smiling_face: Thanks.

Hello all, I am pretty new to using Airtable and have my first issue : I set an automation “when records matches conditions” → “Send Email”. I have the right table and the right conditions. What I would like to do : there is 4 records that are currently matching my condition (based on a due date to come in 45 days) but the email only sends the information on the first record and NOT the other 3. How can I do to make sure that my email includes the other 3 records ? Or at least, that 3 other emails get sent If I can’t put together the info on my 4 records. The idea would be to have a dynamic alert system when a record matches the due date to come in 45 days. I hope this is clear enough :slightly_smiling_face: Thx

Hi Everyone, I have a scenario I want to try and do without too many external services (Zapier/Integromat) I want an Automated Schedule to run, search for all records that have a Value in the “Prefered Hour” field that matches the hour the Automation is run, and then updates that record. i.e Schedule runs at 11:00, finds a record that has a value of 11:00 in the “Prefered Hour” filed and updates it. I have tried to use a Formula filed with Now() to extract the time so I can compare but, with mixed success. Any ideas?

I’m trying to use an automation to populate a table with values pulled from newly created records in another table. This seems like it should be the most basic function of automations using the “when a record is created” trigger and corresponding “create a new record” action. However, as best I can tell, because Airtable considers a record “created” BEFORE you begin populating it, it will successfully create a new row in the related table, but won’t actually fill it with any value (except the record ID). I can achieve the desired effect using the “When a record enters view” trigger, which confirms that there isn’t some data type error (and in fact I’ve created rudimentary two-column tables with only single line text to eliminate variables). However, this is a clumsy solution, especially as “when a record is created” is currently one of two possible triggers. This is confirmed somewhat in a post in this thread, though dealing with custom scripting, whereas I’m just tryi

Hey there, I’m working on a form where you can lookup resources in a linked table. Each resource has a name and URL associated with it. The goal is to send the names and links together in an email but… HERE’S WHERE I’M STUCK: I am only able to add the name—not the URL—to email automations. I currently have three single-select fields in the form (B)—which link to another table (A). This is because multi-select only produced the first field in the email automation. So, a user selects the resource by name in B, which links to A (Name A), and populates the field (Name B). A second field in B refers to Name B, looks up the link and populates Link B. It all works like butter in the table but… I can only select Name B in the automation.The fields for Link B are empty. Any advice or wisdom would be much appreciated.

Hello, I’m setting up my first Airtable Automation where I have two fields: Date and Status. If a Date field is on or more than 7 days old (for instance, if today is January 21, I would need it to pull from dates that are January 14 or older), I need the Status field to say “Old.” For dates that are within the past week, I need it to say “New.” When I set up the Automation, I get a failed test, with “Received invalid inputs” as the error message. I have a feeling it has something to do with my Record ID not matching up, but I don’t know what to do there and I’m having trouble finding documentation on it. Any help is appreciated. Thanks!

I’m trying to use an automation with a script to create an datestamp that be overridden. This is being used for.a microgreen farm and there are times where we will enter new plantings hours after the actually planting and the records need to be back dated. Normally just the current datestamp will work but there must be the ability of override it. I will also be doing this with a number of other values from a linked table. Here is the code for the script. There are ~7k records and the execution time if 17-18 seconds which is not acceptable. Is there anything I can do to speed this up? Hopefully I’m missing something simple. // the table containing record links, and the linked-to table let rootTable = base.getTable(“Planting Log”); // the record with the links we want to summarize // we need to create a ‘recordId’ input variable connected to a record trigger let config = input.config(); let recordId = config.recordId; // query the ta

Hi! I am using an airtable automation to move certain data from the record to a different table, then I would like to automatically delete the record in the original table. Can I take that last step using Automations? I couldn’t figure out how. Apologies if this is well documented, I couldn’t find it though! Thanks!