Ask the Community

Hi,Clicking on the email address opens Microsoft Outlook Live. How can I change the default settings to open Microsoft® Outlook for Mac?

Bonjour,j'ai crée une table mais le champ type "Nombre" est absent de la liste des champs disponibles.. Avez-vous une explication?

Hello Airtable community, not sure it is possible, but Gemini says it is)) but when Gemini gives me the sample script and I adjust it and try to use it, it does not work. Here is what I am trying to do. I have a record (contacts database) where I have a multiple select “Status” for this record. And I have another multiple select “Services” with let’s say “Option A”, “Option B”, “Option C” and “Option D”.When I choose the option “Available” in this multiple select “Status”, I want to the script or automation to limit the options shown in the field “Services”. For example when “Status” is choosen for “Available”, my field “Services” will only display “Option B” and Option D” as an available options to choose from.Anyone thinks you can help me with some advise?

I am trying to convert an existing solution to airtable, and see some great enhanced functionality. however, there are relationships in my existing system that I am not sure how to appropriately recreate in airtable. For instance, i have a join table that shows several different related tables through a relationship. some of the relationships are many-to-many, and would be created in the main join table. What’s the best way to recreate that in AirTable?Thanks in advance…jesse

Hi, I have a request to set up a “tag” so that users can @mention everyone in a dept. in one new comment.  I tried doing this with groups.  I created a group made up of 4 users who are all Editors in the base, and gave the group the name “TechGroup”.  I would like to add a comment on a record and ‘@TechGroup’ so each member is notified. So, far this doesn’t seem to work.  Is there another way to tag multiple people in one mention? Thanks!

Can someone help with the coding of a script that converts the contents of attached .TXT files to a long Text filed?We have an attachment field [TXT] that contains one text file per field. We wonder if it is possible to copy the contents of each text file to a long text filed?I have see some notes on it, but we need scripting help to achieve it.Thanks for any advice.Kevin

I’m getting the following error when I get or create the data from airtable in my next.js project.AirtableError {  error: 'NOT_AUTHORIZED',  message: 'You are not authorized to perform this operation',  statusCode: 403} I’m using airtable npm module for integration.I’ve added all required scopes already but not sure why I am getting that error.Can anyone help me for that? Thanks 

The Airtable OAuth specification says that authorization request responses will return the same code_challenge that was included in the original request.These docs also say that this value must be verified: The code_challenge parameter you passed in the authorization request. You must verify the code_challenge variable is associated with a code_verifier you generated.From what I understand of the PKCE flow, Airtable's backend (not the client integration) is responsible for validating the code_verifier included in the token creation request from the client. Why does the documentation call for the integration to check that authorization response returns the same code_challenge that included in the request?Also, the official Airtable example implementation does not perform this check: https://github.com/Airtable/oauth-example/blob/a714e68c2610e3249063b3d92faf064bf4c15188/index.js#L94-L137.Any ideas? TYIA!

Hi EveryoneI’m sure that this has been done before but I can’t seem to get anything I try to work Im looking to create a forula filoed that looks up and displays the PAYE Month a date in another field falls into for example 17/04/2024 would lookup and display PAYE Month 102/10/2024 would display PAYE month 620/08/2025 would display PAYE Month 5  I am dealing with the tax year in another field so I dont want to worry about the year below is the parameters I have tried if statements I have tried a switch example but cant get anything to work  I have tried setting a year start date and using dateAdd to add on the number days after the year start  but I just not getting anything to work right  If someone could point me in the right direction I would be really gratefullCheersJackieFrom Date   To Date   Days Between No. Days from start of tax year Should Display  6th april 5th May 29 29 PAYE MONTH 1 6th may 5th June 30 59 PAYE MONTH 2 6th june 5th

 Not sure what to title this.In a record detail interface page, there is the option to add a button and perform an action. (Yes, love it!) But it doesn’t seem like the option exists here to add a new record in a different base via a form—the dropdown on the right doesn’t seem to allow it. And unfortunately, “Interface Forms” for some reason still don’t count as “Interface Pages”, so I can’t click on “Go to interface page” and click on my form.The best current option seems to be “Go to external URL”, and put in the URL of the form. But that seems to only open my desired form inconsistently:open external URL in same tab = overwriting my current page, and there’s no way to complete that form, then hit a “back” button to get back to my record detail open external form URL in new tab = often it just doesn’t open.My ideal would be to click on the button, open another modal with the form, which I could complete, then close, and still have the record detail at-the-ready.Does that make sense? A

I need to create a test/quiz for my employees in order for them to be certified in a subject area.I'd like to create a form with 30 questions, each question with up to 4 multiple choice answers.  I have an answer key, indicating which of the answers is correctIs there a way for the employee to complete the form and submit and AT automatically compares the answers to the answer key and provides the number answers correct and the percentage of answers correct out of 100.

Hi know that creating a recipe with several ingredients and do the calculations So I was thinking to do the recipe vertically Is that working for me ? Please advise  Regards 

Hi! Does anyone have any recommendations on how to continuously import contacts from Mailchimp into Airtable without using a third party (i.e. Zapier)?

