Ask the Community

Hello!  I'm relatively new to AirTable, we're migrating here from FileMaker Pro.  I'm forced to duplicate a calculated field in FileMaker, which is essentially the same a a Formula in AirTable.  Basically it does some complex looking at a zipcode value and either displays a Metro Region if it's a certain zipcode, or instead, just displays the City name.  I've been trying to do this:SWITCH(AND({l_zip} >= 94100, {l_zip} <= 94199), "North/San Francisco",AND({l_zip} >= 93600, {l_zip} <= 96199), "North/Other Cities",{l_zip} = 91604, "South/Los Angeles & Vicinity",{l_zip} = 91711, "South/Los Angeles & Vicinity",{l_zip} = 90755, "South/Los Angeles & Vicinity",AND({l_zip} >= 90000, {l_zip} <= 90199), "South/Los Angeles & Vicinity",AND({l_zip} >= 90200, {l_zip} <= 90599), "South/Los Angeles & Vicinity",AND({l_zip} >= 90800, {l_zip} <= 90899), "S

Good morning to you,I'm trying to create dynamic ToDoLists.At first, I thought I could solve my problem by using complete NoCode (see my post).Finally, after some advice, I turned to @Giovanni_Briggs code and post.I've never coded the day before yesterday, and I'm trying to use AI tools to understand what I'm doing.I've managed to adapt the proposed code to my base and half of what I want to do works.As it happens, my code copies the tasks from my original list very well,It links the new tasks to the event we've validated internally,But it doesn't create a link between parent and chil

Hi there! I am using IF formulas in two separate formula fields and they work just fine. I am trying to merge the formulas in one field and it is not working. The third and fourth IF keep disappearing. Can someone please help me?Here are my formulas :1st fieldIF(AND(Campagne = 'Grands Donateurs - Somme à amasser', {Progrès de la campagne} = 'Somme à amasser'), {Objectif restant},IF(AND(Campagne = 'Grands Donateurs', {Progrès de la campagne} = 'Somme amassée'),{GD - Montant promis})) 2nd fie

I need to get some Airtable data into a Powerpoint/Google Slides/similar, without copying and pasting. Any ideas please? This isn’t an ongoing automation requirement, it’s a one-off. And I’m not sure merely embedding an Airtable is going to fly for the recipient. Thanks.

I have one table with item names in the first column, and I want to add a column that displays TRUE if the item name is present in the first column of another table of item names. In Excel I would do this with a VLOOKUP or MATCH wrapped in an IFERROR.

