Ask the Community

Hello! How are you?I would like some help with a solution I'm having difficulty finding answers for.I have a table and I need to generate a unique code (ID), but not based on randomness, rather on a relationship of information within the table itself.The ID in question should have a format similar to this: YYMMDD + BR + NumeratorWhere the numerator should differentiate between identical records, for example:Suppose on the date 23-08-08 there were 3 records. The code should then be: 230808BR01, 230808BR02, 230808BR03.Does anyone know how to solve an issue like this?

I'm getting an invalid Switch formula, even though it's super simple.I have several columns of singular date fields. Each date field is a milestone. I'm writing a simple Switch formula to check if Today() = one of the date fields, then if so say the column's name.I've simplified this formula to it's most basic to evaluate against itself and I'm still getting an invalid formula. What am I overlooking?   SWITCH( TODAY(), TODAY(),"yes", "no" ) 

What are my options after I reach  the Table limit of 50000?I've just realized that the record limit is actually a hard limit, not a soft one. What can I do at this point? I'm at a loss. I certainly need more room in my databases - it's crucial for me to store all of my data.

I've been getting this error message recently when attempting to view attachments in my base. Does anyone know what causes it or how to fix it? Not finding much on the help center about preview limitations of this kind. 

hi all - reached out to airtable support directly but they honestly never answer and suck tbh so i figured hopefully someone can help me here ( I even got a email asking me to rate the help given by a support agent when I had zero contact with anyone) Anyways.I embdedded my table into my webflow website, but there are TWO worksheets within the worksheet. On my webflow website it only shows one. How do I allows people to switch between the worksheets? See Loom. https://www.loom.com/share/c55eb9be4b934e56a9af82c31110619d?sid=aa61e156-e620-4df2-b267-35ee875c7b10

Hy, friends! I was trying to create dependent dropdowns using the “If a record matches the conditions” then “Find Records” automation. I can’t do it, maybe I’m doing something wrong? Can anyone help me or explain the essence of automation?

Beginning on 8/7/2023, when entering a new record in my application’s Interfaces, I noticed that the CREATE button has disappeared from the ADD RECORD Form.  Verified that all of my Interfaces are impacted as well.  Also, all databases.  I have submitted an Issue Ticket to Airtable Support.Any ideas as to the cause?  Am I overlooking something?  Is this a bug introduced with Airtable’s latest release?  Any recommendations?

Good day.There's an issue across the board when it comes to creating new records. It used to be that a person would fill the details and then click on the "x", which would create a record. This no longer works.Now it shows a 'create' button when the Interface is in the Edit Mode but doesn't appear when published? This is a big problem since no-one can create records via the Interface Designer!    

Hello- I watched this video but it's not clear to me what happens between minute 1:00 and 1;07.  https://youtu.be/ES1RyNPv_KgI am looking to create a sign-up sheet for one day in 5 minute increments between the hours of 12:00 pm - 5:00 pm, and have 4 rooms running at the same time. How do I pre-populate the times?Any help is greatly appreciated.

I'm doing a read-only base to give to others as a template and I noticed my automations don't transfer when they copy the read-only base. Is this right? Is there a way to make sure they cross over?

Hi, I wonder if there is a formula to calculate number of nights between two dates with times. For instance if I have arrival at 01/09/2022 at 22:00 and departure at 01/11/2022 at 09:00 that evidently means 2 nights in a given place. Any help and ideas will be greatly appreciated.

Hi,I have a table where people insert new records through an Interface, one of these columns needs to be unique.My issue is that i cannot stop people from inputting the same data by mistake through Airtable's Interfaces (so for example they need to fill the form  with "12345", but they write "21345" by mistake, and "21345" is already there in the database), so i want to catch this duplicate's existence afterwards by sending an email and performing other operations when it happens.Do you know if this can be done?

Hello Airtable Community, I hope all is well! I am having trouble with creating a running total formula/script. In the first table called "General Monthly KPIs" there is a field linking to the "Transactions" table with the dates, month and year, and the amounts of each transaction. There is a rollup field in the General Monthly KPIs table that calculates the monthly burn of each month. How can I create a running total field? There are thousands of transactions, so the 1-to-1 and 1-to-many method will not be applicable.  I tried scripting, here is my script: Which resulted in an incorrect running total:

Hello, I'm trying to return the date in a field based on the urgency selected in another field. For example, if the urgency is "As soon as possible" the date should return today's date which I'm able to get with TODAY() formula. However, I couldn't manage to get next week's date with TODAY() + 7 as I would do in Excel. What is the correct formula would be for that? Thank you! 

Hi,I created a base linked to a form that insert records. When a record is inserted or updated in my base, some automations are linked to perform actions. Everything worked fine till two days ago, now the trigger of the automations does not activate and actions are not performed, but they work fine when I do manual tests.Can someone help me? I have a free plan but all the things I use are included in that plan

