Other Questions

I have a shared view that should react to data that has changed in another table in the base, however it seems to take a while before the change is reflected in the shared view. Does anyone know what the frequency of the cache refresh for a shared view is? Is it possible to change it?Essentially I have a directory of freelancers that can be used by all contributors to network with each other. Part of that networking is finding out who is near you. Each entry in the directory has a long and lat associated with it and I have implemented a function that calculates distances based on who is selected in a linked table (i.e the person selected there is the point from which distance calculations are performed).I've implemented it this way so that I don't have to get charged for geocoding API calls and because the contributors are not users on my base (they don't have Airtable accounts, they just contribute by filling in their details on a form and viewing the directory by the shared view). Th

I've got two tables "Table A" and "Table B", that are linked. Table B utilizes the look up tool to pull certain information from Table A. However new records were added to Table A and the lookup on Table B isn't pulling that information. There's no view, filter or automation conflicting with this so why are newly created records not being found by the look up tool?

Hello, As a noob in the field i would like to discuss what content/guide should i study to prepare for 2024 API changes. We use Adalo and Airtable with no automation on AirtableI was reading this guide from Adalo:https://help.adalo.com/integrations/airtable/connecting-to-airtableApparently if i get it right, i just have to change "the bearer key" while the link to the base record "https://api.airtable.com/ecc..." remain the same? Thanks

I have a Pro account, but want to allow some users to have Read Only access to an Interface I have created. I did the Share, but it doesn't show up for them on their login page anywhere we can see.Is there something I am missing to get them to view the interface?

I have a table with one field for start date and one field for end date. These dates are looked up from another table. I want to have a field that shows a concatenate of the two. Here is what I have: CONCATENATE({Estimated Start Date},"-",{Estimated Completion Date}) This is what it’s returning 2020-02-24T00:00:00.000Z-2020-02-29T00:00:00.000Z I want it to look something like, MMDDYY-MMDDYY Thanks for any assistance you provide!

our issue that we dont have laptops we use Ipad in our companynow the print function on the PDF generator Extension is working fine on Safari but it is not working at all on any other browser noting that we are using airtable web version on those applications and non of them seem to work "chrome, DuckDuckgo,Brave, Firefox, Opera "

We use QR codes and print labels using the QR codes.  However, Make cannot access the QR code anymore due to the URL's no longer working.  This happened once last week, and then was resolved.  Is anyone else experiencing this?We rely on the QR code URL and this is breaking down our entire business functionality since we can't process any new items until this is resolved.I click the URL and see 'The link you're trying to visit is not available. Please visit our support center for more information.'

A few months ago we found the "over limits" alert in our workspace, after doing an analysis we determined where our over limits attachment came from, we would like to find a way to move all the records with their attachments to another base and delete them from the origin database without losing the attachments

I am looking at to allow users to edit data stored in airtable, without being airtable users. I know how I can do this with form, or with mini extension but I am looking for a solution that would allow user to see all the data in a table, and be able to update the table directly. I have a way to make this happen with a sync between google sheet and airtable, with Make, but I am wondering if there is something else I could do here, more direct. Thanks for your help!

Hello, everyone, This is my very first attempt at using Airtable, and my first question here. My name is Rosane, and I am a programmer. We are moving our processes into Airtable, and I expect to have lots of questions coming up. I have watched several tutorials, but am not finding the answer to my current question. I need to count records in a base, and only display groups that have 9 or fewer records. I grouped my base and collapsed all so I see the counts, but I can’t figure out how not to show all counts. Any help is very much appreciated. Thanks, Rosane

I am the owner of a workspace with pro licens and I want a user to be able to add values for selected records but nothing else. After some time I want to lock the values. Can this be done? In a base there is a table that allows only creators to create/delete records. The table contains sensitive data in a specific field. A view of the data filters out, say, data belonging to March and is named “march-data”. The view is locked A user with permission “Editor” is granted edit permissions in the specific field. The user can now add values in the specific field in the march-data view — great! But The user can go to the filter and “duplicate as personal view”. In the view “march-data copy” the user can change the filter to display, say, February. Now the user can change all data belonging to February — not so great! If the user has permission level “commenter” the user cannot add any values — not so good. I am stuck in between two permission levels. And I don’t think my wishes are overl

Hi, I have some data I have collected from 2 separate clients I have done work with throughout the past couple of years. Is it possible to create 2 separate tables that  pull the information from the original created table and separate them into the 2 separate tables ?The goal is to be able to continue adding data to the original table but it that will automatically update the other 2 tables. The 2 table data's with be shared with each specific client and I don't want them to see their competitors project informationHopefully that makes sense. I have attached an example of my original table and clients name is the data I would airtable to separate into different table

Has anyone used this to build a front end for a large scale use case. What did you think of it compared to it's competitors like Stacker or Softr?

One of my workspaces is showing 1.3GB / 1GB Attachment space used, so I deleted some Photoshop files that I don't need in there (as I have them saved in DropBox) and it's still showing up as 1.3GB / 1GB Attachment space. Why won't it refresh with the new, correct attachment space number?

Hello community,what do I wrong? 🙂 I have a field with #Numbers f.e. 80 or 80,1In another field I try to format this field to a url format, that means I would like to replace the , with an -.For this I use the Substitute formula:SUBSTITUTE({Numbers}, ",", "-") No matter how I format the Numbers field, I always get #ERROR! Can someone help me with this 🤗 Many thanks in advance!

I have a table that contains subscription dates using the date field. I’m trying to create a new grid view with a filter that just shows dates that fall into the current month. Seems simple, but I can’t figure it out. I can see how I can use the “is on or after” and “is on or before” operators, but I’d have to manually enter the dates each month. Am I overlooking a setting or is my ask more complicated than I assume? Thanks!

Recently, and inconsistently, when I update a field, the Chrome prompt for Update Password comes up. If I'm updating many fields, it keeps coming up. Extremely annoying to say the least. Has anyone else had this problem? Does anyone have a solution? I don't get this behavior in other browsers, but I'm pulling data from Google Drive and I find working in Chrome easiest. I've got a Windows 10 64-bit laptop with Chrome Version 117.0.5938.150.Thanks!

Hello! I’m building my online store using WooCommerce (on Wordpress.) Trying to think ahead a little bit, regarding how to manage inventory. I’ll outline some points of consideration, using numbers for the community to easily reference when responding: We have 306 product SKUs. Some SKUs are variations of a single product (e.g. we may have product X which has 8 variable combinations, thus 8 different SKUs. When someone buys one of our variable products on WooCommerce, the inventory on my site is automatically decreased by the amount of stock purchased. I would like to have this new inventory change, also take effect on my Airtable database, decreasing the stock number by the same amount purchased on my site) Another point to consider… When I place an order from my Wholesale suppliers I will get a bunch of new inventory for a variety of existing SKU’s. THIS is one of the main reasons I want to use Airtable to manage inventory… it’s so much easier than going to each product and updating

I find the Grouped view of tables very useful, but need to be able to get the data into Excel format for my board of directors. Is there any way of doing this without downloading the whole, increasingly large, table?

Hi, we are getting a "over limits" alert on the top right corner of our database screen. What does this mean and what can we do next? We are still using it to this moment and adding new data, will there be a problem in storing the data safely? Will it affect the current data (for example, get erased or moved somewhere else)? Thank you in advance!  

HelloI'd like to know if it's possible to trigger a post_message event when the form is submitted (this is for an embedded form). I've seen that the system is already used to manage iframe scrolling with the "airtableDisableScrollbar" post_message.Having information on whether the form has been sent (and whether it was successful or not) would be very useful for managing other events on the "parent" page on which the form appears.If this is not possible with this solution. Is there another way to do this?Thanks in advance!Sincerely

Dear community,In the company I work for, we have a base which contains a lot of sensitive data about clients. We are currently on the Team plan. I noticed that there is no inactivity log out in Airtable. The only safety measure I could potentially take is 2FA. Although, preferrably I would have 2FA, a inactivity log out and something that makes it only possible for colleagues to log-in when they are on their work MS365 account.I see this last thing is possible with SSO, but that's only applicable for business. Since we are a foundation, that is hard to afford for about 20 employees. I hope someone in the community can help us with this security issueThanks a lot,Sid

On the website https://www.airtable.com/partners, it says that one of the benefits of joining the Airtable Partners Program is that "you’ll reach new audiences within our broad customer base and tap into new markets via our channels". Currently, Airtable customers can search through a directory of Airtable Service Providers https://ecosystem.airtable.com/consultants. Are there other ways for them to reach existing Airtable customers?

I have an annual Airtable payment due on December 7, 2023. I have to get prior approval for all software purchases, and I need to submit an official invoice for the approval. I can only see my past invoices (Nov. 2023 and before). Is there a way to see an invoice for an upcoming payment?This is crucial because the payment is set to go through automatically. I will get in big trouble if I allow a payment to go through without getting the pre-approval. But I can't get the pre-approval without an invoice!

We have multiple users working on our Base at the same time. Because any changes to a Table View persist across all users, we have to have personalised Table Views for each user. Otherwise users clash with each other when editing a particular Table View. This is fine, but it limits our ability to use Table Views for what they are designed for. If we want to have different Table Views for (example) different film genres. Then we need to create a Table View for every user for every film genre. We then end up with a long, unwieldy list of Table Views. There are some features that we simply don’t use because we don’t want to create more Table Views. This could be avoided by allowing users to hide Table Views that remain hidden every time they log in. That way each user could have their own personal set of Table Views.