Automations

Hello!I have a large amount of sales records that I need to automatically transfer from an "Ad Chart" tab to another "Production" tab, to be assigned to various designers. I want to be able to check first if a record already exists on the Production tab before the automation creates a new one, to prevent duplicates. I've already tried the "Find Records" action and while it works initially, we simply have too many records for it to check (I've read that the limit is 100 records), so this will not work at scale. Looking through forums and help posts, it seems I would need a script to accomplish the search, but I am wholly unfamiliar with scripting. Any suggestions?  

hi friends! we are an organization that provides online trainings. i have a base with registrations in one table and a unique attendance list in another table. the other table has a list of all the trainings.so the registrations table is all the registrations we received for each training, so that we can see things like: 100 people registered for training X, 80 were approved to attend (either because they were members or they paid), and 70 actually attended. because people attend multiple trainings, this list contains different registrations for the same person.the attendance table is a list of each person who ever attended a training with a related record field that contains all the trainings they attended, linked from the list. that way we can see things like: 300 people attended our trainings last year, person X attended 4 trainings, Y organization sent 4 people to trainings last year.i have an automation set up that after a training happens & we record the attendance, it takes

So this is fun… suddenly my Webhooks are returning 404’s… it was working literally 15 minutes ago… oh well Any idea why this is happening? I’ll check the previous webhooks I’ve created but very conufsed as to the sudden change to 404 errors

Hey there!I have two tables. One contains projects, and the other contains tasks. I want to update the status of a project (from pre-production to production) when a certain task is checked off. How would I go about doing this? 

I have two tables - one with orders and one with inventory. The workflow I want is that once the order is ticked as received, it would automatically eithera) find the existing item and update the stock level orb) create a new item if the item is new and there is no existing item.I'm focusing on a) now, since it's more complex. I was able to use Find records to find a unique match from the inventory table. Then I created a conditional action, that checks whether the amount of inventory items is exactly one.The action is configured to run and match the record ID of the inventory item found in the previous step. For that record there exists a number field called "Current inventory" that has the value 500. In the order table there is a number field called "Processing amount", which has the value 17.I'm able to update the Current inventory field with the value 500 -> 17, but what I want to do is add these together to get 517. What syntax should I use in the fields? I've triedCurrent inve

Hi, I'm looking to just get some sort of identifier of the button pressed.  I would like to have several buttons run a single script and just identify which button is pressed in the script.I was following this code from the tutorial for getting the button working, but not sure what to access to get the label of the button pressed.  Just the record.      // Change these to match your base. let table = base.getTable('Tasks'); // When run from a button field, the script skips the prompt // and automatically uses the button's record. let record = await input.recordAsync('Choose a record', table);     

Hi Airtable Community,I have the error as shown in the subject in my script. I am struggling to determine the field that it is referring to. Is there a way to identify fields by this "code" or am I missing something? I have no linked fields in my table.Thank you!

Hi All,I made some changes to my form and now I am unable to generate it.  Error msg in Screenshot.I went to back to previous versions (snapshots) and got the same error.So now I am stuck. Would appreciate any help.  

I am confused on Airtable notifications.  What I want:Setup custom automation so that when certain status' change, then a notification can be sent to user(s). The notification should come through in AirTable notifications first and foremost, and email as secondary.  What I am getting:Automation sends email to user, but no internal notification in AirTable. This seems backwards? I want to avoid having to check multiple systems and missing notifications until a user leaves AirTable and goes to check their email. then they have to click each email notification to jump into each separate task/project for followup. Why doesn't the system generate a in-system notification as well as the email? or provide an option for this in the automation actions? Currently users are processing any "@" notifications within AT, then having to close out and go to email to find the remaining notifications. However this also has the "@" emails that they already reviewed. So its a

Hello! I am trying to split a single record into multiple records in the same cell. I have a column called "Languages" with single records such as "Arabic & French" or "French & Spanish". I'd like to split all this records in such a way that each cell contains two records "Arabic" "French". Is there any way to do this? Thanks in advance

Hi everyone, I'm wondering if anyone has a solution on how to pull in emails from Gmail so that I know what emails have been exchanged between me and a client?I currently have a Zapier set up to push emails to a table in Airtable, based on a label "toAirtable" in Gmail. Is it possible to do this instead based on the email of the client? I would need to pass in the client's email as a variable but couldn't figure out how to do that. The other challenge I have is, with the current implementation, since the Zapier is set up to push all emails based on a label regardless of which client it is, I now have to link those emails to the client. Is there a way to quickly index a table based on a particular column, or search by field value, without having to iterate over all the records?Thank you ❤️

