Other Questions

What are my options after I reach  the Table limit of 50000?I've just realized that the record limit is actually a hard limit, not a soft one. What can I do at this point? I'm at a loss. I certainly need more room in my databases - it's crucial for me to store all of my data.

I've been getting this error message recently when attempting to view attachments in my base. Does anyone know what causes it or how to fix it? Not finding much on the help center about preview limitations of this kind. 

Hi, I wonder if there is a formula to calculate number of nights between two dates with times. For instance if I have arrival at 01/09/2022 at 22:00 and departure at 01/11/2022 at 09:00 that evidently means 2 nights in a given place. Any help and ideas will be greatly appreciated.

Is it possible to create a link to a calendar view that always links to today? Is there a way to do this via a URL parameter, e.g. "&date=today"? I have a few views that I consistently reference and it's a bit of a pain to constant find the "Today" button on the view to get it to show the appropriate content.

I am trying to create an analytics table for my reatail business and I created a sheet that includes all the poducts. I have a different table per day that I have sells so in the analytics table I added a column and linked the sells I have per day. What I want to do is to rollup all colums I have in the analytics so I can see my sales per day. How can I rollup sum different colums to get a total per month???

Hello! I have a list of songs, and i would like to invite outside collaborators to rate each song. I know there is a Rating field, but I’m not sure if there is a way to let multiple people rate the same record and then view the results. Is there a way to create a “poll” to allow many people to rate each song, then I can see the total number of ratings and the overall average rating? Thanks for any and all suggestions…

Hi!  I feel like I did decent job searching around to see if the answer to my question already exists, but I apologize in advance if I failed and it's been answered (or/and worse: multiple times. It would mean I suck at searching and my whole identity would be called into question! Egads! And, jokes. I'm joking.) Now, the question:How do I automagically get photos into a table with the meta-data? (Fields, yes, but that's not what I mean.) I assume there's a script or something somewhere (as opposed to this feature being relegated to the IFTTTs and Zapier's of the world.) (I assume I'll be able to figure how I get the pics into the table without having to manually attach each photo bc... well, there's just no way someone didn't solve for this.) Thanks so much! 

See GIF below: Basic project/sprint setup for Gantt view with the "Sprints" here grouped by Project.If I try to add a sprint by dragging out a timeslot in the relevant project, the created sprint/task is created, but not associated with the group/project I tried to create it in. It pops to the top and is not associated with any project. I can't associate it with a project by dragging it down to the relevant project. You would have to click the Sprint and associate the relevant project from there.I find that this breaks my flow when managing multiple projects or just trying to quickly add something during a meeting. It's also made worse by the fact that the left record list (where I can see the name of the Project and associated sprints) is replaced by the record details every time you click a sprint record. This is problematic because I sometimes forget the name of the project, as many of our projects have relatively similar names. So I can see the sprints in the Gantt timeline view, b

I have a base which has the design of one date field and 8 image fields .  It  has been working well - with one entry a day since 20 June 2023.  About 3 days ago it stopped letting me upload photos.  I've checked my stats and I am nowhere near my limits. I have also deleted and reinstalled the app on my phone without success.  My other bases are working fine.  I love airtable however cannot work out what is happening.  Any suggestions?

Hello Airtable Community,I am new to Airtable and currently working on a custom mini extension in Airtable that aims to upload CSV files into multiple tables within my base automatically. I have written a script for the mini extension to handle the CSV upload and record creation, but I'm encountering some errors.- The script prompts the user to upload a CSV file using the built-in file picker.- The CSV file has data that needs to be distributed across different tables, namely: contacts, company, line items, services, and invoices.- Each table has unique fields and linked records, and the script maps the CSV data to the appropriate fields accordingly.- I am using native JavaScript to read and parse the CSV content.Issue:When testing the mini extension and attempting to upload the CSV file, I encountered the following error: [Describe the specific error message you received, if any].Code:Javascript:// Function to handle file uploadasync function handleFileUpload() {const fileIn

I have a base with a table that calculates commissions for employees based on the type of revenue is generated (e.g. Service Revenue, Sales Revenue, etc.). Each revenue type includes a specific commission rate. The Revenue Type field is a single select field. I have created a view that shows information for each revenue record. One of my colleagues is a collaborator for this base. I have created a Revenue Commissions view and created a share link and sent it to my colleague, whose job it is to select the correct Revenue Type for each revenue record. He can open up the view, but when he tries to make a Revenue Type selection nothing happens. When he places the cursor in the Revenue Type field, no drop-down arrow (or + sign) appears. In fact, he has tried to actually type an entry in this field and the field will not accept any input.In the Field Manager I have chosen "Specific Users" to define who can update values in the Revenue Type field and selected his name along with min

Since today, our Airtable base has become extremely slow and is always being delayed by the attached message. We haven’t really changed much from yesterday/last week. It seems like Airtable has changed their loading behavior of views. It’s true, our base is large but it hasn’t changed much in size recently. Still, Airtable is hitting us with this kind of throttling. Anyone else experiencing it? Temporary issue?

Hello everyone,I hope that you can help me with my problem.I tried to export a table in CSV, modify a column and then import it back to the same table with the updated column.However, all the columns that were hosting a link with another table are gone and I need to put them back one by one.Is it possible to import an excel or CSV file in Airtable that was originally from Airtable and has been slightly modified while keeping the links with other tables once imported? Thanks in advance!

I have an Airtable account and so does my client. When they invited me to collaborate on their account it led me into my own account. I can see the collaborators in that company here and can talk to them but now I don't know if what I am creating is in their account or mine. I also want to know if there is a way to toggle between accounts so I can be clear about where I am. 

Hey! I am trying to calculate the percent change between two numbers in the same column, just different rows. If I were doing it in Excel, it would be =(B9-B3)/B3 but I can’t seem to find the way to make this formula work in Airtable. Is it possible? These are the two rows that I am trying to calculate for: Hopefully someone knows how to help! Thank you!

Hello. I am trying to create an automation or a script that updates a cell in a given table based on a unique identifier that can be matched to a unique identifier in another table. In my mind, I'm basically wanting to do a left join, except that I want to populate missing values in a column instead of just bringing the whole column in. So, more of a if x is null, x = value from column in another table mapped by a lookup value/unique ID.More detail about table structure:Table A: File NamesColumn A- Name [short text- is essentially file names, as in ThisDocumentName.docx]. Is populated through a Link to another record column from another table.Column B- Google Drive Link, missing some values [URL]Column C- Unique ID [short text- is essentially a cleaned version of Column A]Table B: Google Drive LinksColumn A- Name [short text- is essentially file names, as in ThisDocumentName.docx]Column B- Google Drive Links, complete [URL]Column C- Unique ID [short text- is essentially a cleaned versi

Hello! I'm trying to write a script that I can run to populate a field in one table with a value that lives in another table. There are key values in both tables that match. I have worked in SAS and a little in Python for data analysis, but I am new to Javascript. I am thinking of Javascript as adding the element of time to scripting ("wait to do this-- I'll tell you more about it later!")A simplification of what I have:Table1FieldA- unique record ID- stringFieldB- column to receive info from Table 2- stringTable2Field1- unique record ID, matches Table1.FieldA-stringField2- column to populate Table1.FieldB - currently is 'link' field type but could be string if neededI tried to this via automation but it's not working. My guess is the long strings used as the lookup values are causing the problem, but I really don't know why it's not working, it's very hard to troubleshoot that any further.I'm pretty close with the script... kind of. I used another script and can get the lookup functio

Hi, I'm new to air table (about 2 months in, it's been in place at my company about 2 years)Some of our employees fill out a form on the flavor/texture of our product, where different categories are rated. That form in imported into another record with all the product information, so I can't see the results from their sampling unless I click the form, then it pops up.How can I get the information from the form into a spreadsheet? The person I replaced was doing it, but she's gone and didn't explain how to do it.

