Other Questions

Hey all, When using the CSV import app, is there any way to delete records that are not in the latest import file? There doesn’t appear to be a native way to do it during the app, but I’m wondering if there’s a simple + straightforward way to do it through a combination of formulas and potentially automations. Thanks so much in advance for any thoughts!

Hello. Two colleagues who have subscribed to an AirTable calendar through Outlook have “imported” the new calendar, but it is not populated with any information. The calendar is blank. Does anyone know what would cause this? Thanks.

Hello All I have an integration with Integromat (that pulls NOAA Weather Zone Alerts). When Integromat fires off a response… in the alert body an array is presented with zone or multiple zones: "UGC": [ "CAZ070", "CAZ071", ] Now. Here is the issue: I then want to search in my NWZ Zone table to get the record ID for each Zone How do I make a formula to search through the array and iterate through the zone name Id’s? Thanks Josh

Hello! I have a Page Designer block set up that I’m embedding onto a SharePoint page so it can be viewed (read-only) by my team. I don’t want people to be able to change the table view that the records are pulling from, but I don’t see a way to remove that drop down. Also, I have to make sure that the view I want Page Designer to use is the first view in the list of views for that table, since it always defaults to the top view in the embedded window. Is there a way to lock it to that specific view that I want it to pull records from?

I would like collaborators to be able to add rows and then be able to edit only rows they added. On the other hand they should be able to “read only” all of the bases content. How would I set this up?

I have an urgent need to find data cells that contain commas and enclose the data with quotation marks A single table, with identifiable columns where needed.

I have built a database in Airtable that is unfortunately just a static import from my company’s database. However, we do have an API that can grab full files or deltas (in JSON). Can Airtable access it to stay current? If so, where should I be looking for info on that? Thanks!

Seeking help I am involved with a project providing holiday gifts for disadvantaged kids. I have a table named Kids, which is populated by others with info on gift ideas per kid. Entry via online Airtable form. Yesterday I exported the data to a csv file for use in a mail merge operation. I proudly examined the output when I noticed some records with clearly wrong data in some fields. Yikes! The cause, I found, was some fields were filled with items that included commas. This messed up the alignment of the comma-delimited input file for the mail merge. So I determined how to identify the faulty records. I duplicated my Airtable table of 156 records, and did a filter on fields with commas. This gave me a list of 67 records. I performed a find/replace on them, replacing all the commas with periods. Here is my puzzle: the original Kids table somehow synced with the duplicate, which now means that it no longer has 156 kids…. But only 67. The good news is that I still have my exported CSV,

is there any way to access a single record via airtable API without using recordID? tried SEARCH() filterbyformula but not working since it is a number field. need to access records based on the SerialNumber. thanks in advance

Hello, I have one table that needs to collect data from two sources. The first source needs to complete basic information (the first 6-8 fields) one of the basic fields is the email address for the second source. Once the first source submits their entry the second source needs to receive an email asking them to complete the rest of the information, another 15-18 fields. I was thinking I could create two forms and use Zapier to trigger the email to the second source. Is there a way to ensure that the second source only modifies their own record? Thank you!

I have integrated Airtable with Google Drive but when I select New and Airtable from My Google Drive, it takes me to an incorrect page in Airtable. I have to then click on a tab called “Bases” for me to access my Airtable files and I can’t figure out how to show them as linked with My Google Drive. Can someone help me?

I’ve created a form for users to input data onto a table. As we’ve growing, some of the status selections have been changed. However, the form did not automatically update. We are creating many forms for our users, and it will be difficult to remember changes on every form. Is there a way for these forms to automatically update (like the views update automatically when shared?) or is this not a feature. Is there a work-around if it isn’t a feature? thank you in advance. Kathi

Hi, I’m trying to add a budget value to a table so that all subsequent entries deduct from that amount. I’m using groups and subgroups and would like each entry to subtract from a budget whilst showing the total value spent against budget

Which app do you use for the knowledge base and documentation in synergy with Airtable? Currently Airtable doesn’t have a compartment for creating wiki and structured notes like Notion. What do you use to solve this problem?

I run a school store where by over 50 student keep different items with me that I group, some of this items are up to 30, 20, 69 and so on. this students come and pick diferent combinations of this items stored with me at any time of the week and will always have some items left until another day, i need a formula that can record all the individauls i keep stock of their items, the items itself and record to show accurately what is taken and what is left anytime a request is made. note that this items are daily provisions. please if there is any other information you need, i will be glad to assist you with it. thanks

I am a long time user of AT. However, I need some assistance. I do operations for a school. I need an elegant way to create the schedule automatically for the classes. I want to input the date of the first class, the days and times they have the classes every week, and the number of lessons in each learning period. I want to automate it, so at the click of a button all the lesson records are created based on the conditions listed above. Is it possible?

