Automations

Howdy, I am trying to append my airtable records to a google sheet at regular intervals, including my last modified column. How can I get it to append the actual value, and not just the character length of the value. I’m getting results like 29, 30, 29, 29… for my rows instead of 8/18/2021 10:27:31 or whatever

Hello and Good Day again! I'm writing this as I have what sounds like a simple yet complicated automation issue that I can't seem to get right. (For privacy reasons I have changed the name to different authors I hope you understand)Anyways, we had a programmer create a setup where our website updates the tables automatically whenever someone books us. So, table 1 here has customer names and the date they booked our mechanics. (The data in this table is updated from our website)Table 2 (also updated from our website) is basically a contact information about our clients and their vehicles. As you can see in Table 1, it's basically the bookings so any of the clients can re-book us and it will be logged separately (Mary She

Is there a way to run an automation where I can find the next empty cell in a column? I am trying to run an automation where the next empty cell in a column is found and then copy some value from another table over to that empty cell. For example, I have a table with usernames and passwords and another table with names and empty columns for usernames and passwords which will be copied over from the other table. I know there is a FInd Records action where I can look for empty cells, but that action returns all empty cells and not only the first empty cell. I think I can get this to work by creating a third linking table where I can automate creating new rows with values from both tables but I am sure there is a simpler way to just find the first instance of an empty cell on a column. Name Username Password Peter User1 Password1

Javascript baby here. My ultimate goal is that when a record is created and matches conditions, a script will run that will duplicate that record a number of times and update it's status. I've been modifying a duplication script from an extension script, but I'm a bit stuck on how to make it work for an automation, and if I'm even doing the right thing. If you have a moment to take a look, I would really appreciate it!Here is the code as it stands:let table = base.getTable("🏁 Tasks") let fields = table.fields let query = await table.selectRecordsAsync({fields: table.fields}) let records = query.records //I have a set number of records that will need to be duplicated based on information from the base which I think should be inputConfig.numRecords let inputConfig = input.config(); //exluding only one field let exclude = ["Dependent On"] let filteredFields = fields.filter(x => !exclude.includes(x.name) && x.isComputed == false) //I'm

Hello all,I am currently trying to send an automated email to a target person once a certain date assigned to them is reached. As of right now, I only see triggers for when a date is an exact date, but it must be the same date for the whole base, and not dynamic per each certain date that is unique to each target person. Simplified: I need to set a trigger for a date that is set for individual rows, is this possible?Thanks!

Hey Airtable community,I hope someone can help me 🙂 I am having a table in airtable with different projectflows in each record. In a collumn of the record the email of the respective POC is entered. Once a month the POC is asked to update different other information in the records. For this I would like to send a monthly reminder to all POCs who have not updated their records yet. I have managed to create an automation which filters which records are updated and which not and then sends out an email to the list of email adresses of the records which need a reminder. My problem is, that some POCs are responsible for multiple records and would get multiple reminders. But I would only like ONE email to be send to each POC. So if an email duplicates (or more) I would like it to be used only once. Does somebody know, who I can do that ? 🙂 Thanks in advance. 

what is the email send limit using outlook? i can't tell if there is a daily limit of sending emails only if using the regular airtable email function, or if it applies also to emails sent by outlook.also, is this daily limit per user? or daily per workspace?we've been thinking about expanding our use of airtable to manage projects. but it would involve assigning many tasks to non-users, and it would also mean sending reminders for overdue tasks. i'm concerned that we would potentially hit that limit quickly. thanks!

Hi there,As the title says, I'm trying to send a POST request using Fetch to a Zapier webhook. This works fine, except when the Fetch is placed inside a function, it is never sent.Checking the network log, the request seems to be stalled indefinitely.I tried sending the request using the same code outside of Airtable, and it's working. The request is sent to Zapier.I've scoured Google looking for similar issues but couldn't find anything relevant. I tried async and not, try/catch, and adding headers, but nothing so far. Has anybody encountered this issue before?Appreciate any help and suggestions 🙏 let table = base.getTable("Testable");let record = await

Hi,I currently have several dashboards for client fleets using Interfaces. On these I use the Field Summary to calculate the percentages of a fleet based on whether they are 'active' and within a servicing window. What I would like to do is automate a function to grab that Field Summary data and at the end of the day input it into a new table to historically graph this data for analysing trends. This is already graphed and I simply enter the data manually. I know how to automate the trigger but after extensive reseach I think the only way to grab and record this would be a script.Thank you,

Hey friendsI want to build a content plan for social media according to dates.So:I have several tables for each platform:1. Facebook2. Instagram3. Tik Tok4. Email marketing.In each such table I have the topic (story, post, etc.), the upload date, the content itself and status.I also have a master table that contain date, status, comments and also contain a Facebook, Instagram, Tiktok and email marketing column (linked columns).I want the main column in the master to be the date and actually when I write a certain date it knew to pull me to my linked columns what needs to be uploaded each day according to each platform.For example, I will choose the date 05/18/2023 - it will automatically fill in the Facebook column what needs to be uploaded that day, in the Instagram column what needs to be uploaded that day, etc

Hello,I'm encountering an issue with the automations. I have specified on the tables each datefield with the specific timezone I want to use over them. But, when I run an automation where I send an email with some records, the email receives these records with a different timezone that I specified on the table.I don't know if there is a way to change the general timezone or change to timezone of the base. Which could be an approach to solve this?Thank you for your time community.

