Ask the Community

On the iPhone I have a table where each record represents a calendar event (gigs for my musical duo).  It used to be that I could an individual record, go to the Date field, and click Create Event and Airtable would create a calendar event in my iPhone's Calendar.  Now, clicking Create Event does nothing.  Is this a known problem?  Will it be fixed?  Is there a workaround?  Thanks for any help.Carl

Hi ,I am creating an airtable automation for recurring task for weekly, daily, monthly, 3 times per week and twice a month  In the next to perform date i used this formula DATEADD({Due Date},SWITCH(Frequency,'DAILY',1,'WEEKLY',7,'MONTHLY',30,'TWICE A MONTH',15,'3 TIMES PER WEEK',3),'days') It works perfectly well for daily, weekly and monthly, twice a month but it doesn't work for  3 times per week i need (Monday, Thursday and Sunday)can you please help me with the formula?

Hello Airtable Friends!I really need some help with my automation.I created an automation for when a record is updated for our team. Basically what I did is when an assignee is changed to another assignee, that new assignee would get an Outlook email saying that the record was reassigned to them.When I go to test it, I get an alert from Airtable saying something went wrong with the automation but it doesn't show me what the exact issue is. I am wondering if its Outlook but I am not sure.Can someone help me out? 

Hi,Ive created a project management workflow where we have a project board that filters into a task board, and tasks are assigned to individuals who check a "complete" box when done. We have a dashboard for each individual where their tasks appear. Because the tasks need to be completed in a certain order (ie "edits" need to happen before "production") and we have different people executing on different parts of the project, it can be hard to know when its your turn with the project. The project manager typically assigns all the tasks out at once so all tasks associated with the project appear on the individuals dashboard simultaneously. Ideally we would only want the project to appear on the persons dash if it was their turn with the project. The tasks are already numbered for order so hypothetically it would be easy to automate one following another. Im wondering if theres a way to set automation so the tasks only appear if the previous tasks have already been completed, so the proje

This is my first post to the Airtable community.  I have searched through lots of posts about linking records and tables, but I can't seem to find an answer to this...I have two imported tables that have a StudentID field in each.  When I edit the StudentID field in one Table to change the field type to "link to another record", Airtable deletes all the StudentIDs in the table I am working in.  I am attempting to create a linkage between these tables because I want to know if a student in Table 1 is also in Table 2 (and the student may be in Table 2 multiple times, however I just want to know if the student is in the table...I don't care how many times).   Can someone help me figure out what I am missing?  Many thanks, in advance, for your assistance with this issue!My apologies if this problem has already been solved elsewhere, I just couldn't find it.

Hello All,I have a general question for the community.How are you all managing code updates and version control for your custom scripts?It seems very easy to overwrite custom automation scripts.Does Airtable have a way to view/restore a previous version?I am currently storing some of my automations scripts in GitHub Gists but I don't have a great workflow for keeping everything up to date.What processes have worked for you?Thanks!Matt

Hi all, I use an airtable formula to calculate product prices. I want to use Zapier to automate the process of updating prices on my website when changes are made to prices.As I understand, Zapier wants to use the a "Last Modified Time" field as the reference to know when to trigger the action. The problem I'm having is that I'm not finding a way to point the "Last Modified Time" field at the calculated price field because AFAIK that field cannot monitor computed fields. The airtable documentation recommends pointing the "Last Modified Time" field at one of the editable fields used in the computed fields. This doesn't resolve my issue because Zapier seems to want to pull the value from the field being watched by the "Last Modified Time" field, not the computed field that I need it to. After consulting the airtable documentation I'm starting to be convinced that the workflow I have in mind is not possible (I would be happy to be wrong about that). So I'm wondering if anyone ha

