Solved

Hi, I’m trying to create an interface that shows only the status “To send” and not other status. As you can see in “Status 2( from Report)” there is also the status “Done”, I would like to filter the data. I tried to filter the interface in this way: But it didn’t solve my problem. This is my dataset: is someone know why “Done” is still there? and how can I solve this issue? Thank you very much!

I have three tables in one base. In each table, there is a Name field and a checkbox field named “Flag”. How do I create one “grid” (or interface or anything else) that lists only the record names from all three tables that have the Flag checkbox checked?

Perhaps I’m missing something, but for whatever reason I cannot get a list of bases available to me using the latest OAuth API integration. I have “shared” a couple of bases that I want to be available via the API, but I get nothing but an empty array when querying the List Bases metadata endpoint. curl "https://api.airtable.com/v0/meta/bases" -H "Authorization: Bearer <access_token_from_oAuth_response" {"bases":[]} I have confirmed that my access_token is indeed good does return my user ID and scopes allowed via the token. curl "https://api.airtable.com/v0/meta/whoami" -H "Authorization: Bearer <access_token_from_oauth_response>" {"id":"<my_user_id>","scopes":["data.records:read","schema.bases:read"]} I presume that I haven’t “shared” the base in the way the API expects, but I have not found where I might do that. Ian

When creating a formula field with an IF statement where I want to check the value being returned before deciding to use that value or display something else I run into an issue where it seems terribly inefficient to have to basically have to call all the functions twice. IF({INSERT CONDITION HERE WITH A LOT OF FUNTIONS} > 0, {INSERT CONDITION HERE WITH A LOT OF FUNTIONS}, “NO”) Is there any way to avoid having to basically calculate a value for something twice when using it in an If statement? I’d hate to have to make a field just to hold calculated values that are only useful so that the IF statement doesn’t need to calculate the same thing twice. Our fields are already a bit bloated as it stands. Any creative solutions?

