Ask the Community

HelloHere is a case we're stucked with :For a given company, I need to list projects that are located in the regions covered by the company.For example: company A covers regions 1, 2, 3 - company B regions 2,4project Alpha is located in region 1project Bravo is located in region 2project Charlie is located in region 4Companies are in a table, Project in another one, list of Regions is a linked field to another table for bothIn Compagnies table, I've a field where I list covered Region (linked value) and a field with Projects (linked values) - I want to run an automate that fills in the Projects value(s) based on a Region value(s).At the end example should be :Company A - cover regions 1, 2, 3 - project Alpha, BravoCompany B - cover regions 2, 4 - project Alpha, CharlieAutomation will :for a given company, find the list of region coveredrun a repeating

I an Airtable newbie. I work at a public library and use Airtable to manage and track our booklists. Since there are no sales or orders per se, we calculate usage using physical counts. Every few weeks I count them and record in Airtable the current qty of each booklist and the number added (if any) for each booklist. It's easy to determine all time usage: ([starting qty]+[number added])-[current qty]. But I am stuck on how to derive annual usage via formulas.There are two tables involved: Booklists and Inventory. Booklists uses rollup fields to grab numbers from Inventory. Inventory has fields both for qty added and for physical count.What I want I a view grouped by year, sub-grouped by booklist, showing annual usage. I can brute force it by adding a new field every year for the ending qty, but I'm hoping there's a more elegant way to do it via formulaThe formula would be something like this for each booklist: For a particular year, find the earliest record dat

Hello,I am trying to debug why a certain script I wrote for automations failed because it takes more than the allowed 30 seconds. It seems that Airtable JavaScript environment doesn't support parallel execution of asynchronous tasks. Is that correct ? What can I don if I want to perform this kind of code: await Promise.all([ updateRemoteDB(), updateRemoteDB() ])Thanks,Yaniv

PLEASE HELP  ME I need to a formula like this. =IF($G4<=200;5;EĞER($G4<=600;7;EĞER($G4<=1000;9))) How is write on air table thank you in advance 

Hi! I am hoping someone can help me. Currently, we have Everhour turned onto run on our task list in our Airtable Database. I would like the same button "start time" to exist on the corresponding Airtable interface, but I can't find any articles on that. Any help would be appreciated.  Thanks! Brianne 

I added a page designer extension where I dropped some checkbox and rating type fields.Previously there were displaying well and now they do not show. Text, single select and formula fields display normally.I have tried redesigning the page and dropping the field a second time, it does not work. Is there a known issue regarding checkbox and rating type fields on the page designer extension ?

Apologies in advance if this is elsewhere or common knowledge or the query is posted in the wrong location (Formulas). I did look all around to find a similar Q&A elsewhere (found some close but none exactly what I was looking for), so...TWO sample use case needs for the following:1) Gardening: calculating when to sow or transplant a crop indoors or outdoors in relation to estimated frost dates.2) Annual Events (film festivals, awards shows) that occur at about the same time every year.Q1: How can I have a date withOUT the year? (reworded: How can I set up ballpark seasonal dates to faciliate copying over every year?)A-ish? I know I can do three columns (month, day, year) - but then I can't set up an annual calendar subscription, right?Q2: Is there a way to do a formula to calculate X# of weeks before a key date (i.e.: to add or subtract from the earliest frost date in a column).?Thank you!

Hey there, I own/operate a wholesale industrial supply company and built and Airtable base that helps us track and manage all of our upcoming deliveries (ship to address; jobsite contact; sales order number; etc). As a part of our process, our team logs in Airtable when the sales order has been "picked" from inventory and is ready for shipment. I want to add a way for our team to log how many parcels are on the order (i.e. 1 pallet, 2 boxes) and think a button would be the best way to do that. The desired workflow would be Click Button --> Picking status moves to "Ready" --> form pops up that user inputs # of boxes, # of pallets, and # of bundles, then closes form. Once the form closes, that would then send a print session to our label maker that prints off the delivery information and includes the number of parcels it has (i.e. "1 of 3"). Does anybody have experience setting something like this up? The button to form component i

Hey all, I’m wondering if there is a way to perform element-wise multiplication of two arrays of numbers. For example, if I have two fields with arrays [1, 2, 3] and [4, 5, 6] respectively, can I write a formula that produces [4, 10, 18]? As an example use case, I could calculate a weighted average of an array of numbers [10, 20, 30] with weights [.2, .5, .3]. After element-wise multiplication, I could take the sum with SUM([2, 10, 9]) = 21 (In this example, I’m just taking the dot product of these two arrays).

Hello guys,I'm trying to create an automation that:When a new record is created -> Compare "E-mail" field with existing records -> If true, do something.The issue I'm facing is that: The automation is comparing the email to the contact being created instead contacts already created and always return "True" obviously.I'm I doing something wrong? Or is there any way other way to achieve this? Thanks in advanced

Until yesterday when I clicked on Interfaces in the base I got a screen with all my interface icons, both published and unpublished.  Suddenly that is gone and I get dropped into one of my interfaces with no ability to see my unpublished ones.  Anyone know what happened and how to access unpublished ones?  

Hi I have a question. I want to collect some data from this website, below. I would like to know if it has API capabilities and/or if I could do web scraping, either by Goggle Sheets IMPORTXLM or a written script for MacBook. I have a lot of new records, which requires postsge stamp data to be inputted and I would like to use Integromat to automatically integrate this into my Airtable base, with data from the website below: https://www.arpinphilately.com If anyone can help with my question, I would greatly appreciate it. Thank you Mary

