Automations

Hello, I am trying to create an automation where when every 10 new records is created in the airtable base it automatically create one new record with the data from all those records (thus, create one record with 10 record data inside), and then it will move that record to a new view. I will then create a zapier automation where when a new record is added in view, to add to an rss feed. My goal essentially is to have the following: every time someone fills out an airtable record, it only creates a new record if 10 were created total. I do this so that I can create a digest email via an rss feed welcoming new members.

Hey there… When you click a button on a record to trigger a script, you can use “input.recordAsync” to get a reference to the record/row of the button you clicked on. I would like to have 3 or 4 columns, each with a button on them. Instead of using a whole new script for each button, I would like to just know the name or id or field of the button that was clicked, so that I can know both the record AND the field (button) that was selected so that I can run an action specific not just to the record but also the button that was clicked. Is there any way to do this? If not, could the dear engineers at AirTable do the same thing you did for input.recordAsync and make it so input.fieldAsync would also return the relative field name the first time it is called if it was triggered by a button? It would help me to organize my code so much better. It’s also a pain having 4 or 5 different scripting Apps for a handful of simple actions. The only workaround that I can think of is

I see there is a template for employee on-boarding, however I’m also interested in automating 30-60-90 day reviews/check-ins. As we add employees I would like to have an automation notifying the employee and HR when they hit these milestones. What is the best way to accomplish this goal? Thank you.

Hi everybody! Google Docs automation works for me, but lacks some flexibility. For example, I generate meeting notes digest and would like to add a Date when document was generated in a Title of the document. There is a token TIME which allows inserting complete time, but I have no idea how to format it or truncate unneeded time part. Any ideas how to workaround this? Regards, Andrey

Hi, I am sending an automated email with an attachment. When I generate a preview and test the automation I get this message “Configuration has been updated. This preview may be out of date”. I have done similar automations before so am a bit confused to why this is happening if anyone can give me a solution or advise me on the matter I would appreciate it. Thanks Sean

