Ask the Community

I am fetching specific cryptocurrency data from CoinGecko using the Data Fetcher and populating it into a table called Tokens. Additionally, I have a table called Positions, which is linked to the Tokens table. The Positions table is where I track my Liquidity Pools.The challenge arises because the order of the Tokens table can change dynamically since it is populated with live data refreshed several times a day. Changes in market cap or the addition of new coins may shift data up or down in the Tokens table. This can lead to issues in the Positions table, where the linked entries might display incorrect coins.For example, let's say my Tokens table initially contains the following coins: BTC, ETH, ARB, USDC, SUI, FET, and MATIC. Suppose I’m tracking the MATIC/USDC pair in a Liquidity Pool within the Positions table. At first, MATIC is in row 7, and USDC is in row 4 in the Tokens table.Now, if the market cap changes or I add a new coin, such as SOL, which is inserted into row 4, the dat

Is it possible to select a range of records in grid view using the checkboxes and apply a sort to just that range?

I deleted a couple of records from my inventory base (on purpose). Then I accidentally deleted a whole field. When I go to my Trash it says nothing has been deleted for 7 days. That’s not true. There should be two or three records AND the entire multiple-choice field in there. What do I do?

I have a Projects grid and a Tasks grid.The Projects grid has fields for Project name, start date, and end date. The Tasks grid has fields for Task name, start date, end date, and reference to the Project name.  For each Project, I would like the start date to be the earliest Task start date among all the Tasks that reference that Project.Similarly, I would like the end date of each Project to be the latest Task end date among all the Tasks that reference that Project. Thank you in advance for any help!!  

Hey All,I'm trying to get this formula to produce one of three outcomes based on a products variance % from its target FOB, but for some reason it is not producing anything. I have used this formula multiple times successfully on other tables, but for some reason it is not working for this case. I have rewritten it a couple times and have checked the reference field to see if there are any issues and still can't figure out why its not producing an outcome.   Feel free to ask any clarifying question. Any help will be greatly appreciated!- Erich IF({Precost FOB % Variance} = BLANK(), BLANK(),IF({Precost FOB % Variance} <= -0.05, "RED: More than 5% off target",IF(AND({Precost FOB % Variance} >= -0.0499, {Precost FOB % Variance} <= 0), "YELLOW: 0% - 4.99%",IF({Precost FOB % Variance} > 0, "GREEN: Meeting or Exceeding target"))))

Hello, I have a question regarding Gmail automations in Airtable.I'm starting a business and am new to the world of marketing. I have extensive experience using Airtable automations, as I've been using it for years for other purposes, but I have many questions about email marketing tools and the limitations related to email contacts, spam, etc.My goal is to collect interested leads through a form. After receiving a form submission, I want to automate sending an email via Gmail with details about the services I offer. I also plan to create follow-up automations to re-engage the lead if they don't convert within 1–2 days of filling out the form.In addition, I want to send other emails periodically to offer new services—but not in bulk on the same day. For example, instead of sending a service offer to everyone in my contact base at once, I’d automate it so that an email is sent only when a lead completes 15 days in the database. In this way, there would never be large-scale email blasts,

At roughly 4pm EST 8/19/24 none of my users, including myself (admin) could no longer click linked records to see the detail screen for the latest (non-legacy) interfaces I have built.  The legacy interfaces still allow for linked records to be clicked into detail screens.It was working fine one minute, no changes to the interface were made, then the links simply stopped showing the flyout windows when the records were clicked.  When editing the interface and selecting the link destination it gives you the icon to test the flyout of the link and that does not work either.  Nothing at all happens when clicking the records.  No settings were updated or changed.  When I dug into it I did find that I could update my layout I was trying to click into and "Upgrade it out of legacy", however, when I attempted to do that it froze the page up and never was able to accomplish the upgrade.It feels like an update went out that accidentally caused this issue.  Hoping t

Hello AirTable community! I am trying to create a separate table that takes just the created by name, their email, and the number of approved records they have (in this case, approved is referring to any record in the original table that receives a check mark) from the create table, and populate just those values in the notify table. The values are populated in there through an automation (if record has a check mark in the create table, put these specific values into the notify table)The issue I'm running into is that in the notify table, if a user has multiple records approved, then their name will appear multiple times. I would prefer it to be their name, their email, and then a column with a summed up numbers of how many records they've had approved ( want it to be a real time moving number). I cannot figure it out for some reason. Please help, thank you!!Current OutputCreated By NameEmailNumber of RecordsSpongebob SquarePantsssquarepants@bikinibottom.com1Spongebob SquarePantsssquar

