Automations

I’m running an automation that triggers on a record being created, it is meant to update a multiple select field “Users Created” by adding a new option value to the field. I used the general solution recommended by others which is: The result being that it when it updates the field it returns an empty option value paired with new value, completely erasing any existing values on that field. I thought this might be an issue with the multiple select field but I tried it for a Long Text as well and it can’t seem to find the past values when I list it like this and gives this empty + new value result as well. So I’m not sure if I’m missing something

Hi there. I’m experiencing a strange issue. I have a number of records that contain a URL to a PDF. When I click on the link, the PDF opens. Howver when i update an “attachment” field with this URL, the PDF doesn’t get stored. I tried this via API (integromat) as well as via an Airtable automation. Airtable keeps refusing to store the PDF. When I manually click on the attachment field and add the URL, the PDF gets properly stored. What could be the reason for this behaviour and how could I fix this?

Hello guys! I would like help creating a “Monthly Billing” table. The question is: I have a table called “Jobs” where I add all the jobs that my clients ask me for, this table contains several columns, including a “month/year”, and also a column referring to the value of each job requested. Now I would like to create a table referring to the “Monthly Billing”, containing the “Gross Monthly Billing” and the “Net Monthly Billing”. In “Monthly Gross Billing” I would like it to be the sum of the value of all jobs referring to month “X” in the “Jobs” table and in “Monthly Net Billing” I would like it to be {Monthly Gross Billing} - all values ​​from column “Cost/Month” of a third table called “Cost of Operation”. It would be very important that this table called “Monthly Billing” could be organized by Month. I’m new to Airtable so I’m still learning how it works, thanks so much for all the help. I put some pictures of my tables to make it easier t

Last night I was trying to update an automation when it crashed. I now can’t open the automation and it gives me the error has occurred error when trying to open the automation. The automation still works and is set to ON but I can’t open it to make any changes. Any suggestions? I’ve tried to clear the browser cache with now luck and I haven’t heard back from Airtable support yet. Cheers

I have an automation that hits a Twilio Studio Flow URL from a script and runs every 15 minutes. I get the first record that does not contain a checkmark, use that record, and then add a checkmark to the record. Eventually, all the records get a checkmark, and when they do, I want to start the script over (by unchecking all the records) or tell the script to stop running

Hi! I am working on an HR base. I want to create updates between two tables: Interviewers & Applicants. There is a link to another record field column called ‘Interviewer’ which shows which team member will interview for a particular role. I want to set up an automation so that each time we receive a new job application (Applicants table) for a particular role, the link to another record field Interviewer field will automatically update with the team members name who is going to interview them (which is already predetermined)? Is this possible? Thank you, Lizzie

Hi, How can I send a monthly email to an updating group of email addresses? I need a specific email to send on the 28th of each month. I have created an “email” field under which I have different email addresses in each cell. These are the addresses that the monthly email should send to. It is important that if I add or delete email addresses from the grid, the recipients of the email will be updated. So if I delete an email address from the field before the 28th of a given month, the email will not send to that address. If I add an email address to the field, that email address will be included in the monthly emails. Is there a way to do this? Thanks

Hi, Does anybody know if webhooks from airtable.com support websub? I am trying to subscribe to a service and have messages sent to an airtable webhook but without any luck. I assume this is because the publisher is using websub.

Hi, I am looking for finding a way to create an automation to create record from Outlook mails easily. The way I was thinking to do it is to move or duplicate an Email in a dedicated folder to “mark” them as “TODO” The problem is that I can’t manage to find a way to automate this record creation. I have absolutely no idea on how webhooks are working and if it can do something with outlook and I can’t find any easy answer Does someone have any idea or any ready-to-work solution?

Hi there, Airtable community, You’ve helped me before on numerous occasions and I’d like to extend my warm thanks. Couldn’t find an answer to this one, though: I have public users creating records in Table A using a form view. In one field, they’re able to upload attachments. The records created end up in Table A, named “Entries”. Then, I use an automation so that every attachment uploaded to a record in Table A is created as a new record in Table B. Works like a charm. Unfortunately, if the Attachment column contains multiple attachments, only one is handled by the automation. So here’s the issue: how can I split multiple attachments from one record in Table A and create a separate record for each one in Table B?

Hello everyone! I need to combine several records into one so that records with the same key accumulated all linked records in one field. That is, the table looking like this: …would be transformed into this: Any advice is much appreciated.

Hello! Sorry if this has been asked before, searched through the forums and didn’t quite find the answer I needed to solve my problem. Context I have an Inventory Tracking base with multiple tables inside. One of the tables is a Purchase Orders table to which I add any purchase I made. The problem is that it’s getting very lengthy and I’d like to break out all the sales and profit information into it’s own table. Want What I’d like to do is create a Profits table and have it automatically pull in every record from the Purchase Order table. Ideally I’d like to do this without any 3rd party tool as it will allow me to share this template with my friends and have it just work out of the box. Thanks in advance for any help!