Hi there, I would like to post a json request to an api with the locations on my base. The json structure looks like this: { "stops": [ { "id": "order-1-dropoff", "position": { "lon": -96.7524, "lat": 32.65764 }, "quantity": -15 }, { "id": "order-2-dropoff", "position": { "lon": -96.82663, "lat": 32.6498 }, "quantity": -10 }, { "id": "order-3-dropoff", "position": { "lon": -96.9925, "lat": 32.8922 }, "quantity": -15 }, { "id": "order-4-dropoff", "position": { "lon": -96.99433, "lat": 32.89166 }, "quantity": -5 }, { "id": "order-5-dropoff", "position": { "lon": -96.88486, "lat": 32.81559 }, "quantity": -20 }, { "id": "order-6-dropoff", "position": { "lon": -96.85313, "lat": 3

Hey Guys, I am trying to set up Automation between Teamwork and Airtable wherein everything comes from Teamwork to Airtable e.g. any new entry in TW should come to AT, if deleted TW, should be deleted in AT, if updated in TW, should be updated in AT. So, its all one-way automation from Teamwork to Airtable. For this, I am using a Webhook module of Airtable, wherein if Airtable receives any webhook, that will trigger the action in AT. I am stuck at “update record”. so I am trying to update the existing record when there is any update in Teamwork. When I am trying this, I am not really sure how to do this. “Update Record” requires Record ID. Webhook from Teamwork does not have record ID. So I tried searching the record using field value but it says “this property can not be used right now”. I am not sure how to do this. Can someone please help? Thank you

Hi - I want to run an automation where, on a repeated cadence, send out a personalized email, if date range matches my specified date. How it should look: Every 3rd week of the Month (Trigger) Look up records with Date Range within the previous month (action) Send out a personalized email to each of the records, where it goes " Hi Emily… " next email “Hi Josh” (action) However, right now it’s showing up as “Hi Emily, Josh” and to “emily@email.com, josh@email.com” It’s showing the entire list of records… Any ideas or success stories? is this a possible feature within Airtable?

Does anyone know of an automation, zap, script etc, that can be combine two or more .mp3 files into one mp3 file? I have a strong need to take small audio clips in my table into one mp3. I’d be interested in paying for this script if necessary, if someone know exactly how to make this work.

I can use to automation “Slack:Send a message” to send messages to slack channels. But when I select a user, instead of a channel, from the Channel/User dropdown the message is sent to the Aitable channel on Slack. Any ideas?

Hi, I’ve just started using Airtable. Here’s a list of what I have done and trying to do Imported a CSV of my credit card transactions and added a new column called category. Want to automatically fill in the category column with “KFC” when the transaction description contains the word KFC. Made an automation. See picture for settings I used: Now I have turned the automation on but it will not auto fill for category field for all the existing transactions I already imported from my CSV file. It only works if I test run it and select a matching transaction from the list that comes up. How to fix?

Hi When I run my Automation to Update a record it changes the membership Number. In My row I have a unique membership number, But when sending the link to the member for updating when the form is returned the information is updated But it also changes the persons Membership number. How do I stop that

Pabbly connect is a platform that works like Zapier. It can create new record, update record or delete record. I have a record which has a linked field i want to update. I cannot “Add” records in this field using Pabbly but instead i always replace the old record and substitute it with the the record. Any idea? Thanks

I have created a form that is prefilled, Once submitted, I would like to share the form with the person submitting it so they can edit or add information they may have left out. I have managed to get an automation to work that updates the record thanks @Vivid-Squid I sent the form link to a friend who filled it out and submitted no problem. I then sent the URL for them to up date via whatsapp. When they tried to open it on the cell phone they were directed to the play store to get Air table. Is there away around this? Many thanks

Hello, I was wondering if there is a way to split a single pdf into multiple pages using Airtable. For example, if I add a 20 page pdf to Airtable, is there a way to have 20 rows of single page documents in Airtable automatically without uploading them separately? Any assistance would be greatly appreciated. Thanks!

Hello guys! As far as I can tell there is no way to include a page designer page in a email automation at least natively inside of airtable. Is there some other way to do this? With external tools and such?

Hi everyone, I need you regarding my project. Indeed, it composed of a web app, a mobile app and Airtable. My question is : How do I send messages (notification or just communicate) between a web app and an mobile app? To explain a little bit more, the database is the same for the web app and the mobile app BUT the final users of those aren’t the same. So, let me give you an example : I’m the user on the web app. I’m choosing a person with his email, writing a message such as “hello”, then I’m clicking on a button “SEND” and after that, when I use the mobile app, I’m connecting and I have the message “hello” on my account. Is it possible to do that ? If so, don’t hesitate to give me tutos or other topic regarding my project. Thanks in advance. Kind regards

Hi, I am using this formula and it isn’t implementing the decimal places from my {Refill / lowest price} column, which in itself is set to 2 decimal places: "Lowest cost per " & {Unit} & " based on: " & “£” & {Refill / lowest price} & " for "& {Lowest cost option} It is bringing back things like the following; “Lowest cost per wash based on: £5.3 for 24 capsules (fragranced)” If I go to formatting it gives me “Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date.” But is there any way to ensure it ‘pulls’ the number with both decimal places? Thank you!

Hi again all, So I have start date column & a status column. I would like an automation where once a start date has been met it changes the status from ‘not ready’ to ‘ready’. The only options I can see are if its today, but then if goes past this, will it incorrectly change the status again?

I’m using an Airtable form to allow employees to register for trainings. I have created the form and it’s been working fine for me. I already have an automation that automatically sends them an e-mail with the class they signed up for, but I’m trying to modify that automation so that it sends them all of their “registered classes”. I have the automation working fine for this. I’m using a find records to look a condition for when someone’s name shows up. It sends an e-mail of the list of classes in a grid fine, but for some reason they aren’t organized by date like they are in the view. I feel like I’m missing one small detail. Any help would be greatly appreciated. How do I get these to show up in order of start date?

I have about 500 air table records with protected slack attachment links. I want to somehow either extract these attachments, or make the links publicly accessible for externals. Is there an existing script for this?

Hi there - I’m a bit stuck if I can do this with Airtable and definitely can’t get it to work with Zapier, so wondering if you can give some insight… Here’s what I’d like to have happen: Member joins program and chooses a 6-month payment plan Their 1st payment gets imported into AirTable 5 automatic records for their subsequent monthly payments get created so I can track projected revenue I thought I could do this in Zapier by using the date modifier (of adding +1mo to the current payment date), and although it imports, the date is left blank. Is this a formatting issue? Any other ways to do this with Zapier? Can I do this with Airtable instead? Trying to keep it as simple as possible!

I want to automate this but I’m not sure on the setup, maybe this isn’t the best place to ask, but here we go… I work in a university career center, we use Airtable to manage a student-alumni matching process. Alumni opt-in to be on the list, students can request a connection (OPEN the process), we facilitate via some automated emails, students (ideally) report on the outcome to CLOSE the process, rinse, repeat. I would like to create a way to limit the number of OPEN requests that any one student has at a time. The unique ID for students is their email address, but we can only collect that via anonymous form because FERPA. So I don’t think we can have a linked table of students to use a count field, unless that can be dynamically created and updated behind the scenes. So, how can I setup AT so that each time bucky.badger@wisc.edu submits the from, it will count how many existing requests with that same email address match certain conditions and then flag someho

Hi guys, I need help because have an issue because with a Gmail > Send email automation… On the technical part it works quite well! However since I’ve been using this Automation, my collaborators are telling me that my emails are received in spams! Internally, that’s not a problem because they added me to their ‘not spam list’ but it is a huge issue as I use them for recontacting my leads and clients… Do you know what I can do ? Thanks in advance!

I have separate registration lists for a series of events we are running. I would like an automation to combine the registration lists when a new record is created, so that this list is the definitive list of all unique attendees at every event. If the same attendee appears in multiple registration lists, I would like a singular record to be created, but I would like their multiple select attendance field to say they are attending both events. E.g. Daniel attends Event 1 and his record is created in the combined registration list table and his attendance updates to Attending Event 1. Daniel then signs up for event 2. His registration already exists in the table so rather than creating another record for him, the multiple select field for attendance updates to say Attending Event 1, Attending Event 2.