Other Questions

[First time Airtable user] I am working to create a master database of contacts linked to their segments in the industry. And in those new tables I want there to be more information on the companies. Table 1: Master contact list I want this table to hold all contact information of the person including if their company that they work for is in the Top company list on other lists that I have. These lists are detailed statistics and information on each company in my industry. Other tables I thought I might have are: Clients, Topp Supplement Companies, Top Raw Material companies, etc. I need help in organizing this data to where if I go to a person. And I know they are the CEO of X company, then I can see if that company is in the other lists I have (maybe in another table?) and from there I can see all of the information I have on this company and having all of this linked… If this makes any sense at all please let me know and if you have any suggestions that would be greatly appreciated!

AirTable acknowledges that users like to create many views. What they do not understand is that while yes, views are critical, we are forced to create more views than we want for one key lacking feature (bug IMHO):"Grouped by" view on “Multiple select” field does not separate the individual valuesE.g., if a table has one record with “Product1” available in “USA” and a second record with “Product2” available in “USA”, “Canada”, then grouping by availability will currently yield two results, “USA” and “USA, Canada”. Instead it should show “USA” with Product1 and Product 2, and “Canada” with Product2.USAProduct1Product2CanadaProduct2Of course, this gets much worse in real-world examples where you have larger numbers. The manual, painful workaround? Manually create a filtered view for each multiple select value. UGH! Note: the UNNEST command in SQL uses an array field to create one row per array element

I'm trying to move attachments from AT to Google Drive using Make. For some reason when the scenario runs, the files that get created in Drive are invalid. These are small png logo images and when I try to open them in Drive I get an unrecognized file format error. Here is my Make setup:Is the AT attachment URL field the correct one to be using?

Hello! I'm trying to avoid using Google Forms to keep everything in Airtable, but have some trouble creating the matrix-like question in Airtable Forms (check attached image). Is there a way to create this or is it impossible? Thank you!

Hello all, We use Airtable to manage our auto export business, mainly for keeping track of documents in/out and car movements from one warehouse to another. I’m trying to create a table where we can keep track of where / when / who happened to the docs It is linked to our Master table which has all the main vehicle info (vin / make / model / customer / price…etc) , but our Master table has a “stock number”(autonumber) as Primary field. When I setup a new table called Doc Tracking, then Link to Master, when you add a record, it only looks up the Primary field, but not able to search by partial vin. It’s kind of cumbersome to enter by “stock number”, which we only use for filing purpose. we always go by the VIN for everything else. Is there a way to define which field the “Link to another Record” looks up? Thanks

Hello, I have a question that I am having trouble finding an exact answer for; my company manages week-long events at a large scale and I'm trying to determine how much it would cost to allow several temporary collaborators on a specific base for a week.I know that Airtable bills per user prorated by day, so does that mean if I bring in 5 users for 5 days and the monthly cost is $24/month, would the answer be $0.80/day per user*5 users*5 days= $20 total added to the invoice? I hope this makes sense, let me know if you need any more context! 

Hi, I’m using Airtable to manage my library. I was hoping I could use it to automatically calculate the due date based on the date I loaned the book out. For example, if I loaned the book on the 5th of October, I want to add 14 days and have a column saying 19 October for due date. How do I do this? Regards

I'm pasting a single-line text field ("Whisky Name") into a linked field ("Link to Summary Page"), and it used to paste all the names across into the linked field. The action was that if a name matched with an existing one, it linked it to the existing one and if it didn't, it created a new line in the summary table.When I pasted all the single-line texts across, it matched the existing ones and left all the ones that would be 'new' items blank. I know this because if I manually select the link cell, type in the name (nothing shows up), and 'click create a new record' it works. In that case, if I have a duplicate further down and I try the copy-and-paste method, it works because it now has a match.Has something changed?

So I am having an issue with Airtable on MAC. When I am in any base and on the first table the button to add another table is constantly flickering. (see Link for a video, not my video but same issue),https://community.airtable.com/t5/other-questions/text-in-header-blinking-flashing-bug/td-p/132478The weird thing is it isn't happening across all my devices. So I have a Mac Studio and on Safari, this is where I am having the issue, But on the MacBook Air and Safari I am not having this issue. Both devices are on Apple Silicon. Is there anything I can do to fix this? 

I find that the pricing page shows that the free plan can have unlimited bases. Detailed plan comparison table on the pricing page shows that free plan can have only 1 workspace. Also I find in this page Airtable Plans - Summary & Overview | Airtable Support page that each workspace can have only 500 bases. So as per that the free plan can have only 500 bases. So what is correct - 500 bases or unlimited bases?. 

I am a historian, constructing a historical database (1940s-60s). When I click on my linked record for a person or institution, some of which will have to link to 1000+ records, I notice that the records are almost arranged in date order - but not quite. As I scroll down, I will notice up to 20 or 30 records running from earlier to later, as I would like, then a record from a decade earlier will appear next, followed by another run of (successful) earlier-later sequencing, though often for yet another subset of years. Naturally, I would like the entire contents of a linked record to run from earlier to later. I cannot see what other sort criterion the linked record might be using. It certainly isn’t the random 6-digit number I’ve created for each record ID. What is odd is how the linked record is almost in date order.