I’m currently a Pro user and I’m considering an upgrade to Enterprise. I’d like to know if the following workflow is possible with Enterprise. A billable collaborator creates a form for a Base in their Enterprise Workspace. The billable collaborator shares the form with a non-billable collaborator from their domain. The non-billable collaborator accesses the form, authenticating with SSO prior to seeing the actual form fields. The non-billable collaborator submits the filled form, and their user ID is passively submitted along with the other form values. (I suppose this ID would be the email address they used to authenticate with SSO.) A billable collaborator can see the new record (with the ID of the user who submitted it) in a grid view. Reasoning: I’d like many individuals from my organization to participate in data collection and entry but want to restrict administrative access to a small team. The number of potential participants is around 300, and I’d prefer not to have to p

Hi! I created a base and interface for a game I have been playing, Schedule 1. Yes, it is a game where you create drugs based on different combinations and then sell those drugs :P. I have included a public view of it below. I have it basically how I want it, but I need a way, anyway, toFrom the drugs table, have a view that pulls the Teir 1 drug from any drug that isn’t a T1 drug. And then display in each row, the T1 drug, the different mixed supplies, and the drug effects.The challange is, in the game, when you make the drugs, they randomize the names after mixing. So, what for me, mixing ‘Aspen Grool’ which is a T3 drug, might be called something different for another user. It would be rather daughting to dig through each drug combo and source it back to the T1 drug, so I was hoping there was a way to do it in a formula or view or something. Thoughts? https://airtable.com/appXdxs1ShjFgTxFE/shrbWwxkofvHeaHNr

Can anyone tell me how I would write a formula that will return the lowest date from a series of dates? this would be very simple in excel, but it seems impossible  

Hello,  I am currently trying to send an Airtable automation where it bulk emails people from a table. However, I am in the ‘To’ section to send an email, but I can’t find an option under ‘Current item from List of records’ that has just a general statement of ‘Applicant Email’. Currently, it’s showing a specific Applicant Email, but I want to send more than this person. This is also happening for the message when I am trying to include their names. I’ve attached one of the screenshots as a reference.  Can someone help me resolve this issue please? 

The problem: Our manufacturer will ship the contents of a Purchase Order as they are made and ship the remaining products when completed. We have had several occurrences of not knowing what’s coming and what is left until it arrives and we open the box. (We have a middle man, there is no direct comms with the supplier). My goal: Build an interface that the manufacturer can open, select the PO number, and input how much of each SKU is in the upcoming shipment, and put in the tracking number. Where I’m at: I have a Master Products Base with all of my SKUs in one table, and purchase orders in another table. I can add my skus from the products table into each PO, but I can’t assign each sku an order qty within the PO record.The other nuanced issue is that sometimes PO’s overlap and we will have the same SKUs on multiple POs. I want to be able to assign different order quantities to each SKU in a PO, and keep track of how many have been shipped from each PO. 

I’m a big fan of look-ups but I would really like to be able to remove records the occur more than one time. Is there a way to do that?

Hey All,I am trying to add a button to an interface which will simply duplicate the existing record the interface is looking at.  The Interface is a quote builder and we often want to make different iterations of a quote for a customer.  I know we can simply go to the grid view, find the record, right click and duplicate the record, but I am trying to not give my sales team access to that level of data.  You know how sales teams are.  😉 I imagine a script of some sort would work, but I'm more of a no-code guy, so I'm looking for some help.  Thank you for your time.

I have a list of names in the format John Smith MD or John Smith, MD (some with commas, some without) and I’d like them to be in the format Dr. Smith. Is there a formula that can do that for me?

I am new to Airtable and created my first form a few days ago using the new Form Builder interface. After the fact, I realized there was a field I hadn't included that I'd like to prefill. I read through all the various instructions on prefilling by altering the URL - all makes sense to me - but I can't figure or WHERE to do the URL edit in the Form Builder interface? I can copy the form URL to the clipboard, but WHERE to I put it where the alteration to the URL will be pulished and saved?Any guidance would be greatly appreciated. Thanks!

Hey AT community. I downloaded the “Sales CRM” template and created an account (a potential customer), but I am not able to see it in Interactions, so I cannot add any interactions. https://airtable.com/appIirQcIOaiJSq0w/tblpZMgRZq8MVJaGi/viwSC4OGJxNSvEex2?blocks=hide. The account I have added is SunRise, if you are able to see it in the link I have provided. Can you please help with this? Thanks. 

NPO TEAM ACCOUNT (just to let folks know)So I love having master sync tables and create views off them for different usages in a base.For example: I have a common base for State and Country, absolutely love this, and use it across a lot of our bases for different purposes.In our CRM we use it for Contact, Company, Communities, Speaker/Facilitator Bureau, Charity Compliance, and Grants tables.  There are some privacy requirements, and access controls that we have in place.I have set a VIEW -  States, just for lookup that does not show ANY other fields except the STATES field.So why if the view doesn’t show any of the other fields (where it is being used in the other tables) why does the individual record show. And then when I open it up - I see all the other areas I really don’t want some of my team messing with.Have I missed how to not show the other tables?Yes, I know I could make an interface but some of us like to work in a different manner, and bulky block interfaces are not our th

Hi guys, I'm trying to connect Airtable with Make. My Make.com module is returning "Status Code Error: 403" and I can't connect up my Airtable. I initially had it working and then created some new bases, so I generated a new Personal Access Token. Not working. Have tried different permissions. Logging out, logging in (I know). Etc.  Any suggestions?