Ask the Community

Happy Holidays everyone! I have a table that includes columns for both Start Date and End Date. Date format for both date fields is "Local". My gmail automation is setup so that when 'today' is 10 days from the End Date, the client will receive an automated email.This example, the End date is January 6, 2024 and the email automation triggered December 26th, which is 11 days from the End Date.How can I fix this so that it triggers when 'today' is 10 days from the End date? 

Hi!So I'm trying to set up a table for our home school group to house everyone's birthdays. I've scoured the forums and can't work out why I'm getting an error on all dates on or after 13/05/2019. All dates prior to this work fine and I just can't figure it out! I also wanted to see if I can incorporate a set_timezone formula to ensure it's based on my Australian timezone. Here's what I have set up:DOB field (members will enter their DOB via a form) and a formula field "Birthday (this year)" with the following formula: DATETIME_PARSE(DATETIME_FORMAT({DOB},"DD/MM")&"/"&YEAR(NOW())) Questions:1. I'm getting an ERROR for any DOBs that are from 13/05/2019 onwards. 2. Do I need to add a SET_TIMEZONE formula to set the timezone to Brisbane, Australia to ensure the 'NOW' portion of the above formula will be correct throughout the year? 3. If I wanted to add another field titled "Birthday (next year)" how would I add 1 year to the above formula? Thank

I hope this message finds you well. I am a graduate student working on a time-sensitive project that involves creating an app using Figma, Bravo Studio, and Airtable. I've successfully designed the interface in Figma, transferred it to Bravo Studio, and set up the API on Airtable. However, I am currently facing critical integration challenges and would greatly appreciate your insights and assistance.The main issues I'm encountering are:1. Get Request for Details: I've successfully implemented the get request for a list, but I'm struggling to make it work for details in Bravo Studio. When attempting to retrieve detailed information for a selected item, it consistently displays all items from the database rather than the specific details of the chosen one.2. Post Request: Despite ensuring the correctness of the bearer token, the post request consistently fails. This is a crucial aspect of the app's functionality, and I need a quick resolution as my deadline is approaching.I am reaching o

How can run the python script automatically if we update any record in the airtable.

I'm in the process of building a first app and suddenly I'm having a weird problem which is driving me nuts.In the past I was able to edit the record details page layout at will. Ie. resizing elements, reordering them to be side by side and adding text elements etc. Now for all the new record details pages I add (new and old interfaces), I can't seem to do that at all. Additionally in the side menu I have a text "This is a new record details layout experience." when it doesn't work. On the old record details pages no such text exists. Also the add element button is missing entirely on these problem pages so I can't eg. add any clarifying texts anywhere on the page. Did Airtable really kill that major bit of functionality or am I just doing something stupid? I can't find anywhere any info on what the heck this "new record details layout experience" is actually supposed to mean compared to old way.  

I have the following formula to set the entry for "Current Month": DATETIME_FORMAT({🟢 Start Time}, 'YYYY-MM') = DATETIME_FORMAT(NOW(), 'YYYY-MM') It seems to be working just fine, however the last entry from last month is setting the formula to 1.If I change the start time (right now) to 6:30pm or anything older, the formula gets set to 0. My first thought was a timezone issue, but I confirmed on the Start Time field that it is set to my timezone (CDT).Am I missing something obvious?

 HiI currently hold an account with make.com and I've been eager to set up some automation using Airtable. However, I've encountered a recurring issue where, upon utilizing make.com for various scenarios, I consistently encounter the error message "Waiting for server."Despite trying to replicate processes outlined in multiple YouTube videos—where others seem to achieve success through copy-pasting—I remain frustrated as I'm unable to progress beyond this roadblock. The lack of a proper response or guidance has left me feeling stuck, without a clear understanding of why this error is occurring or how to resolve it.I was wondering if anyone within the community has encountered or is familiar with this issue, as I'm convinced it's a significant hurdle that requires attention.Your prompt assistance or any insights would be immensely appreciated.Thank you for your time and consideration.Warm regards,Olivier 

