Ask the Community

Hi Folks,I hope this post finds you well. I'm working on setting up automation in Airtable where a script runs upon creating a record. The script involves an API key, and I'm looking for a secure way to handle it without hard coding.Ideally, I'd like to use something like process.env.ENV_VAR to reference the API key securely. Is there a recommended method or best practice within Airtable for achieving this? I want to ensure the key is stored securely while still being accessible for the automation to function smoothly.Any insights or guidance on this matter would be greatly appreciated. Thank you in advance for your assistance!

Hi all!I'm out of ideas and I need help. I have an automation which sends an email to a specific staff member (it fetches the email of that staff member in my table) when a date field is updated in a record. When I create a record and update the date field before adding the informations of the staff member, the automation ends up with an error message (which is normal since the email field hasn't been filled yet). Any ideas of how I could do the following by using an automation ? :When a date field is updatedAnd the email field is not emptySend an emailBest! David

I’m trying to use automation to copy a record and create duplicates of all the linked records in the original record. Here’s what I’m trying to do:Create a new record and update it with all the fields.Search the other table for all the records that are linked to this one.Use a repeating group to create a record in Table 2 and copy the information from each record that is linked to the new record.Unfortunately, I’ve tried so many ways, but it’s not working. Could you please help me?

Hi AT Community, I'm new to Airtable and ’m trying to create a formula that would display the Monday of the week / "week of" date for a given date. Monday is the start date of the week. I've tried formulas from other posts but when I add the formula to my field, it gives an error.The formulas I've tried are:DATETIME_FORMAT({Date},‘e’)+1,‘days’),‘M/D’))--   CONCATENATE("Week of ", DATETIME_FORMAT(DATEADD({Date},-DATETIME_FORMAT({Date},"e"),"days"),"M/D"))    --DATETIME_FORMAT(IF(WEEKDAY({Date Due})>1,DATEADD({Date Due},-WEEKDAY({Date Due})+1,'days'),IF(WEEKDAY({Date Due})<1,DATEADD({Date Due},-WEEKDAY({Date Due})-6,'days'),{Date Due})),'l')I really just want to get the Monday of the week when the record is created. So if the record was created on, say, January 19, 2023 - the Monday of that week would be January 16, 2023. And the field would display exactly "January 16, 2023."Thank you in advance! 🙏

So I am looking to utilise this, the base I am looking for is I enter a property address and it will create a task list of items such as photography, entering data into our system, safety checks all these to be either as Not started, in progress or completed. Of which the role for certain tasks will never change simply I would like for 1 name/property to be entered and it just creates all the tasks automatically.

Hi there.In a field, I have used the formula below: DATETIME_FORMAT({Datum gesprek}, 'DD-MM-YYYY HH:MM')&", "&{Traject begeleider} Weirdly, the outcome makes the time change by a few minutes. I can't figure out why. Setting timezone, or changing other aspect doesn't help.  Could someone give a solution for this? Thank you!

HiIs there a way to pull a last contact / email traffic date for a selected email address / domain?E.g. I'm emailing with joe@company.com  and I want to have a cell that pulls a date of a last email from Outlook (regardless if its an email sent by myself or by a recepient)Seems easy, but I can't seem to find the solution. 

I am working with a subscription table and every row is an entry every time a customer subscribed to an account (It is possible for a customer to have more than 1 account). I have a field for Start Date and End Date, and I want to know the maximum account the customer had at some point, so I am thinking that if I would know which dates overlapped, I can then record it to a different table but is there any formula in airtable  where I can do that? 

I have the followign problem.In a cell I have a list of tags, separated by a comma, i.e.Apple, Banana, GrapeThen I have a control list of allowed tags, that isApple, Banana, StrawberrySo, the formula should eliminate the tags Grape is it is a now allowed tags, and return this resulApple, BananaAny ideas on how to obtain it?Thank you very much in advanceRegards  

Hello, I am wondering whether it is possible to add an image to the body of the emails that are sent using automation? I want to add the logo of the company to the signature. Thanks Amir-Homayoun

Hey everyoneHoping someone can point me in the right direction.I have a table where I created a custom view and grouped the records based on a "Service type" field. In the table view I get a few different groups with several records in each group. This is working as I would expect.Next, I have an automation that finds these records based on the custom view I created. I then insert the results of that Find Records step into an email as a Grid of Records and have the "Use groups (if any)" switched on.What I get in my email is not expected. Each record is individually displayed within their own section within the group.Hopefully the images below help.Here is what my custom table view looks like  (I had to blur the data)As you can see I have 4 groups (A,B,C,D) and there are records per group. This view is exactly what I am looking to have in my email.But when I insert this view with "Use Groups" here is the result I get in an email. You can see that each record is individually listed

Hi all,  We are a small nonprofit (team of 14 people), who have been using AirTable for the past year and a half. We love its many functionalities. One thing we're hoping to do is integrate some emails into AirTable. Specifically, we want to write a record to an AirTable base when an employee CC's a certain Google Group email. Has anyone done something like this in the past? Would love to see examples if you are willing to share. Thanks,Alex

I’ve followed the steps in this article to sync my base’s calendar view with Outlook. I get the successful import message, but none of my dates show up on my calendar. What am I missing?

Is it possible to edit multiple rows at once? I can select multiple rows, but it seems I can only mass delete or mass share - I want to set a certain field value for multiple rows at once.

