Ask the Community

Hello -- we have a base with about 5000 restaurants listed in it, and our editorial team needs the ability to easily put together ad-hoc lists of selections from that set.  They might start by filtering for all the records in a particular city (Chicago), but then need the ability to manually remove records from that basic set.  What's the best way to go about doing this in AT?  In FileMaker Pro (where we're migrating from), you could do a Find and then simply manually Omit records from that found set.  Is there a similar way to do this in AT?  Or would we need to do something like create a new field, and then add a value to that field for all the records we want to manually group?Thanks very much - loving AT so far!

Hi! Recently I've been encountering a table syncing error ("Last sync failed 1 minute ago (external resource id could not be mapped to a rowJson)"). It's easily resolved by manually syncing the table with the error, but this is obviously inconvenient - we have a LOT of synced tables. I haven't been able to detect a pattern in which tables get this error or when. Has anybody else seen this?

Sorry if this is in the wrong forum.I'm a new user considering upgrading to a paid sub however there is an issue which if not resolvable means Airtable would be completely useless to me.I'm in the UK so using the DD/MM/YYYY format, no problem with this, all the data formats fine.The problem comes when I try to filter view by dates, when I click on the first of October and the 31st of October as the start/end dates for my view, Airtable uses the MM/DD/YYYY format despite all my data being in DD/MM/YYYY format. Due to this the only entry that comes up was from 10/08/23 (Tenth of August). None of my October sales are visible. If there is no workaround to this then Airtable is completely useless to me.I'd be incredibly grateful if anybody could assist.p.s I'm only using Airtable to keep a record of my inventory for my part time ebay reselling, I'm not a power user so will not understand complex formulas.