HiI have a script which exports data from Airtable to Make.It exports 3 record columns in total.The trigger is a new created record.The output returns the same record every time, which is not even the newest, just a random out of the list.I'm quite clueless at the moment and appreciate any assistance in this matter. The script is attached: let apiKey = 'XXXXXX'; // Replace with your Airtable API keylet baseId = 'XXXXXX'; // Replace with your Airtable base IDlet tableName = 'Data'; // Replace with your table namelet integromatWebhookURL = 'https://hook.eu1.make.com/lltvxgqpxuvehximley444ibk3vcqkw9'; // Replace with your Integromat webhook URLlet table = base.getTable(tableName);let query = await table.selectRecordsAsync({fields: ['Quote Number', 'ID', 'Client Name'],sort: [{ field: 'Quote Number', direction: 'desc' }],});if (query.records.length > 0) {let record = query.records[0];console.log('Client Name:', record.getCellValue('Client Name'));let dataToSend = {'Quote Numbe

I have a date & time field.For example, below is the data. I will have a different date and time and 100 rows with data.1 Jan 2024 1:00 PMAt 1:00 PM on 1 Jan 2024, I want to send a Slack message using airtable automation.How can we make this trigger?My ideas: using formulas and views

Hi, I am new to Airtable. Just learning to use the calendar view. Instead of being able to view the contents of relevant records in the calendar, I can only see the numbers of relevant records in the calendar and I need to click each date to see the details of the records.How should I set up to view the details directly in the calendar?

Hi,I am trying to register my localhost rest API endpoint as a notification URL for the Airtable webhook. I am hitting a roadblock with the server sending the following response: [body] => {"error":{"type":"INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND","message":"Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct."}}[raw] => HTTP/1.1 403 ForbiddenNow my questions are:1) Can we register our localhost endpoint as a notification URL?2) I am using the pated below php code. Is it a problem with the code?$headers = array('Content-Type' => 'application/json','Authorization' => 'Bearer ' . $airtable_api_key,);$body = wp_json_encode(array('notificationUrl' => $webhook_url,'specification' => array('options' => array('filters' => array('dataTypes' => array( 'tableData' ),'recordChangeScope' => 'tblgR4tt66WVctY11',),),),));$response = wp_remot

Hi Airtable community! New user here,I am working with three tables in Airtable: 'Families,' 'Codes,' and 'Vases.' Each family in the 'Families' table can have multiple codes in the 'Codes' table, and each code in the codes table can have multiple vases in the third table. The objective is, for each new record, to automatically generate and assign unique codes for each family in the 'Codes' table and each code in the 'Vases' table. When assigning a new code, Airtable should automatically tell me the last code used for that family and assign the next one (for example if xxx-1 exists already, then assign xxx-2) The code format should include the family number followed by a numeric increasing value (e.g., 1, 2, 3). The count should reset for each family, ensuring that each family has its sequence of code numbers. The goal is to implement script in the Airtable Scripting Block that triggers whenever a new record is created on the codes and vases table, ensuring the proper assignment of the

Hello to all, I would like to be able to copy every day at a precise time the data contained in a column and paste it in another column. This is to compare the progress each day with the day before. Would you have an idea? I was going to use an automation but I can’t find the solution. Thanks a lot, A.

Hello Community,I'm currently working on an exciting project using Airtable and Softr and need some guidance to bring my vision to life. I appreciate any insights or advice you can offer!Project Overview: I am building a web page that is accessible only after users log in. This page is designed to be unique for each user's account.What I Want to Achieve:Personalized User Pages: Each user should see a page that is specifically tailored to them upon logging in.Card Views with Details: I intend to include card views on these pages. Each card should display:ImagesDescriptionsNamesOther relevant detailsDisplay of User-Submitted Applications: Users should also be able to view applications they have submitted.The Challenge: My main challenge is configuring the system so that users can only see information and cards that are specific to their account. I'm unsure how to set up this level of personalization and data filtering in Airtable and Softr.What are the best practices for setting up card

Hello,I'd like to create a Digital Planner like this one. It seems the Interface Designer lack of feature or may be I don't know how to do it.TopLeft component should be a Record Picker but it seems AirTable only allow Select Box UI not Calendar UI (month) ?Middle component should be Calendar UI (week). It can be  filter on current Record but the date can't be position to current record's date ... the visible range is 00h to 23h30 it can be narrow...Left CheckList can be done with List filter on current record but can't resize title, only add a prefix field.OK : Other fields, description, ... OK : Media field in CarouselAny suggestion to improve the UI ?Thanks ! 