Hello! I have a script to pick a collaborator from another thread. I’m telling the script which collaborators to choose from as not all would be assigned to a record. However, when I’m running the script, it’s consistently only assigning the first collaborator in the list. Does anyone know how I can modify this script in my automation to basically round robin the collaborators? Where if it picked Collaborator1 this time, next time it picks Collaborator2? Or even, at a minimal request, get the script below to actually pick someone other than the first one all the time? :slightly_smiling_face: I so appreciate this communities wealth of knowledge, so thank you in advance! Trigger: When new record is created Action: Run Script const collaborators = [ {name: "Victoria Ward"}, {name: "Jordan Gill"} ] const chosenOne = collaborators[Math.floor(Math.random() * collaborators.length)]; output.set("chosenOne", cho

I have a form that requires an attachment for a conditional field. I’ve tested the form and I haven’t been able to submit without the attachment, but others are getting through without the attachment, which means the team has to follow up and request the additional information. I’ve tried to create an automation that will email the person submitting the form that they forgot an attachment, but the automation has failed. Does anyone have suggestions on how to set something up or to help us ensure the user includes the attachment(s)? Thanks.

Hello everyone! Is it possible to retrieve the record name having it’s id without the need of requesting the whole table which contains this record? By other words, if I know there is an object {id: “something”, name: “something other”} and I can get it’s properties let obj = {id: 1, name:"object name"}; console.log(obj.id, obj.name); Can I make a reverse? Say, I know recordID, it has a unique value. Can I retrieve the name belonging to this recordID? Thanks in advance.

I have seen several topics similar to mine but have been unable to get this automation working. My goal is to send an email per record in my summary table at the time defined in the “At a scheduled time” trigger. Each record contains, among other fields: 1) Name, 2) Email Address, 3) Lookup field with a list of items, e.g. “item 1, item 2, item 3”. So, the list of items would be different for each record. At the scheduled time I want to send one email per record to the Email Address field and include the list of items in the lookup field. I was using a Find action to locate all records in my table that have linked records, and therefore have values in the lookup field (using a view to find records). But when I preview my email, I see all the values of all linked records concatenated together, as well as all the email addresses concatenated together. I was hoping for one email per record with values from that record.

Hello everyone! I made a script that is triggered when webhook is received. In my script I created a finalObject that has all the information i need. My question: I have my own React-Nodejs app and I want to show this information, is there any way to get that finalObject from my own app? like making a get request to get the finalObject. I don’t know if i made myself clear, but thanks anyway!

Hey all, I need to write an automation for the following scenario: New record comes into a View (a potential customer is “Qualified”) Send data from that record to my estimating/invoicing system FreshBooks to create a new client. They have an API where this is possible – just need to figure out how to write the JS code to call the API. I’ve written some automation code before with AirTable in JS – so I’m familiar with writing JS in and of itself…its just the calling the API part that I need some assistance with. Thoughts? Thank you, everyone, Dinos

Hi I am new to airtable and would like to have some assistance from this community. I will try to explain what I want to build and hope that you can help me with some guidance how to do this. I want to create a database of let’s say 100 customers. Each customer has a couple of parameters that can change each year. For example: Total number of employees = 10, etc… Now I would like that on 2 different moments of each year these customers receive an template e-mail where we ask to fill in the potential changes of these parameters. If they complete this proces, the new data has to be send to the database and be filled into a new e-mail template that automaticle will be send to an e-mailadres that is also listed in the database in the record of this costumer. In a perfect world I would like to gather the new data via VideoAsk by Typeform. I hope this is a clear example. Please feel free to ask further questions or give more advice then asked for.

Hello! Estate Agent looking for a quick way to schedule our viewing requests. We get anywhere from 15 to 60 viewing requests per property we sell, and would like a quicker way of organising them. Currently we ask for peoples ‘general availability’ over the coming week (we list properties on Monday’s normally) - from here we put it all into a spreadsheet with their preferred day, then confirm appointments to them after about 1-2 hours of working put a schedule where EVERYONE can get a viewing. We’d use a tool where people can book themselves in, however 1) with so many viewings if people book themselves in people miss out and 2) on one or more days you get people right at the start of the day and one at the end of the day, so makes the rest of the business inefficient (we are a two person team so super important to be as efficient as poss) Is there a way of creating a table where we can put in peoples availability and it organises it into the most e

Hello ~ I’m sending out weekly automations to our staff on Mondays. The first one went out this past week and we noticed that we would like it sorted by date. Is this possible to do?

Is possible to send an automated sms using only Twilio (or similar apps) and Airtable, avoiding the use of zapier or other third-party apps?

Hi everyone! So, we have a synced Google calendar in one table and want to create an automation with that information in another table, either updating if person exist already or creating a new one. We are having trouble with the dynamic fields though, is there anyone that could possibly help with this? Thanks!

I want to use automation to send a tweet when a date field is a day after today. But I don’t want all records that match that condition to trigger sending the tweet at exactly the same time. The actual time could be any random time during the day or spread out at fixed intervals. The important thing is that they go out on the correct date but don’t go out at exactly the same time as there can be any number of them and that would be poor form on Twitter. :grinning_face_with_sweat: My thinking is that I can have two conditions, one for the date and another that matches the current time with a sequenced or randomly generated timeslot. But I cannot quite work out how to do that second part… Any ideas?

Hi everyone! So, we have a google calendar synced to our base in a table. We are trying to take the information in that table’s description field and extract elements (which we did with the regex formula) and create a new record in a separate table with that information. It’s giving us problems. It doesn’t allow us to use a field with a formula on the create a record. Any suggestions?