Automations

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 fro

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

Hi all! First post here. Airtable has seriously changed my life. As someone who navigates the world with ADHD, this platform has, in the span of less than a month, changed the way I work and live. It is nothing short of a miracle. I absolutely love that you can automate tasks through Zapier, and I’d love to tap into that – but I have some questions about automating tasks without the use of Zapier, as I’m not in love with their price tag. $20/month for 1,000 tasks is a little steep, IMO, and, I’d also love to be able to customize the tasks more than Zapier will allow. Is it possible to automate tasks without the use of a platform like Zapier? Example: I’ve set up a marketing request system at my job, and when someone makes a request, Zapier places the request in my Asana To-Do list. I’d love to be able to do that without Zapier, but even more, I’d love to be able to add a checkbox in my Marketing Requests Airtable base (or in my Asana to-do list), and when I check the box to mark a task