Hey All,I created a base to keep track of my doctor's appointments (I've recently been trying to see a lot of specialists in a short time while aiming to keep track of pertinent details regarding my visits).I've successfully linked my appointments to Google Calendar, but what I'd like to do (if possible) is on the day before each scheduled doctor's appointment {Email Send Date}, have Airtable update my linked Google Calendar Event with select information (from my Airtable table's fields), specifically my doctor's address, my concerns, notes, and the doctor's phone #. As you'll see in the automation I attempted, my idea was when the record matches the conditions (when "E-mail Send Date" is Today)I wanted to see if I could have Airtable update a Google Calendar Event. ("E-mail Send Date" is a field I've made with a formula listing the date the day before the appointment) I'm not sure if that's the way to accomplish what I'm trying to do, but the Event ID and everythin

I am looking to assign tasks to non-airtable users by sending them via slack. Is there an integration or extension that allows the assignee to complete the task and update the record on my table without actually going on Airtable? It appears Todoist has that sort of feature but I'm not finding anything on Airtable that enables this. Thanks in advance.

Hi Airtable community!Does anyone know if there's an intermediary (like Zapier or Pabbly) that can link Airtable automations to personal Facebook profiles and personal Insta accounts?  As far as I can tell, most seem to only allow posts to Facebook 'Pages' and Insta business accounts.  Thank you!!John

I have an automation that emails the list of records in the body of an email as soon as a form is submitted.  One of the fields in the form is a multiple select field.  When the email is opened in the Outlook desktop version, the selected values are all together instead of separated.  When I try other email clients (Yahoo, Gmail, Outlook on my phone) the values are separated as they should be.  Does anyone know how to adjust the formatting either by adjusting a setting in Airtable or something in Outlook?Outlook Desktop:YahooThank you!

I am sending tasks out via slack and would love to have the various Slack users mark/update a task as "completed" without having to log into airtable. The only way I can think of doing this is by create a form just for the task status. Are there any other ways?

Hi everyone. I’m using some rollup fields in a way that is only really useful if I can automate the linking of new relevant records to that rollup field’s record. Right now, the automation simply overwrites the old record link, rather than adding an additional one. The link field is set to allow multiple linked records, and I can add multiple links manually. Is there a way to configure this in the update record action? I am stumped.

Hello!I am currently looking to download a file from an attachment field within an  Airtable Script to send it in an API Call to a REST Api, however I am having issues with downloading the attachment in the script.I have tried downloading the file via a fetch to the download url, however all I am getting back is the download link back.Any help on this would be greatly appreciated!

Hi,I have two tables that are linked. I have table 1 that consists of the membership information:Email (primary field)Last nameFirst namephoneI have table 2 that adds records after submission of a form. This consists of visits you can do once you are a member: ID (primary field)Email (only field to be filled out in form)Last nameFirst nameDateThe idea is to create records of each visit and it should autocomplete the fields (last name, first name) on table 2 pulling them from table 1 based on the email (matched field). The key here is not to manually select the "link to table 1" field but it should be done automatically.Please I would appreciate any suggestions.

I need to amend my previous so please run with this one.  I am importing data from bitquery, that data is being appended to my main table.  I need to compare the currency values for duplicate records, replace and delete the records without ruining the links made with other tables.  Let me know if you have any additional questions.

I am running a simple automation to identify birthdays for the upcoming month.  My 'Find records' works beautifully when I test. My second action is to send the list of birthdays to specific managers. The action works, but the email produces a blank message and I know there are hits. What am I missing?Thanks in advance

I have a scenario in Make that sends Emails with attachments from Airtable.The attachments are photos that are supposed to be embedded in the Email.It doesn't work as expected, the photos look like this in the Email:It has worked before and I can't figure out what has changed.Can you help me with this?Thanks

Since manually adding a comment doesn’t go into any existing “fields” of the table, I can’t use trigger to automate this. Can this be achieved using scripts instead?

Hi,I've been using Airtable to track the performance of my company's social media metrics so I can pull out trends based on the topic and format of the posts.The problem is that the data from the posts (e.g. LinkedIn reacts and comments) is not kept up to date because I input it manually. I was wondering if there's any way to automatically pull data on the likes and comments of a certain post from LinkedIn and Twitter into Airtable if I link the relevant post?Please let me know if someone has already asked a similar question, I imagined it'd be a common function people would like but I couldn't find anything online. 🙂

Hi All, I’m trying to automate a trigger that emails a form the day after the date that has been entered in a specific record/field (which I guess you could think of as a “cell” in Excel).So for example, say 1/26 is entered as a date in a specific field. The day after, I'd like to have an automated form sent out via email. How do I do that? Is there a way I can identify a specific "cell?" Can I automate a formula using if {today ()+1} or something like that?Can anyone give me a tip? Thanks!