Ask the Community

Our Airtable base collects information about our program. Two of the tables track people and the programs that people are registered for. For more unchanging information--like name, email, or date of birth--we have fields on the people table. However, for information that can change from year to year--like city, job title, or phone number-- we collect it on the program registration table. In the past, we set up our base so the most recent records for a given person in the program registration table would update lookup fields in the people table, so the people table would display the most recent city, job title, phone number, etc. This system has worked well for us, but we are running into an issue where if the most recent record in the program registration table contains blank fields that correspond with people table lookups, then those people table lookup fields will also be blank. We would like to figure out a solution where the most recent pieces of information are still being

Hey there,I've been trying to achieve the following for a few hours now, but without any luck.STEP 1: I track the time I spend on a certain activity (# session in minutes column in screenshot)STEP2:  I also sum up the time I spent across all sessions (# sum minutes column in screenshot)Question: Right now I have to do step 2 manually. As you can see in the screenshot, I manually add the last session's number of minutes to the existing sum of minutes. I oftentimes forget, and / or make errors.How can I do STEP2 automatically? I just want a column in which the last sessions' number of minutes gets automatically added to the existing total sum of minutes. Do you have ANY idea on how to do this? Seems kind of simple and I'd know how to to this in excel but I can't seem to get this to work in Airtable.Thanks! 

let response = await fetch('https://api.airtable.com/v0/appN7ENhTnqtPUMSf/tblGBdGqVSDBBIxUE&view=Orders%20in%20Seven%20Days', {headers: {'Authorization': 'Bearer token'}}); Hi Everyone, can someone take a took at this for me, I got a 403 error when I try to list records of a specific view , I quite sure I am having the right authorization, because If I remove '&view=Orders%20in%20Seven%20Days' from the url, I get a list of orders. Thanks in advance!

Hi alli'm struggling with an automation and i have done my fare share of research before i decided to create this post. i have a table to track multiple account if the bank matches the books.  Here are my fields: Account, Date last matched, Status My goal is that when the date of the last matched is TODAY the status should be UP-TO-DATEIf the date of last matched is YESTERDAY the status should be UP TO YESTERDAYand so on, see attached screenshot.I have tried different automations but i couldn't find something that would work.Here are some of the stuff that i tried.     

Every day, a pizza shop offers a different specialty slice pie of the day, which I have listed on Airtables. The chat bot platform I'm using now is bad at telling time, so when someone starts using the chatbot, I would like to make an API call to my base to see(1) what time it is and if the pizza shop is open; (2) if the pizza shop is serving slices [which serves between 11:30 a.m. and 2:00 p.m.]; and(3) What specialty slice pie of the day they're serving?I'm a newbie, but I don't mind doing research. If you can just give me a general direction, I would greatly appreciate it. thank you

Hello!I'm quite new to airtable and have been unsuccessfully trying to solve this for a while now. I'd like to assign a tags to a record based on keywords in a long text field. For simplification. Let's assum guests at a wedding text me their food options as a text field. Then I want a script or formular to find keywords in the text field. If it matches a keyword it should then assign a tag. In the image below: I want to assign the tag "omnivore" if either keyword (meat, fish, chicken) appears in the column "Dinner requests". The other keywords respectively.In my case, I only need to assign one tag, not many. We can disregard the possibility that a guest wants vegan and meat option.This is my keyword mapping table. In total, I have a fixed list of around 20 tags with 3-4 keywords each.Thanks for your help!

Hello everyone,I'm trying to extract the first Date&Time from an array from a lookup field that looks like this:2023-06-02 11:00, 2023-06-07 11:30, 2023-06-12 11:45, 2023-06-23 11:00, (etc)But using this formula: ARRAYSLICE({Lookup field}, 1, 1) Gives this result: 2023-06-02T09:00:00.000Z which doesn't get recognized as a Date&Time, so I can't format it.  Is there maybe something I'm doing wrong? Thanks in advance for any advice

