Solved

Hello everyone, I have currently the following formula in my table that shows "Yes" if the date in "Fin contrat" is in a future month. I am trying, but with no success, to adapt this formula to show "Yes" in another column if the same date is in the previous year (so currently 2022).Can someone please help me achieve this?Thanks! 🙂 IF( IS_AFTER( {Fin contrat}, DATEADD( DATEADD( DATETIME_PARSE( "01 " & DATETIME_FORMAT( TODAY(), "MM YYYY" ), "DD MM YYYY" ), "1", "months" ), "-1", "days" )),"Yes","No") 

I have two tables that I have linked:Case StudiesEvents and PolicyEach of these tables has a 'Region' field in the accompanying records (set to single selection). I am trying to set it up so that when the location fields match between the two tables, these matching record are linked automatically. For example: There is a record in the Case Studies table named 'European Union'.There is a record in the Events and Policy table named 'Brexit'The 'European Union' record has a single selection field called Region, which is set to 'Europe'.The 'Brexit' record has a single selection field called Region, which is set to 'Europe'.Ideally, the 'Brexit' record would automatically add to a linked record field set up in the 'European Union' record (I know this will also be vice versa, which is fine). I would like to repeat this in these tables with different regions (i.e. Africa, Asia, North America etc.). For example, a record titled 'US Election' in Events and Policy will

Hello, I'm trying to create a Formula that will change Status according to the fields "Start Date" & "End Date". If Today > End Date = "Delayed"If Today < End Date = "In Progress"If Today < Start Date = "Planning"I have written the following formula that works for "Delayed", but shows "True" instead of "In Progress" or "Planning"IF(TODAY() > {End Date},"Delayed", AND(IF(TODAY() < {End Date},"In Progress"),AND(IF(TODAY() < {Start Date},"Planning")))) Anyway can identify my mistake? Thank you!!!

Hi, Airtable Team! :wave: Cloud file attachment (GoogleDtive, OneDrive, Box etc.) take up space in the dedicated storage? Best regard, Andrey Ttbomk

Hello Community,I need to have an address table that deals with some people having different street and mail addresses and some having only a street address. How can I structure the table to allow for both while being able to filter for a list for mailings? Any thoughts would be appreciated.Thanks, Scott

Hello !I am encountering a problem when creating an automation script for one of my tables. I set up a trigger to occur when the user creates a record. I then wrote a script to be run as an action of the trigger. This script contains a 'fetch' call to a local Flask server where we will do all the process ensuing this trigger activation.Unfortunately, whenever I test my script, it always indicates :  TypeError: Requests to '10.110.90.204' are not permitted at main on line 1 Here is the script I am using : let response = await fetch('https://10.110.90.204:8050/process'); Can you help me with this, please ?

New to Airtable... Trying to create formula that will calculate 6.25% tax but ONLY if the "State" column is "MA" (for Massachusetts)... I figured out the tax part (Price*0.0625), but not getting the If State=MA, only then calculate tax for the tax column (otherwise, if not MA, just want to see 0 in the tax column).Thanks!     

Hi 🙂I have user information in 2 different tables but in both I have a field with the user email that could be used as a linking field. I would like to set an automation to update a specific field from table B into table A using the email as a matching reference. The same email is in both tables. Any help will be highly appreciated.Will earn the right for "caipirinhas" on me whenever you visit Brazil 🙂 Thanks a lot!

Hi there,I have a form that captures emailHere is an example of what the data could look likeI'm trying to create an automation such that any time a unique email is entered, data is populated here. In the table above you see that ethan@abc.com is entered a few times, yet only appears once below.     

I am collecting survey results into an airtable base.This includes two tables:The index for all surveys (and including key information such as deadline).The responses for the various surveys (each response is linked to a survey)Each survey has a deadline (time field deadline), when it should stop accepting responses. A this point, the survey and its results should be transfered into a new view of each table that then syncs to another base.I have created an IF formula, that (all dates are set into the same timezone: CEST) switches to "transfer", once NOW() is larger than the deadline date (which is CEST is 2am). For the responses, I add 5 minutes to the deadline to ensure that the survey has already been synched.If I look at the CREATED_TIME() for the entries in the synched table in the other base, all entries have been created at the same time (i.e. the delay added to responses does not seem to have been accounted for).Can anyone advise how airtable recalculates time-based formula

I am struggling to get the DATETIME_FORMAT to return the correct time for me. For example, my Start Date is 10 January 2023 00:00 and in my formula column, I just want it to extract the time of the "Start Date". So I put in this formula: DATETIME_FORMAT({Start Date},'HH:mm')However, it keeps returning the time as 16:00.Can anyone help? 

I have a few tables where each table has linked records to the other table and I am fetching it with the Airtable api the problem is though that I need to first fetch table 1 and and get all the linked records IDs and then I fetch table 2 with the record ids and so on until I get the whole object graph and it’s very slow my question is is there a way to get the whole graph in a single api call?

Hello Community! I need some guidance... I have a few columns with fields that are Single Select and one of the options is "COMPLETED". I am looking for a way to create a formula for it to add "how many COMPLETED fields" I have for that record... For example if it was Excel I would try an "IF" formula or "COUNT" to add how many columns have the COMPLETED field, but here I just can't figure it out. Anyone know how to go about? 

My boss - who has been using Airtable with the rest of our team for years - has suddenly been unable to log into the site and gets a privacy error whenever she tries:None of the rest of our team has any problem accessing Airtable. She has tried using different browsers, clearing browsing data, and using incognito mode, all to no avail. Have any of you seen this issue before, and do you have any other recommendations? I created a ticket with Airtable support, but they seem to be particularly slammed at the moment and haven't responded yet, so I thought I'd try here.Thanks!Joel

