Other Questions

Say I have a table in which each record has a Single Line Text "Notes" field with content like this:MondayGood FridayTuesdayTaco TuesdayGood FridayTuesdayI want to find all records where the Notes have exact matches, in this case for Good Friday and Tuesday, and display them together.I figured I'd have to add a field to check for uniqueness somehow and then filter for non-unique records, but I'm not sure how to do this. 

Have you had any experience with Airtable Partner Portal? How long did you wait for a response to your application? 

I have a table of date ranges: school terms and holidays over three years.How do I determine which range a specific date occurs within?

Hi,Is anyone else experiencing views not currently loading within their database?We have multiple users reporting seeing a error message "Loading this view...This view may be loading slowly due to a large number of records or fields". Some users are experiencing load times of 20 minutes. Looking into the account the record and storage limits are no where near capacity.The offices internet speed is fast and all other web based platforms are working. Any insight here would be appreciated.

For the last 2 to 3 days, we have found Airtable almost unusable. Very slow and advanced functions won’t load at all. Any solutions appreciated

Very simple, but I couldn’t seem to find it anywhere. I have a “date contacted” date field, and a “follow up” date field. I want the “follow up” date field to automatically populate a date that is one week out. Any help would be greatly appreciated!

I created a "lookup from another field" field, and set it up to pull 4 other fields from another table. It pulls the first field just fine, but then does NOT pull the other 3 for no apparent reason and it's driving me crazy haha. The field I'm using to test DOES have values in those 3 fields to pull, so that's not why. I don't get it. 

Hi Airtable Community! I have a process that requires specific people to provide updates on the 15th of every month. I’m looking for an easy way to create a calendar that will trigger these emails automatically on the 15th of the month at 8 a.m. I’ve had some success with creating a calendar table and developing a formula that flips a field (when criteria met) to a new view that triggers email but the process is a little clunky and I haven’t been able to figure out how to send it at a certain time of day. Any advice/help is greatly appreciated! Thank you.

I have two bases on a free account but I want to move them to my other account, which is a PRO plan account.Can you send instructions on how I can move or copy the two bases in my free account to my paid account?ThanksMark

I cannot figure out how to get a Vega-Lite chart to sort the Issuers in the y axis by the max APR value. Any ideas?? { "$schema": "https://vega.github.io/schema/vega-lite/v4.json", "title": "Credit Cards", "width": 600, "height": 300, "mark": { "type": "point" }, "encoding": { "x": { "field": "Proj\\. SP APR high", "type": "quantitative", "axis": {"grid": true, "format": ".2p"}, "scale": {"domain": [0.12, 0.36]} }, "y": { "field": "Card Issuer", "type": "nominal", "sort": {"op":"max", "field":"Proj\\. SP APR high"} }, "size": { "field": "Proj\\. SP APR high", "type": "quantitative", "aggregate": "sum", "legend": {"clipHeight": 20} }, "color": { "field": "Card Category", "type": "nominal", "legend": {"clipHeight": 20}

Hi all - I’ve built a quick database to better understand who I’m following and who’s following me on Twitter in Airtable using syncs from Integromat + Zapier. Works great, syncs info to column headers for things like bio, # of followers, locatiton, title, etc. All things that help me understand who I’m connected with and can easily search through the database. My question is if I can turn this into a SaaS of sorts where a new user can signup, authenticate their Twitter account, and have a new base spun up specifically for their Twitter account (including followers/following). Is this feasible or goes beyond the strengths of Airtable and require custom code solution? Thanks for your help! Patrick

Hi, friends! I’m looking for suggestions on the best method to combine multiple attachments within a record. Essentially I need a button/formula/automation for each row in my table to act as Adobe’s “Combine Files” function in Acrobat. I use miniExtensions and they have an app to combine multiple attachment field into one, but they are still separate files whereas I need to merge them all into one. Is there an Airtable or Integromat function that can perform this task? Thanks in advance!

How do I change the name of an interface with the new layout? Can’t figure out how to edit.

I am creating an application using an AirTable form. We are asking applicants to rank their availability preference for five single select choices. Since there is no ranked choice voting option available on AirTable currently, my workaround is to create five single select fields (questions in the form) with the same answers in each drop down. It's a little cumbersome.The functionality I'd like is, for each descending selection, the choice(s) made previously to be removed from the list (Ex: If Monday at 5pm was the #1 choice, then I'd like that choice to be removed from the 2nd choice question and so on). This would make it more user-friendly and avoid duplicate days/times being selected.I've a feeling this isn't possible quite yet but, if anyone has a workaround or better option for ranked choice voting in AirTable forms, please let me know. Thanks!

I’d like to expand my base that I use to manage my orders for meal kits. I have a table that calculates packaging cost by entering the case price, then units per case, then it gives the cost per unit. I’d like to add this cost to the different meal kit entries which are on another table. The way that I WANT to do it is to use the “link to another record” field, then use the “lookup” field to pull the cost per unit, then use a “formula” field to sum these together. The problem is that I can only select each entry once in the “link to another record” field. So if I use, let’s say, 3 black plastic containers, I can’t calculate it properly. I guess I could have multiple entries for eack packaging item, but that seems like a weird workaround. Is there a function that might do what I want? I’ve added “food costing” base templates, but each of those uses a separate entry for each ingredient amount (i.e. one cup of flour and two cups of flour are separat

Our main People table is linked to a Work History table that shows the date and position of each shift worked. I want a field in the People table to show only the most recent date that a person worked. Lookup fields do that, of course, but return all of the shift records for each person. TIA!UPDATE: The date of the shift worked is stored as text.

All of the charts on my interfaces are suddenly showing a legend (despite the legend setting still being set to 'hidden')For the amount of categies in the data I have a legend does not work at all (my users now see an incomplete list of categories which is misleading and a smaller and harder to read chart).Has anyone else expereinced this?Help! 🙂  

Hoping someone has experience with this - we’re looking to see if there’s a way to force an auto log out after a certain amount of time has passed, does anyone know if this is possible?

Hello,I want to create membership based table in airtable. I want to know if this is possible in Airtable. I want to master table. lets say tableMaster with 4 column. In master table, values in column 1 and 2 are fixed and can only be changed by the admin but values in column 3 and 4 can be changed by the admin and members. When a new member sign up, the airtable should create instance of tableMaster for this member. We will call it memberA-tableMaster. The member can then enter values for column 3 and 4 to see the view of this table based on his values. When another member join, new instance of tableMAster will be created and we will call it memberB-tablemaster. Is this something possible in Airtable using Softr or any other code platform.

My company, a local city government, uses this service. What steps are needed to secure a government tax exemption?

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???