Hello,I have a formula in Airtable which should output "SMS" if certain conditions are met.This formula has worked for a long time and has not been changed. Now I have noticed that something has been changed in the formula function and Airtable indicates that the formula is incorrect. I can save, but I can't find the error that Airtable is referring to. What am I doing wrong in the formula?  IF( AND( OR( {Terminart} = "Hauptuntersuchung (HU)", {Terminart} = "Sicherheitsprüfung (SP)" ), OR( AND( MONTH(TODAY()) = MONTH({Datum nächste Prüfung fällig}), YEAR(TODAY()) = YEAR({Datum nächste Prüfung fällig}) ), {Datum nächste Prüfung fällig} < TODAY() ), WEEKDAY(TODAY()) = 1 ), "SMS" )   Please correct the following errors in the formula: Missing opening parenthesis "(". at line 3 column 9 Missing opening parenthesis

Hi all!I'm trying to build an automation that's very similar to something like the automations found in platforms like Asana, Monday.com, etc. but I'm getting errors and can't figure out why. I'm sure it's very simple, but I need help!I'd like to set something up where if someone changes the status of a single dropdown from ANY record in a table, that it will update the status of another single dropdown from that same record.EXAMPLE: We're creating a content calendar for our social clients. If we have records for POST A, POST B, and POST C, I want it so if someone changes a single dropdown labeled "Copy Workflow" to "Copy Approved" that in POST A, that it updates the status of another single dropdown in POST A labeled "Copy Status" to "Approved" automatically.While I fully understand that I can create an automation dedication to POST A, there's going to be a LOT of different records (or posts in our case) being made constantly. I can't be making new automations every single time a reco

Ok so this is a weird one, about three days ago, I paid to upgrade to teams on my airtable account. I have a $0 balance invoice and the money was charged to the card.  Today, I've logged in and my account still appears as a free user? I don't understand why this is happening and am wondering if anyone else has experienced this issue? 

Hey All!I need some help! I'm relatively new to Airtable and currently diving into setting up an inventory/project management system for my team. Our approach involves utilizing Airtable as a combined solution for both project and inventory management.Here's a quick rundown: We've established a "project-specific" base to monitor products that need to be ordered, received, and delivered for each project each product has up to 750 items to keep track of. Simultaneously, we maintain an inventory base to keep track of surplus inventory and items that have been received for a project. For instance, if we need 3 units of product A for a project but have 2 in surplus, we only order 1 for that project.Now, I'm facing a challenge. We want to mark products as received in the project base and have our inventory base automatically update when we receive products. Essentially, if we order 1 unit of product A, I'd like to mark it as received in the project base and have our inventory base reflect th

I am using a form with some prefilled fields. It works great as long as the item name doesn't include certain special characters. For instance, if it includes an "&" anything after the "&" won't be prefilled. So "Mop & Broom Holder" prefills as just "Mop". Some of the product names we have are a bit long, so it can be a pain to have to type everything out. I know why this is happening, but I'm wondering if there is a way to include the "&" in a url and have it be part of the prefilled information. This is the formula I am using in the button that leads to the form.Form URL'&'?prefill_Name='&Item&'&prefill_Quantity='&{Received Qty}&'&prefill_Project+Tag='&{Project Tag}&'&prefill_Date+of+Update='&TODAY()This is the URL that I get from that formula using the "Mop & Broom Holder" and an example...prefill_Name=Mop+&+Broom+Holder=&prefill_Quantity=4&prefill_Project+Tag=ATN&prefill_Date+of+Update=2024-01-25T0

Is there a formula to have a checkbox automatically checked if the current date is later than a specific date field in that record?  We want to be able to sort by "eligible" records and have it automatically updated as each goes past its "eligible date."  Thanks!

Hello,Is there a way to have two-way cross-references between entries in the same table?For example, there is a table [Companies]. Each entry, a company, can have clients and suppliers. If a company has clients, it means that those clients have at least one supplier - the company. I'd love to be able to connect entries so that when I assign clients, those entries automatically get updated with supplier info—and vice versa.Another example is Investors/Funds and Portfolio companies. I want to be able to add portfolio companies to a Fund and automatically have this Fund added as an investor to all its portfolio companies.Such two-way cross-reference works fine if I have several tables, for example, [Investors] and [Companies]. Airtable shows all the investors associated with a company and all the portfolio companies associated with an investor.However, I am looking for a solution to keep all the companies (portfolio companies, investment funds, clients, suppliers, etc) in the same table.&