I am getting in inexplicable result from a RIGHT(SEARCH()) formula. My .csv import includes the field [Payroll Name} formatted as LastName, FirstName. I found a name reversal formula on this thread: RIGHT({Payroll Name}, SEARCH(‘,’, {Payroll Name})-2)&’ ‘&LEFT({Payroll Name}, SEARCH(’,', {Payroll Name})-1) The formula returns the last name correctly, but the first name returns a maddening variety of results. Some first names are correct, others include the comma and space from {Payroll Name}, some include the last letter of the last name, or remove the first, second, or third letter of the first name as shown below (The FirstName and LastName fields are the respective portions of the {Name} formula, shown for clarity). I have tried a variety of values for “-1” and “-2” (among other things), with unsatisfactory results. Of course I can correct the first name problem in Excel before importing, but I am super curious about how to fix it in Airtable. What is going on here? How d

Hi everyone! After checking several topics I still couldn’t find something to solv the problem I’m facing, so here I am. We have a table called Tasks and the following fields are important for this: Due Date (Date field) Completed (Checkbox) Completed within due date (formula) We added a Last modified time field to look to Completed field, so it returns the date that collaborator finished the task. To compare the date that Completed was checked with the due date, I tried the following: IF({Due Date} = {Last modified time},“1”, IF({Due Date} > {Last modified time},“1”, IF({Due Date} < {Last modified time},“0”))) The problem is even if Due Date and Last time modified has the same date, the formula field is returning 0 and my guess is beacause of the time. Due date was not created with time - because it doesn’t metter for us - but if we allow time, it shows “11/16/2022 00:00”. So Last time modified will always be after due date since we will always finish our task after 00:00. And

Hello, This topic has been discussed many times among all the Airtable experts but it has remained similar since it was started. Airtable provides many features in UI or using Interfaces but when you talk about making integration with other tools or using some programming language it still lacks features and also limits in accessing data via API. We can understand that Airtable want to control everything(every request) and they need to make sure that security is not broken by using API and developer options. But I think they give at least some built-in options so developers can use it. For example: If I’ve to access more than 10k records in my custom build CRM/Software, I’ve to make 100 requests with their specific rate limit to fetch that data. If I need to filter some data directly it’s still really slow. I can able to access the base schema or update any basic fields( Manage select field via API is super useful). There are lots of things.

I have been working on an integration to automatically save important emails to airtable for further tracking and attaching emails to various tasks and projects. Looking for feedback from our community 🙂Grid view:Individual view (partial):How does it work?Simply forward any email to a designated address (similar to how other project management tools work)A script will pick up the sender and cc, dates, attached files and other email attributes if any and save it to an airtable of your choiceYou will be able to view the entire email thread in airtable and manage emails with your other existing workflowsCool features:Auto tag emails with hashtagsAttachments are automatically saved to airtableSender and CC are saved as email fieldsPossible to auto forward (with or without email rules as filters) to automate email importingWorks with BCC to save an outgoing email to airtableThis Airtable extension is now live at TaskRobin.io 🙂  

First ever question for the community! I have a table with a single select column that contains the names of different documents and articles used while conducting secondary research. I would like to create a new table that adds each unique document to a single row. Suggestions?

Hi Everyone, I duplicated a base which I’ve done many times, but this time entries from the associated form did not start at 1. Is there anyway to edit the existing entry IDs if the form is still open/accepting submissions? Essentially I want to edit the current entry IDs so that they go from 1 and increase in numerical ,order, then have the future entries follow that order. Thank you.

Hi! I have two tables with data that’s pulled from another site through Zapier. Table 1 shows a list of registrants for an online class (User ID, Name, Email, Course Name fields), and Table 2 shows a list of users who completed a class (User ID, Name, Email, Course Name, Completion Status fields). I’m trying to set up an automation that would add link records in the two tables, so that I can see which people who registered for a course actually completed it (by adding a Lookup field in Table 1 that would pull in the “Completion Status” field from Table 2). Creating a manual link each time someone completes a course is possible but would take up a lot of time. The problem is that each person might register for and complete multiple courses and would have multiple records in each table. So an automation that links records just through the Name or User ID fields wouldn’t necessarily work. Is it possible to set up an automation that would link records only if the User ID and Course Names b

Hello everyone—when I filter a column in a base, Airtable adds a green background for all cells in the column. Is it possible to disable this coloring? (likewise for grouping and sorting, only with the colors purple and orange) I can appreciate what the designers were trying to accomplish (clues in the user that automatic processing will occur on that column), but the visual disruption it creates in my case is not worth the indication (I would argue it’s better to just color or otherwise format the header row only if that is the aim).

Hi Airtable Community, I’m having issues embedding a view into Notion. When I embed an airtable view into Notion like before (I have a whole website full of embeds that worked in the past and still do) it doesn’t work anymore and now just shows the link: I’ve seen a similar query posted 15 days ago but it just today got closed. Has something changed in the Airtable settings maybe?Any help would be really appreciated. Thanks in advance!

This is a newbie question. I have a sequence of numbers in my inventory and these are not auto generated, so I am either working with Number or Formula here. I am trying to add zeros to a sequence so that all numbers have 6 digits. Currently, my numbers start at 0 and go up to 4 digits, I think I am looking for an If / Then LEN formula, but I can’t figure out the syntax to make it work. For example, I need 5 to read as 000005, and I need 1401 to read 001401. etc. Thanks in advance.

So in search extensions say I search up like “walmart” and all the Walmart tabs come up how can I print that?

Hi everyone, I have a table design query in 2 parts. Firstly, I’d like to know your opinions about creating a ‘people’ table in a base - is it best if it is one table or many? For example, I have people that are: ‘students’ taking classes, ‘payees’ that might pay for those students’ classes (some students pay for their own). ‘company contacts’ who normally don’t take classes or pay (but work for companies that do pay) If I create 3 separate tables, all these 3 groups of people will require similar fields in each of those tables and a payee could also be a student themselves… also a company contact might also be a student so I think that one table would probably be better with each person marked with a different (or multiple) ‘person type category’ (in the case of students who are also payees for example). Is there any reason/advantage to keeping these different types of people in different tables? The second part is payment related: Classes can be paid for either by the students th

Hello Right now Im on airtable pro trial plan and Im trying to use automation script but it tells me that its not available for my current billing plan. I was wondering whats the point of pro trial if I cant access its features? Then I tried to upgrade my plan to plus and Im only able to select yearly plan for billing and I cant choose monthly. As you see the image Im upgraded to plus but still not able to use this script feature. Thanks for reading

I am trying to use Promise.all to asynchronously get data from an array of urls. I’m fairly new to promises but as far as I understand the below code should work? The code executes but no response is logged from the promise.all Promise.all(urls.map(u=>fetch(u,options))).then(response=>{ console.log(response[0]) }

Hi is it possible to tell airtable to look at two fields and look it up/match the fields on a different table and return the corresponding value? For example: Looking at the first image, L5 field (Media Engineering) and the size field (s) lookup the value for “s” in another table, second image, AND for Media Engineering and return the corresponding value? In this case it should return 20%. Any suggestions welcome! Thank you!

Hi guys, It looks like a change has happened overnight - URLs to attachments have changed from this structure: https://dl.airtable.com/.attachments/d656d5c54fbc38ad9195c2f62cd02dae/5eb64051/Supreme_Apex-1120x740.jpg To this structure: https://v5.airtableusercontent.com/v1/10/10/1668182400000/q_tvhAt9ivi_oCjJ5LvWQQ/ghcs73y0Vma8Rz6c7EJaen3sRTVMOCrqmPpkS38kxl2SOiMEE5boOfVOorY5nfQ9PZkrQCYfehg76B4CcI8-MA/1wi2qtg7XnHCVhZhtKjxg_BXwwegwsGxphbPlJRYlao This has broken our API integrations for saving images to WordPress / WooCommerce as WordPress requires a file extension to exist. Has there been an announcement anywhere about this major change?

Hey guys, I’ve been really struggling with this for quite a long, hope you can give me a hand. I’m aware, that those questions have been asked already several times here, but still I couldn’t apply any of proposed solutions to my case. I have table A where I’m adding booking numbers. There are also several “special” booking numbers in table B. Whenever in table A there is a booking number, that already exists in table B, I want to have it tagged/highlighted in the next column (in table A). In the same table A, I’m adding a notification numbers. Whenever I add the notification number that already exists in the same table A, I want to have it highlighted in the next colum. Thanks a lot

Greetings! I’d created a formula: CONCATENATE({Month #},“-”,Month) so that grouping in my table(s) would do so since obviously April would be first in the order, etc. However, when I have it sorted in the chart, as you see, the order is, well, not what I’d expect. Any suggestions?

We have an Automation setup to send an email notification via gmail account. In the email body is an Attachment field. The email recipients could open the attachments perfectly fine for month. In the last 2-3 days (likely as a results of the Attachment URL change/expiration), these attachments thumbnails show in the email body of the email notification recipients, but there is an error when clicking on the thumbnail image to try to view the attached file. Here is what the recipients see… The email recipients, as in the example of the screen shot above, are not users of Airtable. We just send them email notifications. Any way to fix this? Thanks, Khuned

I have a “Tasks” table with a checkbox (Open OR Complete). I want to list (Rollup) all “Open tasks” in one field and “Complete tasks” in another field on a different table (Clients) What should the formula be?

I have a formula field that creates a URL from a form, with pre-filled data. We are sending this URL link via an automated email. When someone receives the link on a mobile device and tries to open it, they land on the Airtable site and are asked to sign up. It does not display the form in a browser.This is not an issue on a computer. How do we fix this?