Other Questions

Hello, I want to show “0000009” in my cell inside Inventory table. I tried to use roll up but it shows “0000009” and “0000008”. How can i only show the latest one only (in this case is “0000009”) Thanks

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

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?

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,

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

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? 

HiI would like to compare 2 text fields. The first in "Internal" and the second is "External".I saw this solutionhttps://community.airtable.com/t5/formulas/comparing-of-two-values-in-rolled-up-fields-and-showing-true-if/td-p/61679IF( ARRAYJOIN({Internal}, {Internal}) = {External}, "same", "different" )which works only if the text fields are excatly the same including lower and apper case. ,eaning it is case sensitive.I am looking for a non case sensetive solution.IF( LOWER(ARRAYJOIN({Internal}, {Internal})) = LOWER({External}), "same", "different" )but "= LOWER({External})" is illigelHow can I useIF( ARRAYJOIN({Internal}, {Internal}) = {External}, "same", "different" )to be non case sensetive?   

How to add multiple images to Airtable's WebClipper inside a single attachment field?I know how to use css selectors to get a single image in an attachment field. I know I could use multiple attachment fields to get 3 images from a website with 3 css selectors. But I want to have all the three images (or however many exist) to be all added in a single attachment field.

Hi All,We are in the process of migrating our database from Airtable to MongoDB as part of a scale-up effort, and I was wondering if anyone here has experience with such migrations.Specifically, I'm looking to understand:Key considerations to keep in mind during the migration process.Potential risks or challenges we should prepare for.Limitations or differences between the platforms that might impact the transition.Any tools or best practices that helped make the process smoother for you.Your insights or lessons learned would be incredibly valuable to us as we plan this migration.Looking forward to hearing your thoughts!

I created a new view in a base with existing shared views. On this new view, the share button is not visible like it is on the others (see attached screenshot). I submitted a support ticket for this last week and airtable hasn't gotten back to me yet. Can anyone help?

I'm a video editor, creating a client portal in Softr. On the Video Details page I want to embed the video player review page (external). If I use a URL field for the embed code, Softr is fine with it. However, I set up a Formula field to concatenate the first part of the embed code, then the url of the review page, then the last part of the embed code. The formula works, but as mentioned, Softr doesn't like Formula fields. I set up a URL field, but just need to figure out how to get the results of the formula into it so I can embed it on Softr. How would I automatically/dynamically copy the results of the formula into a URL field?Thanks

I'm attempting to make a csv import into a synced table. I've curated the data to import and I'm 100% sure that it would only be updating existing records, not creating any new ones, but as soon as I set up the field to map by, I get this: Like I said, I have 100% verified that no records would be created with this import, I am 100% confident, yet this still pops up. Is this just a built-in constraint disallowing imports to synced tables, or is there something I can toggle to allow it?If push comes to shove I can create a helper table, import the data, then use automations/linking to get the data from the helper table into the synced table, that just seems like such a pain in the butt for what could be a simple import.

Hi, I am creating an app that takes user input and puts it into a Gantt chart. I am using Thunkable for this, however, when I run the code to display the Gantt chart, the screen shows: “airtable.com refused to connect.” I have attached the code blocks and the screen that is displayed. In the code for the URL, I am using the private link for that specific view. Let me know if you know how to fix this issue.

Hi All, I’m building out a comprehensive recipe / ingredient / shopping list tool which aims to be the place where I can convert 15 years of working culinary knowledge and interest. I’ll share this when I’m complete. I’ve read about junction tables, implemented one, and have looked at nearly all examples on Universe. Let me first apologize if I’m searching for something that’s been asked 100 times before in with different language. I’m just getting a handle of airtable (and quickly starting to love this product), but don’t yet intimately know the product / language. Today I have three tables, “Recipes”, “Ingredient lists”, and “Ingredients”. “Ingredient lists” is a junction table which forms the many to many association between recipes and ingredients. Avocado toast and guacamole both share avocado. This part makes sense and works well. Here’s where I’m getting stuck. Let’s say I have a recipe called “buttermilk dressing” and another recipe called, “little gems

I have set up a Calendar view for events with Start and End times from my database. The calendar view sometimes shows subsequent/non-overlapping events as overlapping on the calendar. For example, all of the events in the screenshot immediately succeed the previous event. Some are shown as non-overlapping, while others are shown as overlapping events in the UI. Why does this happen? Is there a way to fix so that they do not appear as overlapping in the UI?

I'm using the Airtable node in n8n to search records, and I noticed that the Limit field doesn't allow me to set a value higher than 100. Previously, I could set it to 600 without any issues. Has there been a change in the Airtable integration or any updates to the node that enforce this new limit? If so, is there a workaround to retrieve more than 100 records in a single query? Any guidance would be appreciated! 

How can I quickly get the Airtable Support to contact us? I am seeing a lot of people complaining that that the airtable support does not reply. And the Bot is killing me by routing the whole conversation in circles. I really need them to rectify my issue ASAP, as it is affecting out programmes.Hope that by posting it here they could help me.Reference No: 0088832000889887

Hi all, I would like to know if there is a way to increase the time slot unit vertically in the calendar view. The reason is that it seems that for events with durations smaller than 30 minutes, the events don’t fit any more one above the other and they are showed with a horizontal offset and a slight vertical overlap (see this screenshot). This is not great as it suggests visually that there is an overlap of events, which is not the case. Is there a solution to this problem? In advance, thanks for your help!

Hola :wave: quisiera saber si alguien puede ayudarme con una capacitación de Artable, para gestionar adecuadamente el seguimiento de los clientes. :pray:

I am trying to import XML file but keep getting invalid Xpath (I copy it from XML reader or I modify it based on the requirements) or no results (I am sure that file has 200+ opportunities). Any suggestions?<?xml version="1.0" encoding="UTF-8"?><Grants xsi:schemaLocation="http://apply.grants.gov/system/OpportunityDetail-V1.0 https://apply07.grants.gov/apply/system/schemas/OpportunityDetail-V1.0.xsd" xmlns="http://apply.grants.gov/system/OpportunityDetail-V1.0" xmlns:xsi="

Hi everyone! I would like to know if it possible to search in all fields of a table while looking for a linked record (in another table). I tried to do that but I get result only from the first field

Hi Everyone,I’m experiencing a frustrating issue with a user in my Airtable workspace. I’ve set their seat to Viewer, but I’ve noticed that it occasionally changes to Editor without my intervention. This forces me to periodically check and reset their seat to avoid being charged for an additional Editor seat.This month, I missed checking for a couple of weeks and ended up with a $400 charge due to the seat change. Airtable’s customer support has been great about refunds, but I’d like to find a solution to prevent this from happening altogether.Has anyone else experienced this issue? Are there any known fixes or preventative measures I can take to ensure the seat stays set as Viewer?Thanks for your help!

Please solve for me. If I wanted to control which bases a collaborator (individual) has access to and added the individual to each specific base, am I only charged once, since same user?Example, there are 5 bases in ABC workspace, and Bob needs only access to 3 of them. He’s added to all 3. Since same user/email address, is the charge only for one collaborator?

We are setting up a form that will be filled out by campus staff at many different colleges/universities, so there is no one @ domain. We want to ensure that no one submits a non-campus email address, however, so we want to make sure that regardless of the rest of the domain, it ends in .edu. Is there a way to do that ? They won't be logging in or anything, I just need the form to reject anything that ends in .com, etc.