Can anyone please help me solve this issue? Before 1/1/2024 I have to calculate a 2.99% fee and after is different 2.29%. I am trying a formula but only giving the result after 31/12/2023, before the result is blank: IF(    {Date Booked},    IF(        IS_AFTER(                {Date Booked},                DATETIME_PARSE(                    '31/12/2023',                    'DD/MM/YYYY'                    )      

Hello - I'm trying to figure out how to set a price based on 2 other columns. One column is Product Type (Socks) and the other would be Variant (single or 3-pack). So for example if Product Type is Socks and Variant is Single, the Price should be $3; if the variant is 3-pack, the price would be $8.Both Product Type and Variant are single select values, and I could potentially make the Price a single field as well. I also thought of combining Product Type and Variant into one column (Socs - Single, Socks - 3-pack, etc) and do Link Records instead, but I would like to eventually sort by Product Type alone (all socks, for example). Does anyone have any experience in this for inventory tracking? Thanks!

I am currently working with the Webhooks notifications (https://airtable.com/developers/web/api/webhooks-overview) to process record updates when a set of files/fields have changed. While I love the power and flexibility of the notification, especially the `fromSources` filtering and metadata, I have hit a few roadbumps in my implementations and I'm wondering if I am missing any obvious solutions that others have discovered.- Cursor value. Initially I thought I could possibly track the cursor value, but then I realized that this is likely just the cursor from the start of the payload list, so after 7 days of payloads, the max cursor value from the payloads will be less than my locally saved cursor, so this doesn't seem viable.- `baseTransactionNumber`. Since AirTable states that "each payload includes a transaction number, which is scoped to that webhook and sequentially increases", we can use this number to ensure we don't process multiple payloads more than once. However, we are not

Bonjourje souhaite partager un formulaire a deux prestataire externe le premier va remplir le formulairele deuxième va consulter ces informations remplit et mettre juste valider ou nonavez vous une idée comment faire cela ? 

Hello, As the image uploaded in Airtable returns the URL of the image, I want to convert the contents of the URL(image) to base64, btoa() converts the URL to base64 but not the content of the URL (Actual Image), I want the uploaded Image in base64 format. Is there anyway to do this inside automation script? Thank you

Hi all,Airtable Table Newbie, but feel in love.I want to group rows by partial text in the field.(CDPA) Campaign 1(CDPA) Campaign 2(CDPA) Campaign 3I want to group all three above using the (CDPA).I assume it would create a formula row to do this, but I do not know how to create the formulaCan someone help?Thanks,Judd 

Afternoon,I've had 2 ideas recently whilst building a lot of automations. Please do say if they already exist and I've missed them.When creating an, "Update record" action, please auto-fill the "Record ID" with Trigger item's record id if it's from the same table as you're updating.1. Every time I'm building an automation, if I'm updating a record on the same table as the trigger, the Record ID, is the trigger item's Record ID. Could AT autofill that Record ID token? Or maybe, a quick function link underneath the input box, "Use trigger record's Record ID" which fills the box when pressed.2. Is there a shortcut key to access the dynamic variables in a field, please? Often I'm filling in a Field in the automation type some words, but have to move to my mouse to press the plus button and access the data key explorer.Instead, maybe like how an "@mention" works, could we write an "@" (or similar) in the field box, and it auto shows the "choose data" box with the search field in focus.

How to add SMTP inside AirTable as there is a checkbox Send Email?

Hi all, What do you find the easiest to connect (and scale) Airtable to when it comes to reporting/dashboards, Power BI or Tableau? I realise there are no connectors for either through Zapier but have seen some workarounds for both tools. Any thoughts or suggestions? Regards, Tom.

How to filter and set condition IF EMPTY?

I’m currently working on a fairly large base and I was wondering if there is any way I can link it to Tableau, reason being I would like to visualise the data while I’m cleaning/enhancing it. I know I can download a csv - but I’m wondering if there is any way I can link directly or automate this so when I add a new record or alter data I can see the impact in Tableau.