Hi there, Im new to airtable and Im having difficulty with formulas in general.Currently on my table is Name, Date and the PromoWhat Im trying to achieve is that every time a new person and the date is added, the person is given a promo based on the date providedFor exampleJohn Doe - Jan 1 2021 - promo 1 (during 1 week of the date)John Doe - Jan 1 2021 - promo 2 (after 1 week but during 2 weeks of the date)John Doe - Jan 1 2021 - promo 3 (after 2 weeks but during 3 weeks of the date)I know this may be difficult which is why Im asking the community for assistance on this part.Thank you!

I am trying to send an automated message with outlook. I want to avoid using a hosted image from a URL, and have an inline image in the mail. This help page shows this is possible by inserting a “render at html” grid or a list, but I can’t make it work: https://support.airtable.com/hc/en-us/articles/360051028394#:~:text=How%20can%20I,your%20HTML%20tags Instead of the image appearing, I get either a ticked checkbox or the name of the field. Can anyone enlighten me what is going wrong?

Hi there!I'm trying to set up an automation that generates dates for each step of our approval process, based on the inputted "Go live" date. For example, if the project needs to go live on 7/29, manager approval should be 3 weeks prior and leadership approval should be 2 weeks prior. Does anyone know how to populate this timeline automatically so we don't have to do the math ourselves and it saves us some time?Thank you!

So I have this automation set up so that if there's no email address where I expect it to be, it can try using another field - but it's getting hung up on the if step. Isn't that the whole point of an if->otherwise condition set up? 

okay, I'm trying to link fields or maybe automate something, I'm new to airtable and after a lot of threads nothing has answered this:I want to be able to add users' names to a maybe-going field on an Events table, and have that trigger populating a maybe-going field on my User table with the corresponding events.  

I want it to automatically copy the data from the XLS text column to the link column. Is this possible? 

Hi I am trying to connect a Custom Webhook to AirTable (Get A Record). I keep running into this error: Flow is empty and contains no configured moduleI tested the Webhook on its own and got a status: 200 but whenever I add AirTable, it becomes status:400Please help, thanks in advance!

Hello,I connected AirTable to PowerBI. I'm getting the error below in PBI - unable to authenticated credentials. Everything I'm reading online says to use Anonymous, which I had been doing so not sure why I'm getting this error now. Any suggestions? 

Hello, I have the table that is pulling information from other table using lookup fields. However, unless I manually assign the initial pull-down record, it wont find any previous information. I am trying to use automation to fix that.I attempted to link record based on  this article however it does not do what I want it to do. The goal is simple. I have Table A, it contains names and all the associated information with those names. I am adding the lookup fields from other Table B, and I want to see what information it contains. I need to connect these two, so the lookup field from Table B that initialises all the following references automatically assigns to Table A field. I tried "Update the Record" and "Find" and then "Update", but it doesnt seem to work. Any help is appreciated!

I have an automation that looks for new records and then copies relevant data to another tab. However! The new records are coming across from an API that often creates duplicates (I can't access/ change this part) and my automation is also creating duplicates (despite setting up a Find function to avoid this) I think because the automations happen so fast they don't have time to find the double? The older records don't duplicate if that makes sense, just when a new set of two gets made via the API.I tried setting the automation to trigger at a given time each day, but then my Find action doesn't work as it can't check a string against text if that makes sense.Can anyone help with a solution? thanks very much

Hi, I saw that there is a new feature where we can set up a basic repeating group in an automation with the aim to get a list of my team members and find each of their assigned tasks for the week, and then send each with a custom email with their tasks. I tried setting it up using the instruction provided: https://support.airtable.com/docs/repeating-groups-of-automation-actionsBut I am getting stuck at "Step 5: Add an action or actions". For example, in my "Step 3: Add a Find records action" it provides me with 3 tasks to be sent, when I add "Send email" to my Step 5 action, it sends the list 3 times.Could anyone help where I can Find record and compile a list of "to-do" tasks assigned to Collaborator A, and the automation will help me send email of that list to Collaborator A every Monday 9am? Thanks,Eve

Hi allI've been trying to make a specific automation for a while, but with no success:I want a (single select) field to automatically change after a certain time period. I have success when making one instance and testing on just one record, but I can't seem to make it work for more than one record at a time and to make it activate by itself.How can I apply the automation to a whole table? I've tried the new "repeating group" but with no luck.Hope someone can help, would be much appreciated!Best,Erik   

Hi there! I'm troubleshooting a workflow we once followed but has since been deprecated.In our filing of documents, we want to rename attached PDF files (in a field named Attachments) that come in as 'unnamed attachment' with the contents of another field (named ID) when a box in a field named "Update Attachment" is checked.This was previously set up using an Automation in the base, with the trigger being "When a record is updated.." and the action being "Run a script" As it turns out, the JS that ran is no longer valid, so nothing happens when the box is checked. To make matters worse, the script was inadvertently deleted during troubleshooting, so we no longer have a reference 😞I have found posts where folks are asking for something similar, but they're old enough that the methods no longer appear to be valid. The problem seems small, but the solution appears to be complicated.... If anyone has any insight, I'd really appreciate the help

Hi, I need help with this thing...I have a Table with some Checkboxes columns and I need to block some of this columns to be checked based on the input of another column. How could I do it?For example: I have checkboxes for Option 1, 2 and 3. In the column A, if it's written Answer A all three options will be checkable, but if it's written Answer B only option 1 and 2 will be checkable. How can I block this 3rd checkbox to be checked in all the column?Thank you in advance!