Solved

Hello:New to Airtable and new to the forum here...Looking for a solution to combine records in my field {Component], for every change in records in my fields {Location ID} and {Room}.  For example, in the attached image I would want to combine WF218, W361824, RF9624 3/4, W3330, and so on to B18, in a new field.  This is to correspond with {Location ID} 1-3-302 and with {Room} A Acc Kitchen.  For the next combined field, the result would be ADA SB30, for location 1-3-302 and room A Acc Bathroom.  I would like to accomplish with a formula, but I understand I may need to create a new linked table.  I am attaching 2 views; one is grouped and one is a straight view, for clarity.  Thanks so much!!  

Hi, Table A, B, and C. Table B fields are linked with Table A and Table C. I'm trying to run automation. Whenever a new record is added, I will filter the records from Table A and Table C based on the condition. Then I need to create a record in Table B by linking the data from Table A and Table C. Now I can filter the records from Table A and Table C using the Find Records action. but not able to run a nested repeating loop. I can do only one repeating loop.

I have Budget table which has cost field, variable cost, and month field (Jan to Dec). Cost field has some default amount. Variable cost field is editable which user should give some value(amount).Case 1:Cost | Variable | Jan | Feb | Mar | Apr | ......... | Dec | $60                     $5     $5    $5     $5               $5     Case 2:Cost | Variable | Jan | Feb | Mar | Apr | ......... | Dec | $60      $120      $10    $10  $10   $10             $10     if the client's budget amount is more than the standard cost. in that case, the user will provide the original amount in the Variable field to split the amount into 12 months. but if the client wants to close the monthly payment early by paying more each month. For exam

Hello everyone,I need help with automation in Airtable. I have two tables: "Needle Tasks - General" and "Needle Tasks - Antonov". The goal is to update records in the "Needle Tasks - General" table based on changes made in the "Needle Tasks - Antonov" table.Here's how the automation is set up:Trigger:- When record updated- Table: Needle Tasks - Antonov- Fields: All fieldsActions:1. Find Records:- Table: Needle Tasks - General- Conditions: Where "General - ID + Project" contains "Antonov Tasks ID + Project"- It finds a record in the "Needle Tasks - General" table and returns Airtable record ID recvhvhDDXVsYTmCc2. Update Record:- Table: Needle Tasks - General- Record ID: Use data from the previous action (Find Records)- Fields: Data is taken from the trigger in Dynamic ModeThe problem arises when executing the second action (Update Record). I receive the error "Received invalid inputs."Details of the error for the second action:- Table: Needle Tasks - General- Record ID: recvhvhDDXVsYTmC

Hello! I found the "Splitting text to alternate columns separated by ;" thread and was hopeful that it was exactly what I needed, but after trying to implement this formula I am not getting the expected outcome. I'm not sure if it has to do with the format of my data including a mix of hyphens and underscores or if there is something else I'm missing.I have anywhere between 1 to 5 lines of text that I need to break out into their own columns instead of being combined. Ideally I would have five new formula columns that allow me to break these out based on them being separated by "\n" or if that it not possible, I can also add a ";" at the end of each line to simplify the formula if it helps!Example Data:abc_def-gh_ij-x-kl_mno-pqu-first-msg-x-240101abc_def-gh_ij-x-kl_mno-pqu-second-msg-x-240102abc_def-gh_ij-x-kl_mno-pqu-third-msg-x-240103abc_def-gh_ij-x-kl_mno-pqu-fourth-msg-x-240104abc_def-gh_ij-x-kl_mno-pqu-fifth-msg-x-240105A sincere thank you in advance to anyone who takes the t

Help me solve this projectits a law firm they have a table with list of questions and a table with list of defendant in airtable they are linked togetherthey want to be selecting a defendant eg caroline then select the questions this defendant is supposed to answer to send out this information we need to create a document with questions and they should be numbered in order

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