Hi everyone!I am currently working with two tables (let's refer to them as A and B), wherein table B is synced to table A.My objective is to deduplicate table A, but before doing so, I need to merge the information that is not synced in table B to prevent any data loss (essentially deduping without the deletion part).Is there a method to achieve this?I was contemplating using a script to handle the merge process, but I'm unsure if there's a way to identify whether a field in table B is synced or not.Any insights or suggestions would be greatly appreciated!Thank you in advance.

Tracking nurse staff schedules with doctors.Column 1 lists nurse staffs, column 2 the doctor engaged with that staff, column 3 = # of patientsFor example, column 1 may have the following fields:A1 = Betty, Joel, CindyA2 = Suzanne, Betty, MikeA3 = Cindy, Beatrice, RosariaB1 = Dr RodriguezB2 = Dr BlakeB3 = Dr BakerThe goal is to be able to add up patients between a single nurse w doctor combination, i.e. Betty with Dr Rodrigueza normal CONCATENATE of A1 and B1 will say Betty, Joel, Cindy with Dr Rodriguezanyway to be able to recognize all 3 combinations?I have a junction table with a CONCATENATE of Betty with Dr Rodriguez but I don't know how to then go grab and sum the # of patients anytime where Betty is true in column A and Dr Rodriguez is true in column B.

Hi,I am trying to write a formula to write the wider region that the project is related to, e.g. if it's in Germany, it's in EMEA. This formula works; however, I now want it to be able to list multiple regions for projects that are taking place in two different countries that aren't in the same region.e.g. a project that is in Germany and in Canada should show 'EMEA, CAN'. Currently it just shows 'EMEA', not both. Please could someone suggest how to change this formula to print all that apply? (Tagging @Databaser who helped with my previous question in case they can help, "Complex Nested IF AND statement (dates and regions)")Thanks,  IF( REGEX_MATCH({Division}, "UK|ROI|France|Spain|Italy|Greece|Poland|Germany|Portugal|Belgium|Netherlands|Denmark"), "EMEA", IF( REGEX_MATCH({Division}, "Thailand|Indonesia|Malaysia"), "SEA", IF( REGEX_MATCH({Division}, "New Zealand|Australia"), "AUS/NZ", IF( REGEX_MATCH({Division}, "USA"), "NAM", IF( REGEX_MATCH

Hi, I am trying to call openAI's API for an Assistant I build, but constantly get this redirect error:  O: Error: Response status was 307 'Temporary Redirect' but redirect mode was set to 'error' at queryAssistant on line 11 at processAndUpdateRecords on line 51 at async main on line 60  The code is as follows(line 11 is: let response = await remoteFetchAsync('https://api.openai.com/v1/assistants/asst_My_ID/messages', {51: const aiResponse = await queryAssistant(domain);60: await processAndUpdateRecords();)  // Define the API key and modellet apiKey = 'API_Key'; // Replace with your actual API keylet model = 'gpt-4-1106-preview'; // Replace with your chosen model // Function to query the Assistant AIasync function queryAssistant(domain) {let response = await remoteFetchAsync('https://api.openai.com/v1/assistants/asst_My_ID/messages', {method: 'POST',headers: {'Authorization': `Bearer ${apiKey}`,'OpenAI-Beta': 'assistants=v1','C

HELLO COMMUNITY !CAN SOMEONE HELP ME WITH A REQUEST?I paid for an annual plan in the Business category on November 29, 2023, in the period that covered November 2023 and November 2024 and was surprised with the downgrade of my plan to free and a charge of 500 dollars of which I am unaware of the origin. because I did the payment of a editor for my base, payed a annual plan, and the airtable team block my base asking for a 2nd paying to another editor, but I had only 1 EDITOR in my base!The airtable team downlograde my plan to free, this situation is exposing my business to very serious exposure and causing me enormous losses. [AND A QUESTION, HOW THE FREE PLAN CAN HAVE 5 EDITORS? YOU PAY FOR USE THE PLAN BUSINESS, AND HAVE ONLY 1 EDITOR? ITS DONT MAKE SENSE !]

I am currently facing an issue while trying to release an extension created in Airtable using the "Block Release" command. I have encountered the following error: The block could not be found. Make sure your API key is correct and that you have access to the block.Code: airtableApiBlockNotFoundI have verified that the blockId and baseId in the remote.json file are correct. Despite this, I am unable to proceed with the release. I believe I have the necessary access permissions, and my Access Token is accurate.Here are the details of my configuration:

Good day Airtable Community,I would like to ask for your assistance if there is a ruling that can be created to move records that do not have "Extracted for Ticketing" value all the way down?  Thanks

Hello! I am looking for some help with correcting this script (I had Copilot AI help write it) for Airtable. I'd like for the  automation to tick a checkbox "Fully Live" in the table "App Status" when a button is pushed in a specific interface.I'll attached screenshots of the script error, the table we'd like to have updated and the script itself. Any help would be greatly appreciated!I am not married to having to use the button in the interface to initiate the automation. I have another table called Monthly RTLs where the button could be added. When I add a button field there, it wants me to add it to a Dashboard and I got confused - that's why the script references that table. This is the script error.  This is the interface associated to the Monthly RTLs Table. The field "Fully Live" lives in this table here called App Status. This is where all data for a record is held. My department primarily works off of this view and updates the

Hi guys, Is there a way to sync Airtable and Google sheets? I want both apps to update automatically when data is updated/create new from either end. Any insight is appreciated. Thank you in advance. 

 Why change the plans to then hamstring what is already in existence? With the plan changes, the 'pro' plan that we were paying for has now been downgraded significantly. It's really annoying to be using the 'top' plan and for that plan to be degraded, and we lose functionality on our bases. They are forcing us to immediately upgrade or we can't do our work. Can't add new records. Why HALF the storage from those plans? That seems wild to me. Keep them the same at the very least. We can now get more storage, for three times the price. Or, you can keep the former 'pro' plan and only get 10gb. In what world does that make sense? There are no tiers to this setup, it's either all or nothing. And what grinds my gears more is there isn't a transition period for those who have been on the pro plan to figure this out. It's just, 'changes made, so deal with it and pay us more to use AT.' Is there a way to soften the blow for those of us who have been using pro? Or offer

Hello,Is it possible to create a tag to autofill a specific table column if a response from a form is received?I want to have pre-created tags to fill the column "Jobs" as seen in the attached image, depending on the jobs form that the candidates fill.Something like;When a form "Product Director is submitted".... Add a tag " Product Director" in the job column

Hello, I'm new to airtable but absolutely love the potential! I've set up a Social Media Marketing Calendar that my VA and I have access to for writing, scheduling, and planning Instagram/Facebook content. The trouble I'm having is within the same base, I'd like to have a master Calendar for all of my marketing channels. I want a calendar for my email list, a calendar for my planned blogs, and a calendar for my Youtube Content. With all of these calendars I want a Master Calendar for all of my marketing efforts that pulls in all of the sources into one calendar so I can make sure it syncs has a cohesive message. I don't want to gunk up the Social Media Calendar with my other platforms because it could get overwhelming with my VA who only works on Instagram/Facebook. I'm sure it's user error because I'm new to this, but can anyone give me guidance on how to pull information from each of my calendars (Blogs, Emails, Social Media) into one master calendar that I can color c

I'm looking for an alternative to MS Access which will allow our employees to enter data through forms, with basic features like lookup tables and direct access to an AWS hosted PostgreSQL instance.Does Airtable do that? It seems like Airtable needs to ingest all data into its own 'base', but I'm really not looking to do that.If not, I'd appreciate any suggestions for data entry software.

Hi,I have an Interface I have created for one of my bases (simple summary page) - but I wonder:- Is it possible to access this Interface (and its summary data) via the AirTable API? It doesn't seem so, but maybe it is somehow?- Is it possible to embed this Interface within another site of mine via an iframe or something similar?thanks for any suggestions!@ed_p_may 

I am having a hard time with an automation for updated record. Right now my Assignee field allows for multiple collaborators on our team to share records. Sometimes a record will need to change from the original assignee and be reassigned to another collaborator(assignee). What I need is for Outlook to send an email to the person that the record has been reassigned to. I keep trying to address it but keep getting notified by Airtable that the automation didn't work (Failed to construct the value for "To").The “assignee field” is called Agent Lead Owner. Outlook® is already integrated.I have attached an image for reference. Hopefully someone understands what I am trying to achieve here and can help me out.Thanks,Lena

Hello,We have a built a complex database for a processing facility, over the past 10 months. As of today, we have about 35 automations running (at various frequencies) and the main base will soon reach 100k entities out of 125k.Until Friday, there haven't been any slowdowns or any load issues. There are 3-4 automations that are running once every few minutes especially during 9am - 6pm. We have a steady 10k entities/month increase rate. And no development has happened since Friday.On Saturday it was reported that the platform started to slow down and entities generated through automations are starting to take minutes to appear.This morning, the automations runs are no longer taking <1 minute to finalize, we are looking at over 30 minutes runs. The queue of runs is chaotic, runs that started later are completed sooner that previous runs and the entire base is full of errors because of this.The company is facing serious penalties due to high processing times.The support email we

Hi, I have a list of tasks I want to set a weekly automation for. .(Weekly, daily, monthly, 3 times per week , twice a month)

I am looking to find any way to automate and control the license levels that exist for our users in Airtable.  Currently, a builder in Airtable can promote users to builders, and collaborators.  This obviously can cause licensing headaches, and administrative headaches.Has anyone found a way to control or run audits via any type of automation to get a handle on licensing changes?  I understand this might be the opposite of what Airtable wants, which is to keep free and open collaboration, but that's not reasonable for businesses trying to control costs.Thanks in advance!