Automations

Hi, I’m looking to set up automations to remind me of due dates. I was using a datetimediff formula, but it says NaN. I want to take todays date-the due date and have it show how many days until the due date, then I was going to schedule an automation to send out whenever tasks are due in 3 days or less. The formula I’m using is: DATETIME_DIFF({Today’s Date}, {Due Date }, ‘days’)

I have a table for tracking sleep as well as a second table to track how long I was awake each day. I’ve been filling out the “Awake” table manually so far, but I’m trying to have it automatically populate. So far I have the table successfully linked to the date, day, week, and wake time, but I’m having trouble filling the bedtime. I need to link to the bedtime from the record from the day before the current record is linked to. The previous record would also work. I’m not sure how to do this. I’m very new to automations in general and trying to practice. Help? There’s probably something obvious I’m not thinking of

Hi Dear, I try to create a table for Calls (duration, caller name, description, some statistic data about the caller (sex, age, location)). I have another table with Regular callers, who calls us frequently, with all the their statistics (sex, age, location). In the Calls table there is a linked field to choose the regular caller. I would like that if I choose a regular caller all the statistic data I already recorded in the regular caller table to be copied in the Calls table. But lookup fields are not good solutions for this, because if the caller is not a regular one (regular caller field is blank) I need to give these statistics here manually. In case of lookup the system does not allow it. Is there a solution for this? Thanks a lot Tamás

I have a view that is grouped by a single select field called Program Name. In this view I can see a count of records per Program Name. How can I create a script to give me a count of records grouped by program name? Ultimately I want to create an automation that will email me a summary of records by Program Name. I cannot do a linked field as the Program Name is a single select field chosen by a form.

I’ve got a base with three different forms feeding it. One is for people, the other is for tasks, the last is for a reward. As rewards are submitted I want to randomly pair the reward to a task. Is there a way to automate this process?

Hi, I have a base that has two tables with linked records. Table1 fields : Name, Number, Sum (linked to table2) Table2 fields: Name, record, Table1, Total (roll up value of each category of name) This works beautifully manually, for every new record i create in Table1. But has been failing in automation. This is what I am doing: Trigger on new record creation: Note: in table 2 I have a row with unique “name” from table 1. In this action I am trying to find the record with name == name of the record created.

Hi. I’ve set up a few automations with no problems, but I am not sure how to do this one… or if it can be done. I have an AutoDate column, so when a form entry comes in, it auto-dates the entry of the form. However, I need to then copy that date over to another column (also called Date). That second column, called Date, is used in another formula in the sheet, and I need to be able to edit it (in a way I cannot edit the AutoDate column). But since they are the same 95% of the time, it would save me time if it could auto-populate. So, in short, how can I automate copying date from the Auto-Date field to the Date field? Is this possible?

I am experimenting with Webhooks to move data back and forth between bases. I just want to make sure what I am seeing/doing is necessary. When I setup a test POST from an external tool to test the webhook, any data elements defined the JSON are created as values in javascript editor. However, I would prefer to read the entire json object as new fields may become necessary. What I did was create an object that looked like this: { "theData" : "Anything" } I tested the webhook and “theData” was available to the script editor. I then created a more representative object like this: { "theData" : { "fieldOne" : "Some data", "fieldTwo" : "More data", "fieldThree" : "and even more data" } } This works fine and my code is working. Is this how I have to set it up? If I send the second structure as a test, the script editor forces me to select one of the

Is it possible to add data to Airtable simply by sending an email to a predefined email address?

I have 6 workspaces bases that I would like to organize in a particular order. I am unable to drag, or anything else. I see that others have posted this question, but I don’t see the answer.

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.