Hello Airtablers, My base is a list of leads with linked tables of their respective organizations and locations. I am evaluating a new sales tool called Apollo and I’m trying to configure their API into my base so I can pull the contacts and organizations. I understand the basic logic here, but my experience using APIs like this is minimal. Can anyone shed some light on how I can go about linking Airtable and Apollo? Here is the github link to the Apollo API.

Is it possible to make a search box appear also in the “grid view” on mobile (as happens in the desktop version)?

Hi All, A search of the community yielded the same question but no definite answer. I have created a view on Airtable, shared it so users can search and find info that they need. Problem - filtering, grouping, and search work only on desktop or laptop browsers. None of those options are available on mobile devices. Is there a workaround or some way to get at least the filter and search to work on a mobile device? Thanks in advance. Regards, usha

Hi, So for the purposes of this problem, say i have 4 tables: Customer table: a list of all customers. New Leads: a list of all leads. Orders: a list of all orders currently being executed. Disputes: a list of all disputes. All records in new leads/orders/disputes have a record from the customer table as a linked record. We have over 100 customers. For our meetings, what we’d like to do is have a dashboard of sorts where we can select any particular customer, and get the new leads, orders & disputes to all appear on one page. Afaik, i can’t see any easy way to do this in airtable. Is there any block or any way that could help me create this? Thanks zeta

Hi! the last column in booking details is payout week. how can I bring that to payout details table to show what each person did each pay period? it shows me what each person did, but it doesn't specify what pay period it is

I have several helper tables for linking and allowing users to choose from sets of pre-defined values. They do not need to be directly accessed and can confuse end users. I would like to find a way for them to be hidden. I found an old thread about this that is marked as solved, but as far as I can tell, it hasn’t been solved. Some options that could work: Allow these tables to move to a separate Base that can be accessed from the Base the consultants interact with, meaning allow Bases to access data across other Bases in the workspace. This way I could group the tables into functional and boilerplate Bases. Access to a show/hide UX in the Base with the tables listed and a toggle switch for visibility. Off state would hide the tab. System or even a hack that allows for custom CSS. Unfortunately the tabs do not have ids, but I may still be able to hack something with nth child. Are any of these available? Is there another solution? If not, can one be rolled out? Thank you,

Hi! I’m trying to create a kanban view and it won’t let me choose any of the fields from the table i’m creating a view from - it only allows for me to add in a new field which i don’t want to do. Kind of defeats the point of this view. what button have i not pressed? any help would be appreciated!

Hi everyone! I followed this support article almost exactly in an attempt to repeat yearly deadlines (grant applications), but for some reason, everything automatically copies over except for the new date. I used the formula DATEADD(Date, 365, ‘day’) to create a column that adds a year to each date (which does work), then tried to input that as the date when my automation creates a new record (triggered by it entering a “past events” view, containing any event with a date before today, so that when a day passes it gets added to next year’s calendar). But alas, the date just won’t copy over. Does anyone have any suggestions? Thank you! <3 The support article I followed: Airtable Support Creating recurring records using automations Join a live training! Power up your workflow   The value of using automations in your workflow becomes immediately obvious when reducing manual errors by automating repetitive tasks.  One commo...

Hi, I'm unable to upload multiple images to record templates - keeps giving me an error. Is anyone else experiencing this? 

I am in the middle of creating a form and have had no issues, but all of a sudden the fields I am creating are displaying in grid view but not in the form. 

Good morning all! First of all, I’m just getting into Airtable and it’s brilliant. I love it! Goodbye spreadsheets! I did some research on the accessibility (as in, WCAG web standards that allow the disability community to participate) and I haven’t found much. So I’m turning to y’all! My question is: does Airtable have any level of accessibility compliance for those who are blind/have low vision? For example, the option to have appropriate color contrast or adjust text size is pretty basic compliance. (If so, how do I enable this?) The ability to navigate entirely with the shift key and a screen reader (what blind people use to hear text read out loud) is on the “A+ you get a gold star!” level of compliance. Anything I can brag to my team about when I introduce them to Airtable? If not, is this something the lovely Airtable team is thinking about or working on? (Either/both on the Airtable end and the form end.) Thank you so much for any input!

I have a grid with many single select fields (over 200).  I am creating a form with the same fields, but two of my single select fields from the Grid View are not available in the Form View.  Does anyone have any solutions?

Hi all, Has anyone attempted to sync data from PowerBI to Airtable?I find it easier to transform data in PowerBI but my end report result needs to be displayed in Airtable. 

I have an embedded an Airtable in a website with URLs that point to https locations that have pdf downloads. When the link is clicked the “https” is stripped off the url (although it is still in the Favicon on the browser tab) and the pdf will not open due to a security issue. Even dropping all security blocks will not allow the page to open. Not a problem with Edge or with Chrome or safari on iPhone. Only with Chrome on PC and Safari on Mac. The link will open if it is in the website outside of the airtable. Update: Incognito doesn’t work; holding Ctrl (PC) or Cmd (Mac) will open the link in a new tab but stay on the main website. But it works!. For developers: “target _top” works but “target _blank” or “target _parent” are loading but not displaying. From the identically described issue stackoverflow.com this was suggested but didn’t work. It killed the table completely when we pasted in the iframe code: I found something! I know your question was 2 years ago, but if you use th