Ask the Community

I have a complicated string of formulas that is setting due dates. The short of it is I have a "complete" column (checkmark) and "Date completed" (static field). A task is completed and marked with a checkmark in complete where it stays visible all day, then at 11PM, today's date is added to "date complete" which filters it out.  The date complete is the base for a series of formulas in another table which basically determine when to reopen the task as being due again. I've been struggling to figure out why my formulas aren't behaving as expected and I think it comes down to timezone. The most granular failure I can find is a plain formula for "today" - that is the whole formula just "today()" ... the automation pulls the data from that column to drop into date completed and "today" is wrong. I've tried manually setting all date fields to CST, I've tried leaving them all as the standard GMT, I've tried "use same time zone" in formatting an

Hi Everybody,I have an Airtable table already populated.There's a field called <<Status>> set as a formula that takes either the value <<OK>> or <<Not OK>>I want to set an automation that calculates the number of rows with the field Status = <<OK>> for each day.Ideally, I want the results to be shown like this  DATE                                                        Number of OKs15/01/2024                                              3216/01/2024                                              28....

Hi, I'm looking for a way to create an interface that hold a list of records, that will display a required record only when looked for. kind of reverse filtering.for example:I have a list of of possible types of documents available to the customer.I want the list to be empty, but when he fills a filter with a certain value (for example:invoice), the record called "invoice" will appear.Any Suggestions?Nitai 

We have SKU's that are bundles and comprise of a combination of other SKU's.So an SKU can be sold individually and also be sold in a bundle.Example -SKU-1 is a bundle comprising of SKU-2 X 1 unit, SKU-3 x 1 unit and SKU-4 x 2 units.We will be pushing sales data into Airtable that will give us monthly sales by skuWe would like to see sales data of all SKUS by accounting for the components in each bundle.Sample base here.Products Table lists all products. Any SKU which is a bundle is marked as a bundleSales Table shows the sales for each SKU by monthBundle table shows all components of each Bundle and the quantity of each component in the bundle.(Multiple bundles can have the same SKU)So SKU-2 should show it's individual sales as a product (31 in June) + it's sales as a component of SKU-1 (12 in June)In the s

Hello, I have a primary field that is a number field that contains sequential invoice numbers. I would like to know if that number field can be converted to an autonumber field that starts at and continues the sequential numbers. It seems silly to have to keep track of the sequence when a computer can do it.Thanks, Scott 

Hello. I am encountering a small problem with a Make.com scenario Goal: Scrape info from an API and update a table inside of Air Table API is running smoothly, all data is being pulled. Currently, the scinerio is only running and creating 20 records total inside of air table. I have a paid subscription and am running into this problem It should run continuously. Anyone have any info about this? 

I have a collaborator that I successfully down graded to read only. They have left the organization and I want to remove them. I am also planning on going from free to team and I do not want to pay for this person. I believe they are a workspace collaborator.  How do I remove them to not have any access to my Airtable workspaces and bases and not get billed for them after upgrading? Thanks, Scott

Is anyone seeing their automation freeze after a trigger?

In the interface section, when I create a form page, is it possible to retrieve the id of the new entry created by the form?At the moment, I have the impression that the only one I can display is a free text like "Congrats, your answer has been sent" or something similar.Thank you for your reply.Julien

Hello everyone,I'm currently working on an automation project where I'm facing a challenge with embedding images into a Google Slides presentation. I am using Make to lift the images from airtable and replace the placeholders in Google Slides template. I am able to pull in all the text information but have hit a roadblock with the image embedding part.Here is the issue:* I have a Google Slides presentation with placeholders for images.* My Integromat scenario successfully retrieves image URLs from an Airtable base.* The URLs are accessible and lead to a download option for a `.png` image when opened in a browser.* However, these images are not being uploaded or embedded into the Google Slides presentation.Sharing a screenshot of my Make scenario.This is the template

Dear Airtable community,I'm working on an automated email sendout where I would like to let the recipient know which order and delivery dates will be applicable within a holiday week. To make it as easy as possible for the reader, I basically joined one big text field based on the data input, for example "order will be placed on 28-12-2023 for 02-01-2024". Now, I'm looking for a way to aggregate my output - kind of like a pivot before showing all fields. Data format:CityRecipientTextBerlinBerlin1order will be placed on 28-12-2023 for 02-01-2024Berlin

Hi all, I love the AT community and can often find solutions within articles but can't seem to find anything that helps solve my current situation:I have a multiple-user assignee column and often people from lots of different teams get pulled into one task. We also have a multi-select team column showing which teams are directly involved with the task. I currently have automations set up to add the relevant team into the team column when any of the team members are added to the assignee field. But as conditional automations only run until one condition is satisfied and then stop without making updates for any other satisfied conditions, I have had to create a new automation for each team, to ensure it updates for every assignee. I am currently trying to write a script to combine all of these automations; I have coded the part to input the table and source (assignee) and destination (team) fields, but am stuck as to how to define each team and the relevant team mem