I am revisiting this topic from 2017 (see bottom for reference post) I have two tables linked: Tasks, and Subtasks. Tasks also has a column called Area (single select). When I group my data to the linked table Name Field (first column) I can add new entries via the “+”. However, if I group by the linked table “Area” column, the “+” is not visible for adding new items. Similarly, if I then add another grouping below Areas, called Tasks, I cannot see the “+” for adding new entries. Does anyone know how I can group by the last two images, and retain the ability to quickly add entries? Reference post of similar topic from 2017 Add data to “grouped” view - Ask the community - Airtable Community Forum

Is it possible to create a sign up form, that, when filled out automatically gives that new user instant access to the workspace?

My table, Table A is called “UX Debt Log”. I’m using a few columns to help create a prioritizing system for the individual records in this log. In Table A, column C, “Pages Affected”, is linked to Table B which is called “Page Title List and Values”. The cells column C allow multiple values. The next column, column D (“Pageview Value”) is a Lookup column, so it looks up the pages I’ve entered in column C, and returns the total pageviews for each of those pages. Thus, the cells in this column also allow multiple values. What I need is to total the numbers pulled into column D. Is there a way to do this either within column D, or perhaps in a column E (such as column “Total Pageview Value” shown in screenshot below) where I could make that column a formula column and it would end up creating a formula that would total up the numbers in the cell to it’s left? For example, E1 would total all numbers in D1 (reminder, D1 has multiple numbers, pulling from linked table)? If so, any suggestion

I’m in the Help guide: Let’s make a base, Part 2: Views. It says to click the drop down arrow to the right of “Main View.” I don’t have a main view, only a grid view. When I click the drop down, I don’t see the Create a new view option. What gives?

Hi, We use Airtable for rights management for our movies. We have a formula that works well to remove movies that are licensed in a particular country or region. For example if I was creating a list of available movies for France I would use a filter that said Active Contact Regions does not include France. Here’s the formula we use to determine Active Contract Regions. This is only based on geography and whether the contract has ended. IF(AND({Contract Ended?}= “No”,({Exclusive?}=“Exclusive”)),Regions, BLANK()) We also have a formula for Active Contract Rights. This shows what rights have been licensed such as broadcast, streaming, Etc. Here is that formula. IF(AND({Contract Ended?}= “No”,({Exclusive?}=“Exclusive”)),Rights & ‘\n’ & {Holdback Rights}, BLANK()) The problem we are having is that there is no geography associated with the second formula and we need to figure out how to do that. It currently just gives us a list of rights licensed exclusively but there’s nothing

Hello! I am looking to create a formula where the autonumber resets based on the category code selected. Each product has an Item Number which is created using autonumber. I used another tab to create category codes for the prefix of the floor plan ID I create a formula that adds the prefx and item number to create Floor Plan ID Issue The autonumber cannot be reset contingent on the category code. The autonumber is unique to each row created. End Result I would like to have a way to be able to create codes that have the number after the prefix under Floor Plan ID show an autonumber based on the amount of items under that category. IE: it would be AC-1 opposed to AC-2 ( because there is only 1 item with the category code AC so far) Any help would be appreciated! Thank you :slightly_smiling_face:

Lets say I wanted to store a bunch of information, like bookmark URLs. I might have URLs that relate to News, Apps, Development, and these would all be in their own folder in a browser (for example). I know I could store these simply in Airtable using 3 different tables (News/Apps/Development) and each table would have just 1 column (URL). Another way to store them, using 1 table, is to have the column names be the folders where the bookmarks were stored (News/Apps/Development) and paste in the relevant URLs into the correct column. What do you think of this method of storing data? I’m sure it breaks every rule in the book about how data should be stored, where records should contain related data (in this approach that would not be true). But if I wasn’t going to do any processing of the records, would this not be a simple/efficient way to store a bunch of URLs? For one they’d all be viewable at the same time, rather than clicking between tables. Any thoughts on this ridiculous approac

Hello everyone! I have a problem that I haven’t been able to solve. This is my current table: I would to know how much time it takes for Mario go from “Postulantes” to “Postulantes descartados”, is there a way to know how much time everyone of my leads spend on each phase? PS: Sorry! English is not my first language. I hope everyone understand what I mean to say.

Hi! I’m new to both Airtable and building databases more generally. I have a question about junction tables. I’m trying to build a table similar to what is described in this video and on this page. But I’m stuck on a specific thing. I’m trying to build a junction table that contains a record for each association between one of 15 training programs and one of 51 faculty members. The GAP video and the Airtable support page suggest that such a table would have 615 results - one for each intersection between each of the 15 training programs and each of the 51 faculty members. And indeed, when I build my junction table, I get many hundreds of records. But the thing is, only about 10 or so of the 51 faculty members taught at any given one of the programs. The only way I’ve managed to build a junction table gives me a record for the intersection of each faculty and each program–even ‘false’ intersections between faculty and programs they didn’t teach at. The table that captures the data I rea