Automations

Hi everyone! I’ve used Airtable at my previous companies, but am now trying to find a few ways to automate the manual data entry I’m doing. Example: Our company uses Airtable forms for our customer onboardings. Once a form is submitted, I would like for one of my Bases in Airtable to automatically populate the form that was submitted. This way, I don’t need to manually add the form everytime one is submitted. Is this possible?

Hi I have tried different 4 different techniques to partly duplicate a record:- Automation record in view Checkbox triggers automation when record appears filtered view (checkbox true) Creates record populating two fields, a datefield from source record and the value of a lookup field (I’ve also tried getting the lookup value from a formula field instead of directly from the lookup field) as per @Jeremy_Oglesby suggestion in another post. Automation record matches true As above Integromat Webhook triggered by record in view pass record id to integromat webhook search table for record id create new record with date and lookup value Integromat Webhook triggered by record matches As above All of them are now taking 30 seconds to execute! I thought it would be pretty instant especially keeping the functionality all in airtable. I could understand the integromat round trip might take longer but if anything it’s actually faster but still slow! Any ideas why? Thanks Claire

I have a table in which users paste in the URL into a URL field, but they often paste in the wrong URL (https://example.com/edit/12345 is the right URL, and they paste in https://example.com/edit/12345#finished). I currently have a formula that replaces the cruft and puts it in a new field (SUBSTITUTE({Link},"#finished","")), but I’d rather use automation to update the field in place. Can someone help me with the script I need to run? Thanks!

Is there a way to send an automated email with all records added today?

Hello, I am building a matc hmaking app for jobs (offers and requests). I have two tables : first for job offers and second for profils in both tables i use many fields but 4 have same options (multi select). I would like to match those two tables based on the 4th fields, if all have same options then start an automation like email. Do i need an extrenat tool like parabola or it can be done inside airtable with linked tables for example ? How i can include data from a linked table automatically ? Thanks a lot for your advicess :slightly_smiling_face:

We have a list of vendors that will all need to complete certain steps before we consider them to be complete through our program. Each Vendor is submitted through a form by our internal team, and the vendor information lives in the “Vendor-Main View” tab. The Account Managers are then asked to copy all the checklist items from the “Master Checklist” (There are about 70) into the “Checklist” tab. The thought is that every vendor that comes in will each be unique, but the set of requirements to complete are the same for each vendor. Instead of copying the requirements from the Master Checklist, is there a way for me to create an automation so these requirements are created each time a new vendor is added to the Vendor-Main View tab?

I’m setting an automation to send a slack message using a lookup field (formatted as string). The automation doesn’t get the value from this lookup field. I get an error message saying “This property cannot be used right now” Has anyone hit the same issue or has something to add to help?

Heya everyone :wave: Super excited about the new automation features in Airtable! :raised_hands: We did some homework and made some handy walkthroughs on a few new key capabilities: How to Send an Email Automatically from Your Base Using Airtable Automations How to Connect Multiple Field Records Together Using Airtable Automations How to Automatically Add a Set of Tasks to Each New Project Using Airtable Automations How to Set Default Information on Any New Record Using Airtable Automations Hope those are helpful! Let me know if there are any others you’d like to see as well :point_down:

Is there a way via Automations-Update Record to set the Field value to a formula? I’m able to correctly set the trigger (tests successfully) and have set the Update Record Action to Record ID of the record(s) captured in the trigger. I can set my field output to a specific value (i.e. string for example), but I’m not seeing a way I can set the field update value to anything leveraging a formula. Is this currently supported does anyone know?

Hello - i need help creating an automation to send an email on a due date for a reminder. Is there a consultant or someone who can help me with this :slightly_smiling_face:

Hi, Any idea how to get rid of the Automations pop-up? Automations - great! - but how of this annoying pop up???

The Background: My kid’s school needed a Daily Health Survey that parents/faculty/staff/volunteers need to fill out every day, and I said I would help and now I’m stuck. I created a JotForm which dumps data into an Airtable base, and I use automations to create one big table that has all the individual pieces in it. The raw data goes here: https://airtable.com/shri5YgdoGt16lZGH The automations create this: https://airtable.com/shrgmvNxk4fWEwlYX The Problem: the principal of the school would like to be able to print out a sheet of paper every day that has the names of the students/faculty/staff/volunteers on it and their clearance statuses. So: Pablo Picasso - Cleared Zoey Beckmann - Not Cleared etc This is a great use for the Page Designer Block (I think), but in order for me to do that, I need to figure out a way to automatically link all of the records for each date to a single record in another table, and that’s where I’m stuck. Any advice? Thanks so much.

Hello, I am working on various automations for my use case, but don’t have previous experience with json or the airtable api. I’ve created a multi-step automation that relies on a couple of scripts to link fields in various tables. I am sure there is a cleaner way to do it, but overall it works when individual records are created. However, I have realized that when I batch upload a group of new records (as will be a likely use case moving forward) I run into a script error stating that the query for selectrecords has exceeded the max of 30. I would love some help figuring out how to modify the following script. I have two tables: Contacts; Companies When a new record is found in Contacts, it is supposed to search Companies and then create a link automatically if a matching record is found. I modified a script I found elsewhere in the community. Here is what I am currently using. //Define the table and query let cmpTbl = base.getTable(“Companies”); let cmpQuery = await cmpTbl.selectReco

I’ve created my first automation using the new Automations field in Airtable. I want to send an email when a record in a table is updated. The automation works – kind of. If I update the field, I do get an email. Well, that’s the problem. I don’t get “an” email. I get multiple emails. The field in question is a long-text note field. Editing the field to add a couple of sentences triggered seven or eight emails. Am I doing something wrong? Or is this feature not quite ready for prime time? I assume it’s me, but I don’t see what I’m doing wrong.

Hi all When using the automation with the trigger “when a record enters a view” and I start the automation, it always also sends an email to those records that are already in that view. Is there a way to avoid this and only send emails to records that come in to the view new, that is, after I started the automation? Shouldn’t be an option? I tried stopping the automation, then adding records to the view and then started it again, but same result. What am I missing here?

Super excited for AT to have the automations feature but I have run into a roadblock. I have an automation that I want to run and as part of it, I want to clear any data that may exist in a field. In Zapier you can do this with three spaces. Is there a way to do this in Automations?

I recently discovered Automation feature, and I would like to replace my many dozens of Zapier zaps. However, I am having trouble finding any documentation about it. There isn’t even a community tag for it! When I do any kind of search I come up with nothing. Anyway, I’m stuck in a couple of places, and I could use some help! I have a very large and kludgy Airtable base for my work that has Projects, People, Tasks, LineItems… over 30 tables, and the information is all connected, which is the purpose of Airtable! The most typical automation is to create a new linked record in several tables when a project is created. First I found a Script that would do this, and it works great when I click the button. So I copied the script into the Automation to be triggered automatically, and even though I’m passing in the RecordID using the config structures, I just can’t figure out how to make it work. I could use some help there. Here’s the code: let config = input.config(); let recordId = config.

Hi all I have created an Unfulfilled Daily Orders view that filters orders that need to be put into production (handmade beanies :slightly_smiling_face: ) . Unfulfilled Daily Orders Link I need to AUTOMATICALLY create a table or view from this that summarizes the orders by SKU and the quantities needed so we can see what we need to produce. This table will look like this… Production Required I have created this Production Required table manually using a combination of linked records and roll ups and it seems to work fine. However, I need this to be created / updated automatically when new records appear in the Unfulfilled Daily Orders view. I was hoping someone could suggest a way this happens automatically with an automation or scripting block script. Please help! Thanks Claire

I want to use the new Airtable Automation Update Record to update a single select field when it appears in a view. The field is a status field. I have an automation that emails the person on the ticket to have them schedule an appointment when it enters my Needs Appointment View. Would like to use update record automation as well to change the status from blank to sent email to schedule meeting status. When I attempt to set this up, I get invalid input error. Any ideas?

Hi there, I’m new to the community so apologies in advance if this is posted in the wrong area. What I’m attempting to do is use the Automations function (next to blocks) to send an email when a new record enters an Airtable view: Trigger: When a record enters a view. Action: send an email. For the email address, I’m asking Airtable to lookup the email address from a linked record ValuesBy LinkedRecordId. When I select this, I receive the following error in red: ValuesByLinkedRecordId cannot be converted to a string When the action is changed to send a slack notification, that same email field shows a preview and appears in the body of the notification. I’ve tried changing the email field to short text, adding quote marks and commas, all unsuccessful. As a new user, I can’t attach screenshots to this topic. Hope this is enough info. DThanks

I have used different relational databases in the past, very new to Airtable. The solution I seek is to automatically lookup data from a large table matching the value of one field in a newly created record in a separate table. I tried using linked and lookup fields for this without success, cannot figure out how to make this work. Schema: 2 tables. Table 1 (inventory) has a list of all parts ordered for the project. One field is called “inventory number” populated with an alpha-numeric code. This table has a few thousand records. Table 2 (receiving) has a field for the scanned bar code, creation date-time, user, and “inventory number”. This table is only populated via the Airtable mobile app for the bar code scanning feature. Workflow (via mobile app) User opens Table 2 (receiving), presses the + sign to add a record. User scans the bar code. Bar code data populates the bar code field. User looks at the “inventory number” field on Table 2 to check that matching data was pulled from Ta

Hi all, I am new to Airtable and using Airtable as a CRM and Transaction Manager (Started with the RE Transacting Mngmt Base Template). I am wanting a “Lead” automatically switch to a “Client” in ‘Single Select’ when I link to a transaction. I am also having trouble having Client Database automatically update with Transaction information when I select the client in a Linked Field in the “Transaction” record. Is there any way to accomplish either or both in Airtable. Thank you in advance for any help.

I’ve been working on an automated loop for a couple of weeks and I don’t seem to be making much progress. This is for a research participant database. I have a record of the last time they were contacted. In 90 days past the date of last contact, I would like an email sent automatically asking if they would like to continue to be in our database. They fill out a form, hopefully with their names/usernames/emails/phone numbers already populated, but with the option to edit their personal info in case something has changed. The form also asks if they want to participate in future research. This form automatically updates their entry in the database and timestamps when they opted in/out of future research. After 90 days, those who opted in get another automated email, and the cycle repeats. So after a couple of weeks of research/trial/error, this is the process I imagine I should be creating but have not yet been successful in executing: I’m trying to get Integromat to identify when the fi

I am working on documenting a language. I have a base with two tables. The primary field for the first table is “Words”. Examples of records in this field: Car, Day The primary field for the second table is “Phrases”. Examples of records in this field: new car, fast car, cloudy day, day of rest I want to create a linked field on the first table so that I can see all the phrases that contain the word. So, in the row for “car”, I want a record that will show me “new car” and “fast car”. I know how to link tables. It’s quite easy. I want to know if it’s possible to automate this. Right now, it’s quite cumbersome. I have to go into the linked field and manually add all the phrases that I want. I want to automate this so whenever a phrase is added on the second table that has a certain word in it (that matches to a word on the first table), it will automatically pop up in the linked field on the first table. Is this possible? If so, how can I accomplish this? Thank you very much in advance

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