Hi guys! I'm wondering if I'm doing something wrong or something has recently changed? Long story short, I'm not able any longer to nest the records through the interface. Currently, I'm working on the new base and I wanted to nest records to organise them in some logical order. For example, if I look at one of the bases I already created, you can see the option to nest the records. Now, I'd like repeat the same process in another base and the option to nest the records is missing?Any idea if something has changed? Thanks!

In my base, I changed content type to multiple sections from single and now when I try to view the calendar view, "content pieces" it gives me a "Field “Content Type” was changed and can no longer be selected" Any suggestions on how to remedy this? Thank you.https://airtable.com/app6mSqDWyf5cSRa0/shrTfcyaeQloo2QZ8https://airtable.com/app6mSqDWyf5cSRa0/shrKoEdBGyLHbe1wr

Hello Airtable Support Team,I have a question regarding permission settings and billing policies in Airtable.I am currently on the Business Plan.In the workspace settings, a specific user’s seat is set to Viewer.However, I was able to assign Editor permissions to this user at the base level, and they are able to edit the base as expected.I would like clarification on the following points:Why is it possible to assign Editor permissions at the base level while the user’s seat remains set as Viewer in the workspace?In this case, does Airtable’s policy ensure that no additional charges are incurred?Could you confirm whether this behavior is in line with Airtable’s current policy or if it is a system error?I would appreciate a clear explanation of the policies surrounding this matter.Thank you for your assistance.Best regards,

I have an excel spreadsheet with many calculations.  Given my current understanding of formulas, it is very much like excel so my question is below.Formula in Excel=IF(SUM(N22:Q23)<>0,SUM(N22:Q23),"")Field names in AirtableN22= シャトル台数(Shuttle Qty)Q23= 予備シャトル台数（Sp. Shuttle Qty）So my airtable formula should be as followsIF(SUM({シャトル台数(Shuttle Qty)}:{予備シャトル台数（Sp. Shuttle Qty)}<>0,SUM({シャトル台数(Shuttle Qty)}:{予備シャトル台数（Sp. Shuttle Qty)}),"")But I keep getting an error. Where are my assumptions wrong?  It is simple addition problemOrder Qty - ShuttleShuttle Qty28Spare Shuttle Qty2Total Shuttle Qty30

Hi everyone!I use Airtable to track event time logs (like a clock in/out system).  I attached the base structure to this message.How can I make the "totalMins" linked field (linked to "mins" in the "timelogs" table) automatically select all of the results instead of clicking them manually one by one?Thanks! 

Hi,I was trying to extend the below formula to give me records due 2 weeks from now so I modified this:IF(WEEKNUM({Flight Start},"Monday")=WEEKNUM(TODAY(),"Monday"),"Current Week",IF(WEEKNUM({Flight Start},"Monday")=WEEKNUM(TODAY(),"Monday")+1,"Next Week"))To this:IF(WEEKNUM({Flight Start},"Monday")=WEEKNUM(TODAY(),"Monday"),"Current Week",IF(WEEKNUM({Flight Start},"Monday")=WEEKNUM(TODAY(),"Monday")+1,"Next Week",IF(WEEKNUM({Flight Start},"Monday")=WEEKNUM(TODAY(),"Monday")+2,"Two Weeks"))) The formula was accepted but it is not giving me any results. Does someone know why?Do I need to trigger the formula? 

Over the last week or 2, the android airtable app has become next to unusable.If I perform any operation in the airtable app (modifying a record/creating a record etc), and then need to switch to another view or another table, I can't. I tap to change view/table and just get a loading wheel of death. The only way to open a new view/table is to restart the app. At which point, the problem repeats.We are a 3 person charity, 2 of us (full time) use Androids, and we have invested a lot of time and effort into building our airtable systems. We use it on mobile 95% of the time, and designed it to do so.Yet it's now totally unusable. My other full time worker needed to sign check hundreds of people off today at an event on airtable and could not.We asked our part timer, who uses an iPhone if she was having the same issue - it doesn't seem to be an issue for her, although she interacts with the data a lot less often.Is this happening for others? Is this an issue with our phones being a bit old