Airtable states that the API request limit per second per base is 5 . So is that for a single IP or all IP's combined ? if somebody can explain in detail the api rate limit as of 2023 , it would be highly appreciated...

I have a problem using Automation to create a link between records in two tables.I have Table A and Table B.  Table A has a link field (’Link-A-B’) to Table B.  Table A also has a Form to create a new record in its table.  The form requires user to choose an entry into the Link-A-B field.  If the user selects a particular choice for the value, then the Form exposes another field in A (‘New Option’) that the user is required to type a value into.  Upon submission of the Form in this case—with a non-empty value in the’ New Option’ field—  an automation is triggered to create a new record in table B, and to enter the value of ‘New Option’ in A into the primary field in the new record in B. All the above I have working just fine in my Automation so far.  B

Hey guys, I'm currently stuck on how to formulate a profit based off the total value of the invoice. This is what I currently have:I have the formulas needed to determine the selling price of each product, however via my "Invoice" tab, I have this: Where I'm stuck at is, how to formulate the formula to determine the gross profit of each invoice in their respective columns.Any help is appreciated! 

I’m attempting to integrate Airtable OAuth into an application of mine but the Airtable endpoints to fetch access tokens keep giving an “invalid_grant” error. I’ve already looked at this post and haven’t been able to solve my problem with it: https://community.airtable.com/t5/development-apis/oauth2-problem-with-token-request/m-p/142198#M11746 Step one: The user clicks on a link and gets redirected to Airtable OAuth. Here’s how I generate the link:```const state = crypto.randomBytes(100).toString('base64url');&nbs

Hi, I have a list of people with different positions and locations. I would like to create groups of these records like: * All the people who work in Sales * All the people who are located in EuropeAnd I can give it different parameters and it will sort by the different groups. >> I don't want to create all the groups beforehand. Meaning, I don't want to give it a defined list in case there are job titles or cities that aren't in my list. << Can anyone suggest an automation tool to do this? 

I have one table "Companies" it is related to "Campaigns". When I send a Campaign to a Company I want to batch or else automatically link the Campaign to the company.I see that linked records are not part of the batch Update extension. Example:I create a view of Companies that's 100 records.I have a Campaign that's "Direct Mail Piece 1"I export that list and send mail to those companiesI want to show link these 100 Companies to the Direct Mail Piece 1 Campaign so I know which companies have received which marketing.How can I accomplish this?Thanks!

Here is just one more issue with the disgusting unusable new home page that Airtable is forcing us to use. Before there was a section "Bases Shared With Me" - that was logical, if someone shareswith me but just 1 base not the whole workspace, this base could be placed in any of the Workspaces' sections, so a separate section for them was created - and that was greatNow there is only the list of the shared workspaces and a messy heap of all bases. Now imagine that there are users like me, who have ~10 shared workspaces with ~100 shared bases, while some of them are shared on the workspace level and some are shared on the base levelThere is no way to show the bases that are not in one of the workspace, so if you don't remember the exact name of a base, all you can do is patiently look thru all 100 bases, looking for the one you need.There is not much hope that this will be noticed but at least I give you a chance: please hear your c

I'd like to be able to drag and drop from one multiple select field to another.  Help?

I have an automation that will email a specific person when a record enters a view. The view is looking for a status change. Once the status has been changed a field is populated with the user that changed the status. As part of my automation, I’d like the person who changed the status to be CC’d on the email that will be sent. How do I get the email of the AirTable user to auto-populate into an email field?

I need a field named START to gather data from other domains, including dates.Why is the game development date being removed?SWITCH("Stage," IF ("Stage"="READY FOR GAME DEVELOPMENT,"DATEADD("GAME DEVELOPMENT,"'', "DAYS,"If the stage is "READY FOR CREATIVE DESIGN," the date add is "READY FOR CREATIVE DESIGN," the date add is "READY FOR PRODUCTION," and the day is "DAYS."

Hello,  I am trying to use the WORKDAY function to add X amount of days to my start date, however it is populating an extra day but only if I include the time. I don't need to include the time but its the only way I can get the project "duration" to show up on the calendar or timeline view. Can anyone help please? I've tried to add -1 days to remove a day from the start day but it is telling me there is an error. Current Formula: WORKDAY({Start Date}, {# of Days}) Thank you, 

Hello Airtable builders,We have been heads down working on a tool that we think you will love building with.Today we are launching SQL as a better Airtable API.Previously, we launched our first sync between Airtable and your Postgres database right in this community. We’ve been floored by all the tools, applications, dashboards, and businesses the community has built on this sync.After working with thousands of Airtable teams, we heard a common suggestion: it would be amazing to write to Airtable through the database. Instantaneously creating, updating, and deleting records with nothing but SQL.So

I am trying to delete some records from a child table when the parent record is removed. To do so, I have created a view on the child table showing records where the parent link field is empty. On my automation, the trigger is set to be when a record enters that view, the automation fires.  The automation is firing but I get an unexpected permission related error I have not seen before. I am the workspace owner. I can manually delete rows in the UI. This seems simple....what am I doing wrong? I have other delete automations that are still working fine. Error: You are not permitted to perform this operation at main on line   Code is below let table = base.getTable("tablename")let