Solved

Hi, I created a form where people can choose if they want 1 or 2 tickets. I have 40 tickets only available. I have no idea how to setup the form and the table so the form close when the 40 are reached.... Any ideas ?  Thank you !

I know this should be easy, but I'm new to Airtable and apparently missing something obvious.I want to let users add a new contact to my base.I have a People table and a Companies table.  They are joined with a multi-to-multi Roles table [Person, Company, Job Title].I've built a form to accept a new People record, but:1) How do I detect if a matching record already exists.  If it does, I don't want to create a duplicate2) I want the form to also ask for the new contact's company and create a new Role. But, I can't ask for Company in a form on People, If, instead, I put the form on Role, then I can't create a new Person or Company; I can only accept existing ones.My assumption is that I'm trying to force the system to act in a way it doesn't want. And, that's fine. I'm new to Airtable and 100% comfortable restructuring my base to work in a natural way.So, my broader question is: how do I setup a base so I can link to companies (where multiple people can work in one company and

I know about the various training resources for Airtable. I am wondering what more advanced users may suggest as far as approaching how to apply the tool to particular problems. We are an HOA management group and are moving away from Town Square in order to build our own internal workflow system. Member data, project submissions, complaints, gate access requests, etc. How does one ‘visualize’ a scenario in which AirTable can address these disparate parts to our system? 

Hello,I am trying to make the process of time tracking more user-friendly. Instead of using the duration field and writing manually each time record, I would like to use two single select fields as StartTime and EndTime pickers, each containing values 00:00, 00:15, 00:30, 15:30, 15:45, 16:00, etc.But I am stuck with a formula that makes a magic difference between these two times.Is it even possible with a formula, or does it need to be done with some sort of script?Thank you 

My CEO opened up her account settings and is only able to change her password. The setup two-factor authentication setting is not displayed on her end.

I manage a very large grant program (100+ active grant recipients ongoing), and we're doing most of our data tracking in Airtable.  We want to add a customer/grantee portal, and I have seen various Airtable add-ons mentioned. (We do not want to add each grantee as an Airtable user.)Our main need in this portal is something that can handle/track communications between our team and grantees. We need something that threads or lists all the communications that went to that particular grantee, regardless of which team member sent the message.  ie: Sometimes one team member starts a conversation, then others pick up and continue the conversation. This needs to be clear and easy to follow (no massive "original message" bits tacked onto the bottom of every reply like happens when clients using ZenDesk hit "reply" in email.) It would also need some sort of notification when the grantee sends us a message. Has anyone had direct experience with any of the portal-creation add-ons to

I work with a team and we have a field that we write notes in it (I don't like the comments section), the field type in Long text. It is very easy to accidentally delete contact from it. I want to defend it from this by demanding the user to manual saving the changes in the field, i mean like without auto save, that a user will have to hit Save button in order to modify the content. Is it possible? and if so, is there any built-in tool that i can do it with or we will need code / other external tool. By the way i know that we can Undo actions with Ctrl+Z but the problem is that we are not always notice that we've accedantlly deleting something. 

Good afternoon everyone! I’m trying to create custom currency conversions for a project I’m involved with. We’re traveling around the world selling concert tickets at the door of the venues, and each country has a different currency. I want to be able to take the ticket price for each country’s currency and convert to USD which will then be displayed on that record. I’ve seen this script is available to convert currencies, but I don’t know how to make the currency type dynamic as it only seems to show a single currency in the example. How can I edit line 7, where is says “GBP” to take the currency abbreviation from a field that exists within the record (ex, EUR,NZD,AUS). Any help is appreciated!!

I am receiving this notice when attempting to upgrade: "We were unable to upgrade you at this time. Please refresh the page and try again. If you continue experiencing problems, please contact us."I would think a financial ticket would be considered important. 

I would like my base's users to be able to create interfaces so that they can work with the data exactly how they need, however I do not want to grant them creator privileges. I also do not want them to be able to share interfaces (or event better if possible, share only within our organization). Is this possible?

I am trying to set up an OAuth for Make, as API keys are no longer available to use, and it says not to give Personal Access Tokens to third party companies.I do not understand what the 'OAuth redirect URL' is supposed to be, at the moment I have tried the web address for Airtable https://www.airtable.com/, https://airtable.com/oauth2/v1/authorize, the web address for my Airtable base, but no luck. I'm not sure if this is the issue?I have used the same name and have copy and pasted the client ID (deleted from the screenshot for privacy).The error message I am getting is: This third-party app failed to properly construct a request to Airtable: invalid client_id or mismatched redirect_uriPlease can someone help?I have used API keys before and never had an issue, but I feel completely out of my depth with the OAuth and would prefer to use a token, but don't want to share my personal token with a 3rd party if Airtable advise against it, as it is for a company and I want to keep data s

Hi,I would like a new field that tells me if a date has passed on an old field, called due date.So I would like the new field to say 'Yes' if the date has passed, 'No' if the date has not yet passed, and blank if no date provided.Going around in circles with this one so any help would be appreciated. Thank you!

 STATUS  (multi select)RETOUCHING STARTS (date)RETOUCHING FINISHES (date)IN RETOUCHING  DONE  What formula or automation can I use so that when I change "STATUS" to "IN RETOUCHING" a date is populated in "RETOUCHING STARTS" and when i change the "STATUS" to "DONE" a date is populated in "RETOUCHING FINISHES?"I can not use the last modified because I want the date to remain the same when I change the "STATUS" to "DONE."

Hello everyone! I'm a new member in the airtable community and wanted help on my airtable problems. I currently have a base table that receives emails, the problem currently is that it saves the whole email chain instead of just the email itself. I wanted to ask if there's a way (scripting/formula) to automatically remove  lines of texts after the word "From:" for every new entry that comes in.  Thank you!  

Hi guys,i have an automation and want to copy that to another base.It's a base that will be created from a snapshot that was taken (if this is important).Thanks 4 help!Julian

Does Airtable support sandbox instances? So for example if I need to develop and test before moving those changes to production, is there a way to do that? What Airtable capabilities allow this? If not, what have people used as a workaround? 

A few months ago I received an email from product@mail.airtable.com descibing changes to handling of dates and timezones in scripting. Do I recall correctly? Can someone point me to the info it described? I’m still doing manual timezone adjustments in scripts but think this new feature can handle it properly???

Hi,Somehow Airtable doesn't understand my dates as dates so grouping goes wrong. In an interface I have a list of booked events that I want to be grouped by their date. That way, I can easily see day by day how many events are booked. The grouping column is based on a formula picking out only the date from another column where the full date/time is stored.As a European I prefer 'DD.MM.YYYY' as the format, so my formula to give only the date is:DATETIME_FORMAT({date/time},'DD.MM.YYYY')This gives me visually 27.5.2024 for May 27, 2024, which is what I want. The grouping result, however, becomes like this:02.06.202414.06.202422.05.202428.5.202431.5.2024Grouping is apparently performed on the first digits, not as dates.Why doesn't Airtable understand a date that is only formatted into DD.MM.YYYY as a date?Rgds,Björn

Working with birthdays where I only know the client's Month/Day and not their Year of birth.  So text field is 5/12 for example but I'd like to have an actual date of 5/12 so I can set up reminders 5 days before the actual birthday.  I used the following formula but it's not working correctly.  DATETIME_PARSE(Birthday, 'MM/DD')Thank you in advance

So let's say I have a table that is going to have different numbers in rows listed in a single column, like below.2331618And in another table, I have some ranges filled into two columns, with a min column and max column, and a third column with a name, like so below.0-10 Sally 11-20 Joe21-30 Bob31-40 JaneNow how do I have the first table use the second table to evaluate a number to determine which range it fits into so that it can show me the name in the first table?23 Bob31 Jane6 Sally18 JoeI'm OK with formulas prior to this need, but now I am totally lost. I don't know if I am supposed to use rollups, lookups, linked tables or what. I've never linked tables before and I need a guru to translate my need into something that gives me a clue on what to try. 1st time here on this forum.It's like I want to say "see which range my number fits into and display the name for me".My actual real-life problem is of a larger scale where I have close to a hundred ranges, not four like I have i

Does anyone know of documentation that has an example of creating each field type using Node.js?There are certain field types I am running into issues with such as date fields and currency fields and I can not find much documentation of when an example for each field completed looks like.

Interface designer is nice but on mobile it’s quite pointless and I hope I’m mmissing something. Wouldn’t want to use a 3rd party for building interfaces. the list views show a random number of fields see sceenshot below. How can this be fixed? Also, to add a record - you need to ba an editor. So bad 😞 I have loads of people only doing that. Submitting records. Now I must make a workaround - because through a form it works  

Hi,I have a series of lookup fields that return multiple dates.  I'd like to combine those fields into one, listing all of the dates returned in M/D/YYYY.  I've messed with datetime_parse and format with a concatenate, but the formatting is either not M/D/YYYY or it only returns the first date listed in a series in the lookup field.Thanks for any help!

I have an Excel formula I'd like to replicate in Airtable.This formula converts different currencies into GBP.Excel:=IF(M2+(N2/1.25)+(O2/1.2)+(P2/8.75)=0,"",M2+(N2/1.25)+(O2/1.2)+(P2/8.75))Key:£ GBP$ USD€ EUR¥ CNYM2N2O2P2How would I go about it? 

Hi there,I have this automation I have built and it looks right to me and passes the test. The test data populates in the destination table. But when I manually enter data into the source table nothing happens.Here is the automation: This is the destination table. The Article Number "F25NSECVR" was populated when I ran the test.This is the source table. I manually entered "F25TEST" and nothing happened.