Ask the Community

Hello everyone, I need help with automation. 1. I have Table 1 with the primary field 'Date' where I receive in a column 'Complete Description' a long and annoying detail2. I want to simplify step 1. based on the primary field of Table 2 'Expense' where I have a list of expense types. 3. So, when a record is created in Table 1 AND CONTAINS ANY OF THE WORDS from the primary field of Table 2 'Expense', I want it to be placed in the column 'Details' in Table 1. How could

- I have a source table and a synced table- The synced table feeds Power BI- The person that set up these connections is no longer with us and my knowledge here is limitedQuestion: How can I sync newly added fields in the source table to the synced table? We have added new fields to the source, but I don't see them in the synced table and I need them so it can then feed to Power BI.

Hello! I figured this out before and accidentally cleared it a while back without noticing. For context, I am trying to find the total cost associated with ordering additional curriculum books. In the form submitted, customers can select additional books for purchase at $45 for K-2nd and $60 for 3rd-6th.I am trying to find the sum of:multiplying the following columns by $45: Additional K English, Additional K Spanish, Additional 1st English, Additional 1st Spanish, Additional 2nd English, Additional 2nd Spanish multiplying the following columns by $60: Additional 3rd English, Additional 3rd Spanish, Additional 4th English, Additional 4th Spanish, Additional 5th English, Additional 5th Spanish, Additional 6th English, Additional 6th Spanishfor a total cost to appear in "Additional Books Purchased:" ex: 1 additional K Spanish & 1 additional 6th English would equal $105 in the additional book

Hi there, I'm essentially trying to set up two overwrite fields in my formula. So if field 1 is blank, then use the data from field 2, but if field 2 is blank, then use data from field 3.I have the formula for one overwrite which works fine (see below), but I can't seem to work out how to add another condition to it. IF({Company Invoice Contact}, {Company Invoice Contact},Company) I want it to work like;IF Invoice Contact Overwrite is blank then use Company Invoice Contact but IF that is blank, then use Company.  Any help would be much appreciated.

Hi,I want to create an IF formula but the result I get is not what I expectedHere is the formula: IF({Date effective de fin du cadrage (from Date effective de fin du cadrage)}<{Date estimée de fin du cadrage (from Date estimée de fin du cadrage)},"In time","Late")I want to get: "In time" if the effective end date of the scoping is before the estimated end date of the scoping and I want to get "Late" if the effective end date of the scoping is after the estimated end date of the scopingHowever, I'm getting "Late" whereas I should get 'In time".Could you please help me? Thank you very much

Hi there,New to AirTable and Automations but was hoping to get some help with setting up my first workspace. I currently have 3 tables: Project PortfolioProject WorkplansProject StatusesIn the first table, I would like to display the Next Milestone and most recent report / status. On the milestone side, this would somehow be a lookup of the tasks in table 2 (All workplan records are tagged with the right project). So if there were 5 records for Test Project and the next future dates were 11.30 and 12.04, I would want just 11.30 to display.This is what table 1 looks like right now. For status, I can manually pull in the status I would like, however I would like the status to update from Nov 27th to the next week when a team member submits a form with a new status update. I am struggling with the automation there, spec

I have a base where I have a template table - let's call it Table A - that I copy to create new tables with the identical structure (i.e. all fields are the same). Is there any way to have the automations associated with Table A be automatically created for Tables B, C, D, etc.? Failing that, when I manually copy the Table A automations, is there any way to have it recognize the fields with the same names in Table B and not force me to reselect them each time? (In my use case, each table represents a different event, but I'm sure there are many other use cases as well!)

Hello, I am a newbie to building out AirTable bases and am mainly working off of AirTable's Marketing Campaign Tracker base to make my life easier as my new team gets more and more campaigns in various stages.AirTable's Gantt view with field dependencies is what made me move my tracking efforts over from Trello, but I am realizing the campaign management base may not exactly be what I had in mind for tracking how long the campaign is in each stage. I was curious if there is a newbie-friendly way (I AM willing to put time into it, but my skills are not good) to build a base to track the duration in days from the automatic single-select field value (such as not started) to the last field value (usually completed or approved). Because some campaign steps can be done together, or need to be done before another, I would also need a start date to reference. Ideally, I would love to reference the Marketing Campaign Tracker fields to get this duration and date started.

I often have issues with pasting into a cell.  It just hangs for a minute or two, sometimes longer.  I've read before that it could be because other fields need to be updated if they have have formulas that use that field. However, in my most recent case, I was simply pasting some text into a text field, and it took at least two minutes.  What is the problem, and is there a solution?

Hi Airtable community,Does anybody here utilize any third-party consultants to help set up automations and integrations? If so, are you able to recommend any quality consultants that our company can reach out to? Thanks!

Dear Community, I have a tricky problem. When I want to call someone through the Airtable Phone App, I click on the small phone receiver button, and the iPhone asks me if I want to dial the number. However, for international numbers, the country code (+) or (00) is not included in the 'Call' display. This is a big problem, as I have many international phone numbers in my database. Is this a common issue that Airtable can solve? Is it just a problem for iPhones? Can anyone help me? 

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')

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.

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.