I have a table "Performance" with device performance data of my app. The table has the following columns: user-id, device-name, fps, time-stamp Now I want to extract the devices which have "fps" below a threshold (let's say below 10), because I want to blacklist those devices. I want to check in every week and see if there are any "new devices" with less than 10 fps and add them to the blacklist. say I have a second table "Blacklist", where I manually enter the devices I have so far blacklistednow a new record enters the "Performance" tableI want to check if the "device-name" of that new record already exists in the "Blacklist" table and if not, hightlight the field, or set a flag in another field, e.g. "IsBlacklisted"how to do that?

I'm inputing a list of records to the Update Record action. Let's say 3 records. I want a field in all three records updated. In the Record ID box if I enter a record id only one of the 3 records is updated. if I leave the record id box blank and click search I put one of the record field names in the Display box and I put the following formula in the Formula box.IF(OR({Net Profit} < 2,{ROI} < 0.4,{Average Rank (90 Days)} > 99999,{Amazon 3x Cost} < 3,{Pack QTY} > 2,{Estimated Monthly Sales} < 10,{# of FBA Sellers} > 5,{EUM} < 10,{EPM} < 13,{Rating} < 3,{Reviews} < 10,FIND("Oversize", {Product Size}) != 0,FIND("yes", {Amazon Sells and in Stock}) != 0),RECORD_ID(),BLANK())This formula is based off the filter I use in the Search Records action. When I try to exit I click ok and the 3 values of the field that I entered in the Display&

Morning! I'm trying to figure out a formula but struggling to get it to work and wondered if anyone could help please?Status column is a single select column with status numbers from 0-499 which i want to add information into a new column from a formula showing "1. called off and not yet delivered"Status 500 needs to say "8. Not listed in dropdown - detail in Comments" in the same formula column.This is as far as i have got, can anyone point me in the right direction please? Thank you!  IF(  OR(    {Status} <500, "1. called off and not yet delivered"){Status} = 500, "8. Not listed in dropdown - detai

Hi AllI have a base with 3 tables: Routes, Passengers, and Absences. The Routes table has multiple passenger fields, which are linked record fields to the Passengers table. The Absences table has a passenger field, which is a linked record field to the Passengers table and has a lookup field to the associated route field - as well as a date of absence. When an absence is added to the Absence table, it pulls the route the passenger is on. If a passenger changes route, the linked record lookup field for the route in Absences will change for past absences. This means the data in Absences is no longer historically representative. What is the best way to preserve the original route that is pulled through onto records in the Absences table? Preferably I would avoid: a) having the route name in an extra text field or b) creating a linked record field directly to Routes rather than using a lookup field, but open to all solut

In a grid view, I can select multiple records and then right-click to e.g. delete this selection.Is it possible to add this selection to a linked record field in another table?

Text:I am interacting with two tables in my AirtableFirst table: "Payment History," where I have a lookup column called "Unpaid Delivered Tasks" that displays codes in a format like "#C0005, #F0055, #T800."Second table: "Sales," where the first column is called "Unique Code," and it contains codes corresponding to each sale. Additionally, there's an important column named "Advisor Payment Status" with two options: "Pending" and "Paid."What am I looking for?I'm trying to find the most effective way to update records in the "Sales" table when an automation or script is executed from a specific record in the "Payment History" table. The goal is to search for all the codes listed in the "Unpaid Delivered Tasks" column of the "Payment History" table and update the corresponding records in the "Advisor Payment Status" column of the "Sales" table to mark them as

Hello!I have a table called "Payments" where I record all my payments of the day, I upload a csv file daily. Each record represents a transaction and could be a declined transaction or an approved one. Daily I check my declined transactions and call my clients, if they answer and agree i fill out a field called Rescheduled Payment Date. The next day I'll upload the csv file of the payments of this day and want to create an automation that finds a record with the same name and that the payment date matches the Rescheduled Payment Date of the first one it encounters if the payment is approved. I hope this is possible to achieve and thank you in advance 😊

I'm writing a script in Airtable Extensions to pull data from Canvas API. I've set the per_page limit to 100, because that's the maximum number of objects Airtable will retrieve at once for an external API.I need to use pagination to download the rest of the results. According the Canvas API reference, it's in the response header Link value. I'm able to see this in Postman but how do I retrieve this in an Airtable script? How do I set up a loop to paginate until the end? All the online discussions are about Airtable's API and I can't find how to retrieve response headers.  let currentCourses = await remoteFetchAsync("https://XXXX?per_page=100", requestOptions); const currentCoursesData = await currentCourses.json(); console.log(currentCoursesData);    

In the Teams plan, can a form that's shared with a Commenter and filled out via mobile web browser be secured via password?

I have a table with a field "Project" by which is grouped.It is filtered by a specific project and by records in which thewhere the field "Project" is empty. Between some records, the emptyproject group and the records of the non-empty project group there isa relationship in another field.The goal is to have the records in the empty project group that have a relationshipto the non-empty project group appear together in one view. Is this representable in Airtable?

Hi The screen shot is of a table for sales in one of my bases. The 'pay window filter' field determines which pay month the date falls in, our pay windows run 25th to 24th, so 26th September would fall in Oct Pay Month. The 'Pay Month' Field formats that date into the correct Text format I want which then links to a second table called Pay Months where the record name is October 2023, November 2023 etc. As you can see from the screen shot, I've filled in a new record with a date, its automatically calculated the Pay window filter, but 'pay month' has automatically formatted the text and linked to the other table. Why is this, am i missing something? I thought this would automatically do that. I'm new to airtable just building out systems for my business, so any help much appreciated. 

Hello 👋I took an effort and explored other related posts available. I came to a workaround I am not happy with, so I decided to make a new post and ask Experts for guidance 😇 I know almost everything is possible with Airtable, sometimes we struggle to find a way.Problem StatementHow can I display linked records that meet certain criteria (not the lookup/rollup field), but exact records.ContextI have 3 Tables (relevant for the issue). Chapter, Event, Sentiment. The story looks like this: There are different Events. Chapter Members from multiple Chapters provide responses about given Event in a form of Sentiment.Relations(one) Chapter - (many) Events(one) Chapter - (many) Sentiments(one) Event - (many) Chapters(one) Event) - (many) Sen

Hi there, Tablet : Galaxy Tab A8 SM-X200, Android 13 As the title say we just got a brand new Android Samsung Tablet for our workshop to be able to check the PDFs of manufacturing plans. However, when i click the pdf file, it displays a broken image icon.The thumbnail preview does show the first page of the plans, downloading the pdf and opening it in another app of the tablet works, i tried opening the same pdf on dropbox from the chrome browser and it works, of course on the desktop-chrome it works.  Do I need to enable anything on the tablet or app?  Thanks for the help

Hello, everyone,This may be a very specific use case, but I have created prefilled URLs from formulas that I need to get to my reviewing committee. The problem is that they want a once a week email that has the information in a list format.This is largely not an issue as the rest of the informing information gets across, but it does present a challenge as when the formulas are one of the fields turned on in this list, they don't hyperlink.Is there a way to work around this, or should I focus on an alternate way to get the prefilled URLs to them?Thanks!

I am unable to remove collaborators—and keep getting billed for them every month. I go into workplace settings and view the list of billable collaborators—of which three are listed— not including myself. I click on “add or manage workspace collaborators.” However, only I am visible. A search by name or email address also produces nothing. Please advise. Thanks!

Hey Folks!When I copy and paste the contents of a multi-line rich text field, it seems to remove formatting, including the bullet levels, spacing, etc. For example:Test 1Sub note 1Note 2Sub note 2Sub note 2aIt shows up like this:Test 1Sub note 1Note 2Sub note 2Sub note 2aThis happens both when I copy and paste and also when I send a record. The send record preview also shows the unformatted bullets.  Any ideas?  

Hello,I configured my date format to European on Airtable, however, when I send this data to Integromat and making a Google Sheet template, it reformats the date in US.Date on Airtable (03/12/2022) :Date format received by Integromat (2022-12-05, yes I know is not the same date :p) :Date on the template :Do you have any idea why the date format changes on export?Do you know any way to circumvent this?Thank you in advance!

I created a form type page in interfaceI want a field to only display data that comes from another fieldexampleI have a project table and an apartment tableeach apartment corresponds to a single project(the connection is well created)logically in the form when we choose the project we must display in the apartment field only the apartments which correspond to this projectTHINK YOU

I've set up an interface dashboard that pulls in data from two different tables. Within this dashboard are two number elements that are Field summery Sums of data from the two tables. In a third Number element I wanted to use a formula to divide one by the other, I thought I could use a very simple formula for this in the element itself, but I cant. Is it possible to do what I need in the interface dashboard?

Hi everyone. Recently, one of Airtable users shared their Workspace with me. There is a base in the workspace with a lot of automations, and sometimes they fail to run.The workspace (and the database) owner receives emails saying, "Something went wrong with an automation..." but I receive nothing. Is there a way to fix this and allow me as a collaborator receive those notifications?