Ask the Community

I've created a task list. When 'Done" is clicked, the "Date Completed" is updated and the "Next Due" is updated based on a formula dependent on the 'Freq'. All this works fine.I then have an automation that runs to create a new record with a 'Due' date populated with the previous records 'Next Due'The automation runs fine except in the evenings where it adds a day? During the day it is fine. You an see in the attached, "IG New Messages" was clicked 'Done" on 1/10, 'Date Completed' was 1/10, 'Next Due' was 1/11 but then the automation changed the new records 'Due' to 1/12It is like there is a time zone issue somewhere but I can't figure it out so any help is greatly appreciated.

Hi guys,As of now, I use both filtering views and conditions on records as automation triggers. But in your opinion, is there some best practice to follow on that topic? I assume there must be some pros and cons to both options. I’d be curious get the take from experts out there.Thanks for your help.

I am looking to make a reviews website, like a business directory with reviews. Is something like this possible in airtable for each listing?

When I click in the field to link a record, a panel pops up showing all the records from the other table that I can search through. It also previews some relevant fields for each record on the little card. How does AirTable choose which fields are shown here? As you can see in my attached image, there are 4 fields being previewed. I would like to show a different field called “Category”, instead of the “Framecount” field.

Noob here. Frankly don't know where to start, and my mind is whirling with the results in the community, so let me describe what I'm going for.I've created a form that allows my community to report data in four areas for a health challenge: calories consumed, exercise calories, water consumption, and sleep hours. There's also the date and the person's name in the table.What I want my community to see is a summary of each of the four areas for the current month. I'll embed the view on a web page. Rollups, aggregations, linked records — I'm starting from square one in using Airtable and haven't figured out which and how to make this work. 'Lil help? Thanks!

Hello, On an airtable registration form that has a required field for DOB, some users have made error on their years of birth (for example 2023 instead of 2003) . Then they submit it and it fills the table with wrong data without them being aware of it. Is there a way that I can set the minimum date of birth to 01/01/2007 for example, so that the forms can alert the user that the date is incorrect at the time of form submission ? If not, which other way is possible ?

I wonder if anyone's done anything similar?We get customer feedback on designs and it's usually in the form of a spreadsheet emailed over, with feedback points per row so I'm creating a customer facing form for them to fill in so it's captured in Airtable as a task.Our 'Task' structure is a Tasks table, and a separate one for 'Subtasks' that are linked records.   Does anyone know if there'd be an easy way to allow the customer to create subtasks from the Feedback form before submitting? Currently if I pull in the Subtask field to the form, it allows them to select from the existing list of subtasks, but not create a new one.   Obviously the constraint is the 'Task' isn't yet created.Any ideas? &#x1f605Ross