Is there a way to get notified of a new comment on a record? Either through the API or within Airtable itself?

 My automation exceeded the run limit 2500 in just a few hours because I don't know how to control it! Can someone help me?  

Hello So we have database with pictures and wanted to know if its possible to have Logos like in picture attached to database and if possible how?

I have a table that records all of my business leads.I have another table that functions as a report, to provide a summary of all those leads, how much they cost, when they were generated, so on and so forth.These tables are linkedCreated Date column & Created Month column is automated to fill in this linking field when a record is created in the business leads table, to populate the reportHere's the problem, the business looks at weekly data from Fridays to Thursdays. How can I automate the data so that we can look at the report in the week range that is specific to our business?Currently, what I can think of is to create a formula field, {Week Range}The formula would look something like this:  DATETIME_FORMAT( IF(DATETIME_FORMAT(TODAY(), 'dddd') = 'Monday', DATEADD(TODAY(), -3, 'days'), IF(DATETIME_FORMAT(TODAY(), 'dddd') = 'Tuesday', DATEADD(TODAY(), -4, 'days'), IF(D

Hi,I am new to Airtable, so finding my way...We are developing a simple CRM in Airtable which will include contact information for individuals. We intend this to be the single repository of contact details for our small team of <10 people.We would like the basic contact details (name, company, email, phone) to be synced out (one way) from Airtable to each team member's Microsoft 365 account so the contact details are available in Outlook and also then on their iPhone etc.I've tried setting something up with Make.com, but (a) it seems quite cumbersome for what I imagine is a very common desire for anyone building a CRM; and (b) it seems hard to make it work across multiple users, as it relies on creating an entire Make.com workflow for each user, which is not really practical.Am I missing anything?!Thanks,James

Hi folks,Can anyone help my failing Friday brain out please? I have a lookup field pulling through a maximum of 3 payment dates from a payments table. I need to break those dates down across 3 columns; earliest date, middle date and latest date. I have a MIN and MAX in place displaying the earliest and latest values, it's the middle date value I cannot figure out. I don't suppose anyone can solve this with a formula can they? I'm hoping to keep the workarounds to a minimum if possible.Much virtual thanks in advance!

In a lookup field of a record linked to many records, I have a large string of dates. They are in no particular order.e.g:2024-01-09 4:30pm, 2024-01-04 7:00pm, 2024-01-08 2:30pm, 2024-02-09 11:00am, 2024-01-12 6:00pm, 2024-01-12 1:30pm, 2024-01-09 12:30pm, 2024-01-15 5:30pm, 2024-01-12 12:00pm, 2024-01-10 12:00pm, 2024-01-16 5:30pm, 2024-01-18 12:00pmHow would I use a formula to refer to a separate date field(date only, no time), and create a new string with only dates from the large string that match the specified date?e.g. If I specified "2024-01-09", for the data above this formula should return "2024-01-09 4:30pm, 2024-02-09 11:00am,  2024-01-09 12:30pm"Thanks!

I'm creating a new extension that will automatically update records in a table based on data returned from a server API endpoint that I control.This API computes a lot of data and will take longer than 30 seconds to respond, so this can't be a normal synchronous API call.What is the best strategy for doing this in my extension? I can think of three possible ways -* Can extensions listen for webhooks, where I call an API and get a webhook back some minutes later?* Or maybe the server writes directly to the table when the data is ready - can an extension facilitate this automatically?* Alternatively, can I have my extension automatically & continuously (without user interaction) poll an endpoint every hour for new data and update the table?Thanks for your ideas!

Hi.I have three tables: Teachers - in which all our teachers are listedMeetings - in which they upload their meeting notes with studentsGroup Reporting - in which they group and report meeting, but I'd like to make in easier on them and have the pop up that loads all the "meetings" only load the ones that have be done by the selected teacher. if possible also exclude the ones that already have been grouped and reported. How is this possible? does it mater that we are using the free plan? Also. Teachers aren't "user" they are records in the first table, and all this is done using forms. Thanks,Tomer  

Hello, I created 2 automations in Airtable: 1- to calculate the distance between two points using the Haversine formula and: 2- for reverse geocoding to convert latitude and longitude into an address. Unfortunately, I'm getting an unexpected result when I execute a new data record; it updates results with numerous rows! Does anyone know how to control this?

I have a 2 tables Events and clientsI have a form based on events table that clients submit their event requestsi want to when they open the form to have an id field based on clients table  that once they type (or choose from a drop down list) All their  info is added to the form so they dont have to type first name , last name , email and phone 

I am trying to use this to automatically add 15 or 5 days to the contract date. The “calculation” field is an IF statement to calculate which amount of days to add. BUT I cannot figure out how to get the formula to add the days and give me a new date.

I’m going on Day 3 of not being able to edit an Interface I have been building for weeks. I have reached out to AT over 24 hours ago and still no resolution. 2 min video on the issue. Has anyone experienced this? https://www.loom.com/share/9472a0447d0f4cbea523213fbf40cf83