I have two fieldsa start day for a task (date field)an estimated number of workdays the work will take to complete (a number).I want to add those workdays to the start date and count ahead to the date the work will be completed. I do not want to count weekends.I've tried the formula below to estimate the date the task will be completed by combining my two fields. DATEADD({Imaging Start Date},{Forecast Workdays for this Batch},'days') However, that counts weekend days as workdays, thus returning an earlier forecasted completion date.For example, if the work starts 6/1/23 and should take 10 workdays, the returned date should be 6/14/23, not 6/10/23.Is there a way to account for this in my formula or the data? 

So, I'm trying to add a day to the columns, but I need it to add exponentially... if you know what I mean.  It would be nice if we could click and drag like in sheets with this stuff. 

I hope this is the right place for this question, but we'll see!Context: We have a 'Tasks' table where each team member may have a list of hundreds of tasks (thanks to the joys of generating task templates). I would like to have a View for users that allows filtering out all child tasks until the parent task's 'Status' field reads "Complete". This would create a nice flow of the next steps for a project filtering into the view once a parent task has been resolved.The Tasks table has a linked field called "Blocked by:", which links to the same table. Here, users link a record (parent task) that must be completed before they can complete this task.Is there a way to 'hide' any records that have a linked record whose Status is NOT "complete"?  Then, once the linked record's Status is "Complete", by virtue of not meeting those conditions, the child task appears? 🤩Ideal situation - there are a few team members who use this table– it would be optimal if a single user

Big Picture: Im trying to accomplish a process to automatically link records between tables. The use case is automating a process where when a user updates their membership in an external system, airtable creates a new membership record and links it to a user account in our airtable database.  Basically our CRM's membership data doesnt talk to AirTable.  So Im using automations to export the data an ingest it into airtable.  Once its ingested, the membership data needs to be linked with a user record in airtable.The steps I think need to be accomplished.1. In table A, we Create a record with a {user account number} from a database not linked to airtable.2. In table B, I want to take the that {user account number} from Table A and match it to a record in Table B.3. Update a linked record field in Table B with the matched record from step 2.Im struggling with step 3 in particular.  Both the external database, and the airtable user accounts table have the common "

This seems like it should be well documented but I'm having a devil of a time finding a clear example. Goal: When a new Activity is created with a Type of "Posting Closed", I want to update the linked Applications so that it's Status is "Recently Closed".Table structures: ApplicationsActivitiesTitle [text]Type [single select]Status [single select]Date [date]Activities [linked record] Job Postings [linked record]I'd really appreciate some 📸 screenshots of a working sample automation configuration too.Thanks!

Dear ExpertsPl guide we have shared folderd being made up on gdrive to store scan documents and its link (url)copy pasted in base in attachment tye filed - however iif link carrires underscores email received from airtable automation with attachment filed , removes this underscoreso  user is unable to access g drive folder as url itself is wrongrequeting experts to guide on how to overcome on this issue asape.g.currently link in g drive showshttps://drive.google.com/drive/folders/1EsGxBLBHgBNBA76Y3mu_MMotiPK2yKQC3mu_M - unsrscore getting removedin email received it shows--DETAILS ARE UPLOADED ON SHARED DRIVE AThttps://drive.google.com/drive/folders/1EsGxBLBHgBNBA76Y3muMMotiPK2yKQC?usp=sharelink--kindly advise on rectifications suggested

My task is so easy. When a new email is received, I need to create a new record in Airtable with data from this email. All things go well in Zapier from start to testing. I see all data from the email in the new record in Airtable. Great! When I try to publish a new zap, I see a new window like in the attachment to this message. I can not publish this zap. Thanks in advance for any hint on how to solve this issue.

Is it possible to export a set of automations. I am working across multiple Airtables but require to use similar automations across them all. It would save lots of time if I could export them and import them to different Airtables.

Hello,I'm a fresh user of Airtable. During Pro trial I created some basic table with a form for people to sign up for an event. To avoid any accidental changes to the form after it was shared, I locked that form.Now the trial period has ended and I cannot unlock the view, or even delete it (after duplicating).In all the places that allow for unlocking the view, the option is gone. When clicking on the view's bar on the lock icon, then "Locked view / Collaborative view", nothing happens.This means that I cannot e.g. stop accepting entries. Link settings cannot be changed. The view cannot be deleted.I wrote to the support, but I'm afraid of being forced to pay $20 for Pro just to unlock one form...Any other ideas on what to do? Thanks

Hello, friends.I have two tables. Unfortunately I can't change how they're structured, or I would. So I'd love some advice on getting what I need from this setup.The first table, "readers," shows a "profile owner" associated with a "branch." Then there's a list of readers in the third column, titled "reader name." I need to associate those readers with their branch so I can show how many readers there are per branch in an interface report.The second table, "totals," shows an aggregate of how many readers are associated with each profile owner. But in the "totals" table no branch is listed.I'm hoping that I can choose "totals" as the source for my "readers per branch" element by matching "first name" to "profile owner" from the "readers" table. This would create links between "number of readers" in the "totals" table and "branch" from the "readers" table.I hope I'm explaining it well. It's complicated. I searched through the community, help docs, etc. to no avail. Perhaps one of you can

Probably a pretty simple script update here but I'm stumped... Everything just comes back as undefined rather than the value 1.