Hello!I need to create a data entry form that will limit dropdown menu choices based on the selection made in another field. I am looking at the possibility of establishing nested lists to define the hierarchy of options, but so far I'm not succeeding in creating an interactive drop down menu.Is nested lists the right approach? If not, is there another way to do this?Here's the example. Imagine I have a table that has 30 birds and 20 fish in the records.In question 1 I want the user to be able to select "bird" or "fish", and then in Question 2 I only want the 30 birds or 20 fish to show in the species selection box, depending on what was chosen for Question 1. (In reality, I have an intermediate grouping level, and many more species than 30 or 20.

Hi,The functionality of creating a new ticket is not working as it should. Is anyone else experiencing this error?Thank you

Hello all,I need a formula that will delete every instance of a string of characters between [] including the brackets. Basically I'm pulling a products from a database which is SKU code then the product name. Every SKU code is like the following [SHU-BATT-22-EU] SHURE BATTERY 22. Is there a way to remove any code between [] including the brackets so I am just left with the product name? Thanks in advance!

Has any headway been made toward the goal of being able to display the results of the survey during live group polling? I remember seeing some community debate about the need for such functionality around a year ago. Still, I haven't seen anything recent that indicates any work being made in that respect. Many thanks!

Hello,I have a question regarding the Airtable API key deprecation, and was hoping someone could clarify/confirm. Basically I am wondering whether this change will affect us, and whether we need to make adjustments. I've searched the forum, but I did not find an answer. Maybe this is a newbie/misplaced question. If so, I'm sorry.I have a base today where we use the Google Distance Matrix API to retrieve info from the Google API. We have no external services connected to the Airtable base. If we go into the "Developer Hub" and look at "API Key" the list is blank. That is true for "Personal access tokens" and "OAuth integrations" as well.The Distance Matrix API uses an API Key, which we have created through google. We use this key when Airtable connects to the Distance Matrix API to get info. This is done in scripts and automations, and we use the function"await remoteFetchAsync(txturlrequest)" to interact with the API through the scritps. In the automation we use "await fetch(txturlrequ

Howdy, Recently encountered a twitter account that I like which posts a progress bar for the year. I would like to make an extension that simulates that, so made a field that displays the day number of the year; specifically: DATETIME_FORMAT(NOW(),"DDD")However, when I am trying to then convert that output into a percentage, I only get an error.DATETIME_FORMAT(NOW(),"DDDD")/365I'm very confident there is a simple detail that I am overlooking. Would any of you happen to know why? 

Is there a way to autofill a hidden field or Date data on a form to show when that form was submitted? This to to eliminate the need of asking the user to fill in a date field.

Hello, I am attempting to create an automation which will take compare records from two separate pages and then input values from one page into another based. I have the system working for finding and inputting the data from one page to another, but the issue is that the source page has repeated entries for the same conditions (example: there are 3 entries for the name daniel, where the name is being used as a condition).Is there a way to have the "Find record" action remove repeated values from its list before outputting?If not, is it possible to do so with coding it?Thank you in advance.

Hello,This one has me frustrated because I know it can not that hard. 😁I need to create an Expected Ship Date field.  I have a Start Date field (formatted as Date) and a Ship Days (lookup field from another table).  I want to find out how many days prior to the start date I need to send out the package. First My thought was Start Date - Ship Days, that just gives me NaN message.Then I thought I needed DateTime_Diff(Start Date,Ship Days, 'days').  That gives me a 4 digit number in some cases and NaN in other cases.  i.e. 1/3/2024 (Start Date) - 7 (Ship Days), I get 8221.  I am thinking that is good and just need to DateTime_Parse it.  So I enter,  DATETIME_PARSE((DATETIME_DIFF({Start Date},{Ship Days},'days')),'MM/DD/YYYY'), and I get #ERROR!What am I missing?

My team uses Airtable extensively (and I'm still bitter about having to double our costs to not lose our syncs...but that's besides the point) and we have a few clients we want to help organize their data better too.  I want them to use Airtable, but I'm hesitant to ask them to pay for us to have an account to access their bases to help set them up.  So my question is: If I have an Airtable business account, is there anything stopping me from creating an account and workspace for our clients, and then just billing them for that?  There's nothing in Airtable's terms & conditions that explicitly deny this, but is there any reason I'm not seeing that makes this a bad idea?

In my rollup fields (on multiple bases), I don't have the option to add a condition shown in this article: https://support.airtable.com/docs/rollup-field-referenceWhy would that option not be showing up for me? (I have a Pro account)Here's what I'm seeing...Here's what's shown in the article:

Hi people! I’m building a “Birthdays” table in my “Calendar” base and I’m looking for a formula that says: if “Birthday” is within the next 2 months then display “soon” What would this formula look like?

Hi, I'm having Problems with a Script, that are very weird.I'm writing a Script that should pull Crypto Prices from CoinMarketCap. For that, I created a Table "Currencies". In this Table there are 3 Fields (for the sake of this example): "Name", "Symbol", "Price". Now in the Script Settings you can enter your API Key (not relevant here), the Table of the Currencies and a Symbol and Price Field. Now the Script should query all Symbols existing on the Table, compile them into a Comma-Separated List and query the API. Then it should fill in the Price for each Symbol. This is the Code so far: const config = input.config({ title: 'Crypto Price Importer', items: [ input.config.text('API_KEY', { label: 'API KEY' }), input.config.table('TABLE', { label: 'Table', }), input.config.field('SYMBOL', { label: 'Symbol Field', parentTable: 'TABLE' }), input.config.field('PRICE', {

I want to combine multiple IF statements from data in two columns and return a TRUE or FALSE result.The two columns/data I am using are:User Subscription Level (Basic, Pro, Premium)Total Requests (Sum of values from multiple fields)What I've tried to do so far seems to not be working very well and I am a complete novice when it comes to Airtable formulas. IF( AND({Subscription} = "price_1NZdQ5C8Jx0D8bOIPFa8Nlto", {Total Requests}<"8"), "Limit Not Reached", IF( AND( {Subscription} ="price_1NkT9EC8Jx0D8bOIMXi0g37m", {Total Requests}>="25" ), "Limit Not Reached 2", IF( {Subscription} ="price_1NkT9EC8Jx0D8bOIMXi0g37m" ), "Limit Not Reached 3", "Limit Reached" ) ) Ultimately what I'm trying to do is check the user's subscription level and the number of requests they've submitted and evaluate if they are at their limit or under their limit.I'm not sure if I'm fully grasping how the logic is supposed to flow and I

Hello, I need to make CSV exports of a table that contains several long text field cells. Each long text field contains text with carriage returns, which results on the csv as actual breaklines, which is makes it quite tedious to fix manually. Apart from NOT using any breaklines within the long text filed, (which wouldn’t be the ideal solution as we need the information contained in the field to be nicely readable and not showing as a big block), would there be another way to prevent that issue? :pray: :pleading_face: I know the topic has been raised already but unfortuantely I could not find a satisfying answer to that yet. Thank you for your help! T.

Hi everybodyWe just upgraded to the Airtable Business account and recently updated our Airtable connection in Zapier from one user's personal access token to another user. Now all the Zaps using Airtable have stopped working - and have an error message that the Airtable connection is expired.I've tried reconnecting the airtable account several times, and each connection says expired.When you sign into Airtable through Zapier, there are a few new options... I've selected the organization option as this makes the most sense for us. No luck - it always shows as an expired connection. Any advice??

Hi guys.I was working at the optical shop, where I set up the entire Airtable for any form of tracking our customers such as dioptries, eyewear they chose, and complex calculation so you can add the info right in front of th customers and tell them the final price. The table also got own portfolio for eyewear and its own price and specification. It was great but the only thing I struggled with was changing the price of the product (in portfolio) that was sold and reordered by me again with the higher price. If I wanted to change original price (in portfolio), it will be changed in all of customers that purchased specific product. My question: Is it possible to somehow change the price without adding the same product with a different price? for example lock the record so it does not change or any other options ? Thank you.

I've figured out how to create a formula that outputs a date that Airtable understands as a date (rather than a string of data) and have it appear on a calendar BUT is there a way to be able to drag said  item across the calendar so the dates change automatically? (as you would if you if you were just using calendar dates entries)

Hey,When sending my metadata in media platforms (such as Whatsapp, Facebook, Teams etc.) I see the metadata and thumbnail of Airtable.com company (attaching a photo). Is there a way to customize it so when I share my airtable URL people will see a different metadata?Thanks

Hi there - I'm creating interfaces for different external users, but some of my field names make more sense internally than externally. I'd like the field names in the interface to be different than what they are in the base. For example, my base has a field called "Load Description HTML", but I'd like that same field to be called "Contains which product?" in the interface. This would be similar to how Form Views allow you to change the field names so they make more sense in the form.Does anyone know if/how this is possible?Thanks,Kelsey

Hi, hoping this is easy...Can you help me adjust the formula below to return just the number of work days?formula:  IF( AND({Squad Start Date}, {Squad End Date}), IF( AND( {Squad Start Date} < DATETIME_PARSE("10/28/2023"), {Squad End Date} >= DATETIME_PARSE("10/01/2023") ), DATETIME_DIFF( DATETIME_PARSE(MIN(VALUE(DATETIME_FORMAT({Squad End Date}, "X")), VALUE(DATETIME_FORMAT(DATETIME_PARSE("10/28/2023"), "X"))), "X"), DATETIME_PARSE(MAX(VALUE(DATETIME_FORMAT({Squad Start Date}, "X")), VALUE(DATETIME_FORMAT(DATETIME_PARSE("10/01/2023"), "X"))), "X"), "days" ) + (MONTH({Squad End Date}) = 10), 0 ) )  Thank you so much! Ann

Bonjour, Je suis en train d'essayer de créer une table pour créer une note de frais. Je voudrais à l'aide d'un script "fusionner" plusieurs enregistrement en fonction du mail d'une personne. C'est à dire que j'aurais plusieurs champs comme "Nom", "Prénom", "Description des frais","Montant" et "Facture". J'arrive à fusionner tous les enregistrement pour créer une seule ligne et toutes les données se séparent avec un "/" . Toutefois, le champs "Facture" qui est de type "pièce jointe" et possède une pdf ou un image n'arrive pas à regrouper toutes les factures. Voici le script utilisé actuellement: // Nom de la table sourceconst sourceTableName = "Facture de frais";const table = base.getTable(sourceTableName);// Sélectionner les enregistrementslet records = await table.selectRecordsAsync();// Objet pour stocker les données groupéesconst groupedData = {};// Parcourir les enregistrementsfor (const record of records.records) {const email = record.getCellValue("Mail"); // Assure