Ask the Community

I'm finally making great progress and haven't been frustrated enough to quit yet, so I think I'm going to be able to make this (along with fillout) to help support my makerspace.  I hope to eventually move from the free plan to Teams once I know I have all the major pieces in place.But once I do, and we're using it, I'm concerned that my future clugey attempts to add functionality might break operations.  Is there any concept of development, QA and production versions of a workspace?

I'm building a base to track volunteer sign-ups for a project. Table 1 stores Volunteer info Table 2 contains available Timeslots When a new volunteer signs up via a form on the Volunteer table, an automated email is sent confirming the timeslots they’re registered for.The issue: When I include a grid of timeslots (using a Find Records step in the automation), all of the times are showing in UTC. I need them to display in EST.Here’s what I’ve tried: I created a formula field to convert the time to EST using SET_TIMEZONE, and also tried A single-line text field that gets updated by a separate automation But when I try to include either of those fields in the grid, the grid shows the correct number of records, but all the cells are blank.Has anyone figured out a way to include times in the correct time zone (EST) inside a grid in an Airtable automation email? Would appreciate any tips!

I have two tables, Table 1 and Table 2, with different fields. When a specific record is populated in Table 2, I want the values of some of its fields to automatically appear in a corresponding record in Table 1where the cells were initially empty,  based on the primary fields of both tables, I’m calculating a total in Table 1 based on entries into records in several tables and need to have the total in Table1  automatically updated whenever the values change in the other tables. What is the best way to achieve this? IOW, what is the equivalent of XLOOKUP or Index Match in Airtable?

Hey AT community. I have downloaded Sales CRM template. This link shows that training is available, but I don’t know how to access training. Your help will be greatly appreciated. Thanks https://academy.airtable.com/quick-start-the-sales-crm-airtable-template 

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?