Hi there!I am trying to create a formula that will pull the Last Modified date and combine it with my initials and my Pending Items column. The formula I'm using right now works, but the Last Modified date is pulling tomorrow's date. I'm assuming this has something to do with time zones because it doesn't switch the date until 6pm CST, but I'm not sure how to fix it! Please help 😊Table:Formula:CONCATENATE(DATETIME_FORMAT({Last Modified},'M/D/YY')," ","RE: ",{Pending Items}) 

Hello, Does anyone know how to format buttons in an interface record detail?For example, I would like to move the buttons around and have all 3 be the same size and display at the same time instead of having the weird drop down menu. Also I would like to reorder the position of the buttons.Thanks in advance for any suggestions!  

I'm working on my graduation project, using Airtable as an API. In the API documentation, specifically in the "create records" section, I'm having an issue. When I try to copy the 'YOUR_SECRET_API_TOKEN' for authentication, it stays as plain text and doesn't convert into the expected key format.Has anyone else run into this problem? Any ideas on how to fix it?Thanks for your help!

Thanks in advance for the help - unsure if this is an automation, lookup or sync question.I have two tables in my base that I need to somehow link.Table #1: Content calendar, where posts are to be planned and marked as "ready for approval" Table #2: Task Management, where ideally, once a post in the content calendar table is ready for approval, would automatically be populated into this table with the same info. I would ideally like to be able to switch the status to approved here too and it would be reflected in content calendar. I would also need to add tasks manually in this table that aren't related to posts. I've played around with automations and lookup fields but am at a loss for this one and may not be expert enough to fully understand lookups. Do I need both tables to have exact same columns? Thanks in advance!

Hi folks,I'm looking for ideas on base design(s) for chemical formulations. I've taken one stab at this where I hardcoded some columns, but that fell apart pretty fast. I'm hoping some Airtable creatives have ideas. Here's the general problem:An ingredient inventory has some number of ingredients A, B, C, D, E, F... etc and can have an arbitrarily large number of entriesA formulation has some number of ingredients (an arbitrary subset of the ingredient inventory, so maybe B, C, F as a random example) and a defined amount of each included ingredient (xB, xC, xF). That amount could be a fraction or a mass in most casesSimple case: how do I deal with a formulation having arbitrary composition of ingredients?More complex case: How do I deal with the above, but ingredient inventory can also include formulations (so it's getting recursive)?Any ideas are most appreciated!Regards,Scott

I've to create interfaces to access to our base, but users that logged in have to see only its own data (user is linked with each row in the database).So they can read, modify data linked with their accountHow can I do this in Airtable? or have I to use only the base and automation and develop interfaces via 3rd parties like Softr, Glide or others?Thanks  

I am trying to put a formula I pulled together in the primary field, but get the following error "Sorry, there was a problem saving this field. Can’t save field because it causes a circular reference".  Back story, I am using one tab to house all the event details. I am using the nesting feature to pull through things I need for all the sperate views (agenda, session intake, speaker details, ect.), where I would usually use separate tabs for each of these things. Here is the formula that I have pulled together. Depending on what Is selected in the Content Track field it will pull a particular reference field. I want to use this formula in the primary field, but even if I remove the "for column 1" field I still get the circular reference error.  Any one have any suggestions?     <--- THIS IS MY FORMULA    Here is a snapshot of some of the fields. [ Pink highlight I want to pull the formula I created and that works

I've gone through all the new plans and understand that when our plan renews (we are on Annual Pro Starter Pack currently) we will be changed to the Team plan.But I am still uncertain as to the pricing - we currently pay $348 annually for up to 5 seats.  I have read that the discount remains that we were getting on the Pro Plan - but what does that mean actually. We currently have 2 users.Has anyone been moved from Pro Starter Pack - annual to the new team plan annual. Can you tell me what the renewal price was? Thanks! -The only post I could find I think was for someone who was moved off the starter pack before renewal and lost the discount. 

HiMy card has expired and I need to go to a physical mailbox to replace the card, but that will take me a few days. An attempt was made by airtable to charge the card, but it has failed. How long do I have until my account is affected?

I’m working on an app to keep records for a children’s club. We try to get their birthdays, but sometimes they don’t know the year they were born. Is there a way to enter only the month and day? Ultimately I want to use the date to calculate the age, but I can have a check box to test if the date isn’t complete. Alternately, maybe I can use the age if we know it to calculate the year. I would like ideas for the best way to handle this. Thank you.