I am trying to replicate something that I know I did previously, but cannot find the right options to do it now.I've created an Interface with a page layout that is designed exactly as it needs to be.  (Record Review, but I don't think that matters.)  It is drawing from Table X, with a filter for only records that match Y.I want to duplicate that page exactly, and then change the underlying filter.  So, this page should be identical except that it's drawing from Table X, and filtering for only records that match Z.  (I do not want to add a filtering element that can be toggled by the user of the Interface.)I did this easily about 9 months ago, but cannot figure out how to do it now.  I can duplicate a page, but cannot find where I change anything about the underlying data or filtering.  Anyone know how?  Thanks! 

I'm slowly learning some basics, and struggling to understand how I would use Rollups to get "total" metrics. I have a "contacts" base, and a "metrics" base. I'd like to pull from contacts, roll up the total "sent," "opened," and "replied" emails and then I can calculate my % off of those in another column.

Hi,I receive information from a webhook trigger at the beginning of my automation. I want to apply conditional logic based on the values of certain variables in the webhook data (in this case, I'm using Stripe to trigger this Airtable webhook). If you examine the structure of the data contained in the webhook, you'll find that most of the useful variables are located in Body > Data > Object > ...However, when i try to set the condition in the Conditional logic block, I can't have access to the variables in Object (there is no little arrow ' > ' on the right)... Is this bug ? Is there a workaround ?Thanks for the help,LF

I'm using Airtable to manage school operations. We use Google Calendar to organize lessons for different teachers. I'm on a Pro plan.There is a limit of 3 sync sources per table. The problem is that we have 4 different calendars and we need to have all the events in one table. Is there a workaround for this? I tried a lot of different ideas but nothing worked.

Hello everyone!I have a database with multiple linked tables and I have a JSON response with which parts I need to update corresponding records in those tables. To achive that (as I'm thinking) I need to solve a simple problem of zipping two arrays into one. Say, I have [rec1, rec2, rec3] and [val1, val2, val3]. I need to get a zipped array [[rec1, val1],[rec2,val2],[rec3, val3]]. How could I make this transformation with Make? Any ideas?Andrey

I have two tables: Table 1 with companies and their data and table 2 which is synced from box that has the details on company logos as png images for each company. I have managed to use airtable sync to pull in the logo images from box to airtable - table 2. However now I want to copy those images to table 1 that has company data.  Basically the idea is to match the company names between table 1 and table 2 and then copy images from table 2 to table 1 if there is a match.Is there a way to automate this?If I had to make use of lookup fields, how should I go about it?Thanks!  

hi guys, i try to use web clipper for getting data from linked in automatically in my airtable. im new to airtable and also to HTML. so i tried to set up the webclipper by selecting the HTLM atributes with CSS search. But unfortunatly my set up is not correct yet. can you help me and answer if i picked the right html attribute or notationfor example i attached my aproach for the websitewhen i start the extension in chrome, no records are made in the airtable so far.  thank you a lot!regards jana

SYNC TABLE WHILE KEEPING RELATED TABLES.Hello Airtable community,I have a situation that I don't know how to resolve with a synchronized table.1- Situation: I have a "Matrix" table in a base that I've been using since before the option to synchronize bases, where I've built a database with linked tables and a very robust interface.2- Problem: Now I find myself in the dilemma that I have a database in another base generated for "players" in my case, and what I would like is to synchronize it with my "Matrix" table while maintaining the columns generated with the linked tables, as well as the different lookups and rollups.The current situation is blocking me from creating a more collaborative interface with information from different bases.3- Question: Do you think what I'm considering is possible?Thank you very much!

I've been scratching my head to why this is not possible, and I still have a feeling I'm doing something wrong but I can't figure out what.I have a bunch of time logs that has been logged over multiple years. Every log has an item linked to them which has a rollup that assign every time log into a category based on the item.My data looks like this: In the interface designer I want a bar chart that summarises all this data.The X-axis should be the years, then the Y-axis should be the amount of time spent.Each bar should be a total of time spend in that year. Then each bar should further be divide into the rollup categories.   However when I try to summarise the inputted times, every option except from distinct is greyed out - why can I not choose fx the Sum or the Average, which I find weird as a Time input surely is just a bunch of numbers, and its not being computed in a formular field?    

Hi, first post and new to airtable.I'm looking to place the hour-by-hour split on the timeline view with day timescale on the vertical axis, rather than it being on the same axis as the dates day-by-day.  I'm looking for something like this:While right now by view looks like this:Any help is greatly appreciated!  

Hello - Situation: Volunteers on the team have a 2-year tenure and when those 2 years are up, they can opt-in for 1 more year. My table shows their "start date" and then I have a column showing their "end date" using this formula DATEADD({Current WON Role Start Date}, 2, 'years') and have an automation that alerts me 60 days before that end date.  Need: What I'd like to happen then is after the Opt-In option is discussed and if the volunteer decides to add 1 more year to their volunteer work, a formula runs that gives a new end date.  Based on: What that said, I'd want the formula to run only if YES is selected from a drop down. Then I would assume we can take the tenure date (original end date) and add 1 year to spit out a new end date.  I'm not great at formulas and tried - IF({1+ Year Opt In}='yes', DATEADD(Tenure, 1, 'years'), " ") It doesn't give me an error but also doesn't populate a new date. Any insight?