Ask the Community

TLDR: I'm not able to upgrade to a Business account, and when I go to my workspace, it says it does not belong to my company. I am the sole billable collaborator in that workspace, and I'm listed there as Owner.---I'm a consultant. A year ago, I set up an AirTable Workspace for one of my clients, adding them as a billable collaborator. I paid for their first year of use myself. When the new plan structure came along, I upgraded my own workspace (A) to Business, and the client workspace (B) became Teams level. This morning I wanted to switch from monthly to annual billing. This wasn't an option, so I tried downgrading temporarily to Teams to see if then when I upgraded again, the Annual billing option would be back.But it won't let me upgrade. When I go to my workspace, it says it's external: "This workspace does not belong to your company."Who does it belong to? My client has never had access to that base and shouldn't have been able to do anything with it, including change the ow

Hi, I need a script to detect duplicates in a list with many records (15k+), I need the records column to work as a flag and that by means of a text or a checkbox notify me if I am adding any mail that is already above. The idea would be a real time process as fast and efficient as possible, that when someone finishes copying the new mail it will notify me if it is already up there Thanks!

Is it possible to duplicate an interface into another base? It's a lot of work to re-create, and would like to avoid if possible. If not, is this a feature airtable is currently working on? 

Hello everyone,I've been racking my brain on this question for over a week and have tried countless attempts to solve this, but am still spinning my wheels. Basically I'm aggregating total work history of all our staff across all our events this year, so I need to calculate how many shifts someone has worked. The issue is that it's possible to have multiple records of the same worker per event because different supervisors may submit the same record with different ratings.In my example, here are all the reports (records) that we received on 1 worker for the year (Table 1):Here is the summary record (Table 2):In the summary record (Table 2), Total shifts should be "9" and successful shifts should be "6". The current formula in the ROLLUP SUM(ARRAYUNIQUE(values)) doesn't work because if any event has the same number of shifts as another, it'll get skipped. Because there's 2 records of DF23, I can't use SUM(values) on the "# SHIFTS" field either. I've been able to identify

Hi, I’m trying to fetch all my table records that has a 500 columns inside but in this json result view it only fetch a random of 100 records in my existing table. Here is my code. Thank you //base1 const MY_API_KEY = “API_KEY”; const AIRTABLE_BASE = “BASE_2”; //base 2 const results = await remoteFetchAsync(AIRTABLE_BASE+?api_key=${MY_API_KEY}) const data = await results.json() // for(let view of data.fields){ // console.log(view); // } console.log(data);

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