How can percentages be correctly calculated in the grid subtotals for groups, and totals for the entire view, when detail records are grouped and summed? It is not correct to average the percentages calculated on individual records. For example, see the attached image. The correct percentage gain is $500,000/$1,100,000 = 45%, not (50%+0%)/2=25% There should to be a formula calculated using the total of the two columns. Is this possible with AirTable?

Hi there... We are trying to use Airtable to forecast workload capacity vs. demand. Each project in our forecast has a number of tasks. Each task is assigned a "skill" (the skill required to complete that task), a person-week effort to complete it, and start/end dates. (there's other metadata as well - owners of the tasks, the project each is mapped to, etc)We want to know the total demand required for each skill for each month, and be able to tweak these numbers to match our capacity (which is the same every month).  I'm starting with a regular list of scheduled tasks like this:I've been able to parse the start/end dates and determine the amount of work required for specific months, to get something like this:However, now my monthly effort data is in columns, which causes all kinds of problems - I can't graph it across all months or pivot on it. Plus, I need to roll this up to the Project level, but only for certain sets of projects (e.g. all projects of a specific type, etc

Hi all.  Airtable is refusing to allow me to create any buttons anywhere in tables (i.e. data section of Airtable), only in interfaces.When I try to create a button field in a table, I always get the same error message: "Sorry, there was a problem creating this field. The options are not valid." It doesn't matter which browser, which device, mobile app - Airtable will not allow me to create any button fields.  You can see a short video of the error in action: https://d.pr/i/ImBrOD Any insight gratefully appreciated, as I really want to start making some buttons to trigger various actions like sending emails or text messages.

Hi! I have an airtable base and within that base a table (table 1) several fields two of which are the email of the company and then a function that parses the email to get the company name.In another table (table 2) in the same base I have linked the company name to an investment fund.I am now trying to link the company in (table 1 ) to the fund it was linked to in table (2), how could I do this?One edge case I anticipate is capitalization / spacing, other then that there shouldn't be issues.I believe I need to use a lookup field but am having issues with configuration

Absolute Beginner here - still struggling to make Airtable do what I want. So here I am - ONE YEAR later after my first post here, and I am not much further forward in my use and comprehension of Airtable.Admittedly, I have not been continuously attempting to learn Airtable in all that time, but the interface really intrigues me and all the examples make it look really easy to master and the fact is - it isn't!  Being a retired database developer, I am not exactly new to the concept!However, I have just spent an hour trying to get a formula in an Airtable base record that gives me what I want - simple - you would think, but no - not for me!All I am trying to do is insert today's date when a status field in the record changes to a certain value.  I've learned that I can use the function today() in a formula field to achieve this. According to the "reference material", today() only returns a date - Not so as far as I can see!  I cannot find any definition description of th

New to Airtable, really want to make it work but it seems that it wouldn't work well as a CRM where there is a record of all e-mails and Whatsapp messages between us and the customer, and the ability to send emails/messages directly from Airtable seamlessly (please correct me if I'm wrong).Therefore I am looking at a second service to handle that. Any recommendations that would work well with Airtable?

I have a date in CurDt and I want to add YrOffset to it and end up with a new date in a date format. YrOffset can be negative, positive or 0. I’m not sure how to do it.