Hi! New-ish to AirTable and very much appreciate your help and patience!I am trying to create a timeline or calendar view that displays all of our acting clients' working dates for every single film/TV project that our clients are/will be working on. For instance, I need a way to quickly view and edit the statement, "Charlie Chaplin is working on the film MODERN TIMES in NYC on 1/15-1/27, then 2/2, 2/7, 2/9, and again on 2/23-2/28." Additionally, I need to quickly display a client's working dates on a particular project to answer the question, "When is Charlie Chaplin available in Q1 and not filming MODERN TIMES?"  The problem is that I do not love the idea of creating several different start and end date fields for individual days (ex: 2/2, 2/7, 2/9) and short date ranges (ex: 2/23 -2/28). It does not seem like I can just select all the the dates a client works on from the existing date field(s), it only allows me to create a range (start date an

Context: I am a trader and I have a base that tracks trades that I take. I can take many trades on one day. I am attempting to create daily reports for myself, and have created an automation to add trade to my daily report. However, whenever I add a new trade (record created) and the automation runs, it deletes any other trades previously added to that day. Anyone know what I should look at to fix?

I have a table with records with two fields, 'Start Time', and 'End Time'. Both of these are date fields, and need to remain date fields, i.e. they can't become formula fields.The issue is that if 'Start Time' is changed, e.g. I change the day, the 'End Time' field does not update. Is there are way to ensure that the 'End Time' field shifts relative to the 'Start Time' field? Importantly, I don't want this to happen in reverse, e.g. the 'Start Time' field should remain where it is when the 'End Time' field is changed.Hope that all makes sense,Andy

I've been using airtable to handle the backend of an MVP. The tables and  interfaces have been a great way to quickly put together a product that our internal team can work with. Probubly would have been beter to go with a tool like Retool for our use case, but this is were we are.We are still having trouble with the speed of airtable's API for our consumer facing front end. The other issue we've had is that there is no real dev ops workflow where we have a development environment and production environment. The best way to do that is to just copy the base and relink everything so we have a dev base and production base. The issue with that is its time consuming and all the Id's change so links we give the clients in emails etc that have id's as url parameters won't work anymore.We are looking to migrate to a traditional tech stack and would like to sync our airtable base to a postgreSQL base as we do the hard work of putting together a proper backend in react for

Is there anyway to hide certain tables from certain collaborators? I’m using Airtable for my business and want to link financials to projects. I have employees who I want to update records on my projects but not have access to financial information or client information. Is there anyway to do that? If not, I cannot continue using Airtable in my business…

Really excited about the new permissions for the interfaces :raised_hands: Now maybe I am just not seeing the option, but is there any way to add a simple password protect for viewing the interface? Like we have for sharing specific views? Thanks!

I have a table with all our fiscal weeks, and their corresponding start and end dates.  ("Fiscal Weeks")I have another table with projects, and the start date of each project. ("Projects")I need to add a column to the Projects table that tells me which fiscal week the project belongs to, based on the start date of the project. Nothing I've tried seems to work. Any thoughts?

Over the course of a project we will be conducting a series of feedback surveys, each with the same questions, but after different events. I plan on storing responses to each survey in its own table within a base. Is there a way to duplicate the form to different tables? I will need to do some minor updates (e.g., changing the introductory text), but the questions would be the same.

Hi everyone,I love the Airtable interfaces and am interested in using the new dashboard interface layout (as opposed to using the legacy charts on a blank layout, which is what I currently do).However, one very critical element of the dashboard interface layout is missing: I am not able to locate any way for a user to filter the data by a custom date range. Sure, I can use pre-set filters for general date ranges (this year, this month, any other range I choose as the person building the dashboard) but the purpose of seeing our data on a dashboard is to be able to answer questions like "what does the data look like between January 1st and January 4th?" The user needs to be able to filter the data based on the date ranges that are important to them. They should not have to ask the team member in charge of the interface builder to add a tab filter for every single range they want to review and compare all

I am fairly new to airtable and have gone back and forth on whether this is an automation or a formula. I would like to create a field where when two conditions are met, it auto numbers. For example, when records have the same "created date" and "account name" this field would auto-number. If there are no records with matching "created date" and "account name" then it would auto-number to 1.   

Hello,I have created a check Request form in my system.  For some of our transactions we will deal with multiple transactions but I only want to have one button.  I have created multiple fields (Fee #1, Fee #2, Fee #3, Fee #4, Fee #5). I am trying to create a nested if Statement (or open to other options) to fill the check Request field with the newest fee.  For example If Fee 5 is empty but Fee 4 is not then I want Fee 4 populated in the field.  If Fee 5, 4, and 3 are empty then I want Fee 2 to populate in the field.  And so on.  Appreciate any direction. So far I created a nested if Statement but it only works for the first field then no longer works.

Hey Community!!Not a real actual current use case, but thought I'd spice-up the community a bit to kick-off the year! I can think of different workarounds for the following edge case, all of which could theoretically work (although not ideal) however I'd love to get to know your thoughts for it as the same logic and issue applies for other use cases.E.g. think of music concert tickets with initial stock of two (2) tickets.If Buyer A, Buyer B, and Buyer C all open the form at the same time (or before any submission occurs), they will all see availability of 2 tickets.Even if Buyer A purchases 1 ticket, available tickets shown on Buyer B and Buyer C's screen will still show 2 (unless they refresh the form and therefore retrieve new updated data from Airtable).This will not be an issue if Buyer B purchases 1 ticket immediately after -as there is still one ticket left.However, by the time Buyer C wants to make the purchase, the form still

Greetings, Airtable community!I wanted to reach out to ask for your ideas and assistance with a road block I ran into:I have a Fillout "SignUp" Form that allows clients to schedule themselves for an appointment at the specific appointment time they choose. I've successfully customized Fillout form to show ONLY "unfilled" appointments (based on an Airtable view) when the client loads the form.The problem is that if 3 people load the form at the same time, then they can all 3 "Sign Up" for the exact same appointment. Since they all loaded the form at the same time they have the same options given from Airtable. And since the form doesn't update in "real time" unless they refresh the page, then there's no way to keep them from all 3 selecting the same Appointment time.On the back end, this means I received 3 SignUps for the same appointment and a "Something Went Wrong..." email from Airtable. I then need

Hello,I have a table that is synced with transactions from my bank account, but I need help with extracting data from a JSON string stored in the Notes (Long text) field.An example of the JSON looks like this: { "transactionId": "2022142460021", "endToEndId": "\/VS2501000545\/SS\/KS308", "bookingDate": "2025-01-10", "valueDate": "2025-01-10", "transactionAmount": { "amount": "-390.00", "currency": "EUR" }, "currencyExchange": [ { "exchangeRate": "1.00000000", "quotationDate": "2025-01-10" } ], "creditorAccount": { "iban": "SK9111110000002303283006" }, "debtorName": "COMPANY s.r.o.", "debtorAccount": { "iban": "SK8511000000002622224000", "currency": "EUR" }, "remittanceInformationUnstructured": "Platba faktury 2501000995", "remittanceInformationStructured": "[{\\"reference\\": \\"2501000995\\", \\"referenceType\\": \\"VariableSymbol\\"}, {\\"reference\\": \\"308\\", \\"referenceType\\": \\"ConstantSymbol\\"}]", "additionalInformation": "Plat

I am starting to think this isn’t an option in Airtable, but am hoping someone out there knows how to do this. I found one other support question on it and no response. I have a table showing the grants given out to grad students. Each grant gets a unique entry identified by the grad student recipient’s name. Some grad students get these more than once in separate semesters. I have a view sorted by group (the recipient’s name) and can see the number each student received, but there is not a count for the number of groups. Is there a way to count this other than manually or am I SOL? I tried to think of a way to run a formula or something else to do this, but cannot seem to figure it out.

We're annotating and marking up alot of images on a daily basis for manufacturing (arrows, dotted lines and text). This was typically done in Excel docs and then the excel doc would get exported as pdf and sent to manufacturers.We've now tried to move all this onto Airtable. We're using documint to export the documents from airtbale and illustrator to annotate the images.However our team that deals with marking up the images is about to "lose the will to live" as they say it takes too long to first download the images to their harddrive. Then open the image in illustrator, then make the annotations. Save them as jpg and then upload into Airtable. And if anything needs to be ammended they'll have to the whole thing over again (as it's fairly technical the annotations often has to be reviewed and amended by a technical team). Our problem is we can't annotate directly in Airtable as we need to use marked up images layed out in printed docume

I have a project table and a client table. I need to use automations to have the client related information auto populate into the projects table. I have created a very basic example to show what I am trying to do but the real situation is way more complex with hundreds of rows and we are unable to use the linked field type to do this without a huge amount of effort. Since the client name is a common and unique value between both tables my understanding is there is a way to use automation to populate the information in the project table with the corresponding information (Notes and Status) from the Client table. The Trigger and Find Records action do as I expect but I keep getting an error with the Update record action and am unsure of what to do to fix this issue.   

Hello everybody,I would like to add the date and topic in the body of the message that will go to the email, reminding the person to do the work for the day DD/MM/YYYY.