I have two tables as follows:Matters table:Matter(s)DescriptionClient NameLead SourceBills table:Client NameMatter(s)Total ($)Both of these tables are pulling from two different data sources. I need a way to combine them both into one table so that table 3 is as follows:Lead Source# Matter(s)Total ($)I believe the best way to do this is to create records, but I'm not sure. In addition to combining the

Hello, I'm using the Timeline view with a data set that has data points starting Aug 1st 2023 and onwards.There are no data points for the time period before Aug 1st (Jan 1- July 31st) yet these dates are available to be scrolled through.I am aware of the date settings allowing you to jump to a certain section in a view, but I am instead looking for a solution to start the entire horizontal axis on a designated date, without having the possibility to scroll to an earlier time frame where there are no data points. Is there any way to hide the empty values, or set the minimum start date of the horizontal time scale of the timeline to start at a specified date? i.e. August 1 2023?

Hi all 🙂I am trying to avoid duplicate entries from making it to my airtable table.Background: I am running multiple webscraping actors collecting entries from public sources multiple times a day. The actor itself can not determine which entries it already has collected, but just get's the 10 latest entries 5x a day. This way i assure that I get all the entries which are posted. However, when I now add the entries to airtable, it will create duplicates. I am currently using the "Datastore" of Make automation, which will automatically "reject" any duplicate entry as i am using the unique URL of the entry as the unique key in the Make datastore. This is desired as each time an actor runs, only the new entries make it to the DB. However, when trying to switch from Make Datastore to Airtable as a DB provider, I realised that airtable doesn't allow me to specify a "key" or "record id" when adding new entries.Question:

Hi everyone,This is my first post to the airtable community forum so please excuse any rookie mistakes 🙂I'm having an issue with comparing two dates, I'm using the following formula...IF(IS_AFTER({Today's date},{Estimated Programme End Date}), "Yes", "No")Strangely, it seems for some records but not others.  Any ideas?Thanks, in advance, for your help.Kind regardsBenDATE COLUMN 1 FORMULA (Estimated Programme End Date)DATETIME_FORMAT(IF({Programme}="NQPC",DATEADD({Created Date},70,'days'),IF({Programme}="BTH/MIT",DATEADD({Created Date},42,'days'),{IM - programme end data (from Initiation Weekend)})),'DD/MM/YYYY') DATE COLUMN 2 FORMULA (Today’s date)DATETIME_FORMAT(TODAY(), 'DD/MM/YYYY')The comparison formula only works on occasion (row 1 doesnt work,

I'm trying to find the average of a Ratings field for a product using a rollup.Based on the docs this should work: ROUND(AVERAGE(values), 2) However, I still only get whole numbers back. How can I see the result to two decimal places using a rollup?

Hi.  Is it possible to rollup all values of all the links in a field of type link, combined into a larger array? I'll give an example to illustrate better.I have two tablesReportsExpenseCategoryLinesLinked (Link to ExpenseCategoryLines, many-to-one)ExpenseCategoryLinesReportId (Link to Reports, one-to-many)ExpensesLink (Link to Expenses, many-to-one)Expenses ExpenseCategoryLineLink (Link to ExpenseCategoryLines, one-to-many)The idea is to have a Report.AllExpenses as a rollup, which would combine all the Report.ExpenseCategoryLinesLinked > ExpensesLink into one field, as an actual list of links (not text). I've tried using CONCATENATE or ARRAYJOIN, but it returns the IDs as text. 

Is it possible to create a link to a calendar view that always links to today? Is there a way to do this via a URL parameter, e.g. "&date=today"? I have a few views that I consistently reference and it's a bit of a pain to constant find the "Today" button on the view to get it to show the appropriate content.

I am trying to create an analytics table for my reatail business and I created a sheet that includes all the poducts. I have a different table per day that I have sells so in the analytics table I added a column and linked the sells I have per day. What I want to do is to rollup all colums I have in the analytics so I can see my sales per day. How can I rollup sum different colums to get a total per month???

I'm trying to do some math and get some totals of columns, but I have div/0 errors. The following formula calculates work days and prints the result from a "StartDate" and a "FinishDate" column.  DATETIME_DIFF(EstFinish,EstStart,'days')-(INT(DATETIME_DIFF(EstFinish,EstStart,'days')/7)+IF(DATETIME_FORMAT(EstStart,'E')>DATETIME_FORMAT(EstFinish

Hi. I couldn't find any specific information related to this. We are currently looking into possible options to conver a Google-Sheets based system to something more thorough.  We want to make sure we do not hit any walls later on in the future, once the system starts to grow. For the Pro plan, there is a 100k automations limit per month.  If you perform automations outside of AirTable, using Make or Zapier, for example watching rows and then updating rows based on certain conditions - would these count towards AirTable automation limit? My intuition would tell me no, but I would prefer to be certain about this - as that way I know we always have a plan B if we hit the limit.