Have other Airtable related questions? Post here!
Recently active
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.
Hi, I am using Make to upload a video file in an Airtable record, but for an unknown reason, the video gets deleted automatically as soon as it's uploaded.Has anyone experienced this, and if yes, how can I fix it ?
Unique Lookups - We have a Collections table, and a Projects table. Several individual projects will link into a single collection. Each project may have the same resources working on it, or it could be different team members. Currently lookup will pull in a name 5 times for example, instead of the same name only appearing once. Is there a way to use Lookup to only show the unique resources similar to the way Rollup Arrayunique works? I don’t like rollup because we lose color coding when doing this on single select fields and we lose notifications/automations that can happen with contact fields. I know I can run automations to watch for changes and then create a duplicate field that writes the values for the cell, but it would be nicer/safer/cleaner to not have to do that. Is there any way for this?
The result I am looking for is similar to the ARRAYUNIQUE function for a Rollup field. However, the results are a link to another table, and it seems that using a rollup can only show text results as opposed to clickable records. How can I make lookup field show only unique results, or make the unique results of a rollup field clickable?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.