Hello Airtable Geniuses:I own a custom window covering business and am trying to create a customer questionaire that can be imbedded onto our website or emailed to a customer. I'd like for the customer to start by entering their contact info, and then add ROOM NAME, and then under each ROOM be able to add several WINDOWS. For each WINDOW they would then be able to choose from drop-down lists for several items (ie size, colour, oerating system etc). Is this possible to do using Airtable and Forms, and if so does anyone have a sample template they could share? Or point me in the direction of a youtube video? 

Hey guys I am currently building a large airtable interface, the goal is to edit records with as much complexity. When I duplicated a block, I had this error code Your change was reverted because your interface is too big. Try deleting some elements. Any idea how to optimize this? Can the airtable team help?Thanks 

Hi all, I have a long text field where I have numbered some text like below for example: Example text Example text Example text However, when sending this field in an email it always ends up looking like the below screenshot. I have tried turning ‘Enable rich text formatting’ on & off, I’ve tried adding it as a ‘list’ and ‘grid’ in the email but it always ends up like this. I just want it not to be indented at all, like I have typed the example above. I can’t figure out a way around this, does anyone have any ideas? For clarity, here is the field as it is written in Airtable, before being emailed:

Hi - I'm trying to create an Airtable for my team's weekly meetings. In one of the tables, we are adding action items from the meeting and designating the person working on it. However, we'd like to add an automation where these action items would then be created as tasks in Google. Is this automation possible?

I just want to make sure I understand this properly.  I can create a mobile interface list view, but I can only sort by one criteria. I cannot then sort by a second one. For example I have TV shows and I can only sort by show name or episode. Not show name and THEN episode. Am I missing something?  Thanks  

I am trying to create an automation that adds a multiple select item to a field but I don’t want to replace it with what exists. For example, if “Troop” already existed in that column, I want to add “Cookie” so that the multiple select field reads “Troop” “Cookie”. Currently the automation replaces everything that exists so when I run the automation, it simply says “Cookie”. Any advice?

Hi everyone,I’m developing an app using Softr as a front end and Airtable as the data source. The app serves as both a client portal and an internal operations tool, with 3 user groups: clients, employees, and managers.Here are the key details:At peak traffic, I expect around 100 concurrent users interacting with the app (creating, updating, and reading records from Airtable).Given Airtable’s 5 requests per second limitation, I’m concerned about potential performance bottlenecks or errors.I don’t mind if there’s some delay when loading pages; my main concern is ensuring the app functions properly during high traffic.Questions:Will the app handle this level of concurrency without running into errors, considering Airtable’s request limits?Has anyone built something similar and can share their experience?I’d greatly appreciate your comments and insights!Thank you!

Namaste Team , I want like this when user fill form based on site name like Traralgon, Ouyen based on there form in that They only DIP value update based on latest filled data How setup in this airtable  this latest data need shown in DIP valueTraralgonType ULP 91 Diesel ULP 98 E10Capacity 36000 40000 14100 5700Dip 18000 18900 7200 10800Ullage 99999 9999 9999 9999 

When editing a custom Airtable Extension, the process is to select edit on the block, grab the URL/port from AT,  run the block locally with block --run, and select "Start Editing Extension." However, the Chrome setting (flag) that used to allow developers to host the app code locally and run it in AT has been removed. (The flag was #allow-insecure-localhost.) This leaves us unable to edit the extension. Any suggestions for how to get development working again for extensions/blocks? 

Hello all!I need help with a formula field. I believe I will need to use the IF function. Each week, I have to do math based on data input in 2 different fields and then multiply that number by a static field to get my total. I have to do this for 50+ records each week, so I'd love to save myself the time and energy and have my TOTAL field know which of my two fields it should compute against my static field. A screenshot is provided so you can see, and below is a little more explanation.Thank you for any help!Each week, some of the shows I am tracking are in preview performances and some are in actual performances, but never both at the same time. This number can change each week for either, and each show will start in previews then move to performances. I input the number of performances into the appropriate column, then multiple this by the {Production Seats} field to get my {Capacity}. Basically IF {Previews} has a number in it, multiply that by the {Production Seats} to get {