Ask the Community

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!

Hi, I need help. I have an automation that is triggered at a scheduled time and the action finds records based on a view of my grid. The grid is displaying all of the correct fields. Yesterday this automation stopped showing fields that are multiple select but show all other fields. I retested the trigger and action without any errors, and I hid and unhid these multiple select fields and turned the automation off and on. Not sure what else to do to get the multiple select fields to display on the automation as they used to. 

how can i export my data from airtable in json format ?

I've been trying to do this in way too many ways. I haven't figured it out ChatGPT and Bard haven't figured it out so I though I would ask actual people 😁I'm making an api call to usaspending.gov and am able to to get the information I want returned, but I can't figure out how to use the data I'm pulling down to create multiple records based on the objects returned. Has anyone run into this and how did you do it?let uei = 'PLACE-UEI';let startDate = '2023-10-01';let endDate = '2023-12-31';let data = {"filters": {"time_period": [{"start_date": startDate,"end_date": endDate}],"award_type_codes": ["A","B","C","D"],"recipient_search_text": [uei]},"fields": ["Award ID","Recipient Name","Start Date","End Date","Award Amount","Total Outlays","Description","def_codes","COVID-19 Obligations","COVID-19 Outlays","Infrastructure Obligations","Infrastructure Outlays","Awarding Agency","Awarding Sub Agency","Contract Award Type","recipient_id","prime_award_recipient_id"],"page": 1,"limi

Is anyone else frustrated with Airtable's lack of full base download and limited storage space for a respective paid tier?Major issues that need to be corrected:I upgraded from Free to Plus but got no warning that this tier would still leave me with storage over limit.No way to directly reach sales to switch from Plus to Pro tier for first year promo offer that I saw before upgrading.No way to do a full base download.No way to download actual attachments as part of a CSV export.No way to get a quick overview of attachments by file size to find the top resource hogs and delete them.I get that any service wants to lock you into their service and features but this feels overly manipulative.  Anyone have any luck with getting any sort of timely response from their sales and/or support?

Hey guys, Is 2GB files the most I can upload, or that’s just the maximum amount of files that can be stored in one base? If I delete that record/file, will I free my space, or that’s just the maximum I can upload, no matter if I delete files or not. Thanks

Hey ATeam, My base is synced with an online app to schedule and send content to whatsapp groups. the app that i work with has a limit of 2MB per upload file. so Im limited and looking for an option to compress attachments based on their file size which the general rule is that the file could not exceed 2MB. Ill be happy to get any thoughts or ideas on how to resolve that, an be able to compress files that are larger that 2MB. using automations, scripts or extension or any other Idea that you might have. Thanks 🙂 

Hello,Yesterday Automation Script Block had some errors and it failed for multiple automations.Inside the Script Execution log, This error is shown for both of them.There was an unexpected error while executing your script.Just confirm that anyone else has that same issues.@isaiahmiller97  also mention before day.  AUTOMATIONS UNRELIABILITY - Airtable Community  

Can I set-up AirTable to use the German number format which uses comma (,) for decimal place and dot(.) for thousand separator ? I mostly hace to create reports which require german formatting. It’s a real pain to download in excel and reformat it. Thanks