Hi There,Seeking some help writing a formula to show the minimum of two date fields in a specified format. I have it working but showing without a forward slash.Formula used so far is =MIN(VALUE(DATETIME_FORMAT({6QIssuedDate},"DD/MM/YYYY")),VALUE(DAT...
Dear AllI am trying to automate "master project status" in the base, hopefully through creating a formula. "Master project" is a made of all small "projects". Logic as below: - If all of "project status" is "concluded", then "master project status" i...
When I click 'activate options' no options are showing. I've double checked that activate options isn't already ticked on any other orders. It's been working fine, so not sure why it is suddenly not working. It's not working on multiple devices, and ...
Hi again,I'm facing an issue in base designing and I can't find the answer myself or in this forum, so I'm trying here,I have this field in the table named "Actions", linked to another table named "Inventory", every time I add an action, I can choose...
Hi everyone,In an interface form, I have this field that is linked to another source.When clinking the "+ Add record", my end user will have the possibility to link a record from another table.Unfortunately, when I click on the "+ Add record" button,...
Hi there,TLDR: Copy JSON code below to create a custom Action and let custom ChatGPT answer questions and make charts from your Airtable data. 1. Motivation2. Creating custom GPTs and model instructions3. Airtable API Actions with Open API format 4. ...
I want to send a webhook when a button is pressed on a record :// Use recordAsync to get the record associated with the buttonlet record = await input.recordAsync();// Check if the record existsif (record) {// Construct the URL based on the fetched r...
Trying to get 'Full Name', 'Organization' in my primary field. My problem is that sometimes both 'Full Name' and 'Organization' are filled in, and sometimes it's only one or the other. I tried using the following formula, and it worked when one or th...
I have a lot of different clients who are using internal data entry with customized forms through the interface designer.It's such a waste of space now. And I'm stuck looking like it's external form when I just want a clean internal entry form for m...
Hi all,I want to build a base for tracking the onboarding and ongoing training of employees at our company. We have a list of “SOPs” standards and guides. I’ll just call them SOPs here. There are actually several lists (one for engineering, one for a...
Nuttshell began as an internal tool for my team to request AI summaries in a snap. We quickly realized that everyone would love it as much as us, so we scaled it with Airtable. It manages the data, automates each step, and integrates the handful of o...
Hi, I am trying to populate in a cell, "Urgent" when a project is coming up on its {Due Date} within 7 days of today AND the cell that has my completed date, {Date Filed} is Empty. If {Date Filed} is Not Empty, i'd like it to populate "Completed". If...
I have a formula that I'm attempting to show "Sold" if tickets to an event have been sold, but if the tickets have not been sold, to display the number of days until the event. I already have another formula that will give me the number of days until...
In the View pane, the little gear in the search bar (above) grants the option of filtering out everyone's personal views—is there a way an option can be added to show only views that are being synced and/or shared? And maybe even something that gives...
Added this as a comment to the Record Templates announcement but also wanted to add a new thread.I'm trying to build out a new workflow where team members can create new records in one table via a Linked Record field in a different table. When you cl...
Hello! I have created an order management app through Airtable that tracks our open orders through their entire process. We import to Airtable through a Zapier Zap from an Excel file that was exported out of our POS system. We have a master key that ...
Emails sent via automations replace underscores with nothing, thereby corrupting the URLs, and other values, that contain underscores. I've read the many posts about this and still can't figure out the syntax to use to make this happen.Here's an exam...
Hello,I'm working on an automation that, when triggered by a new record being created, runs a script. The script should take that record, parse a comma-delimited list, then create new records in a separate table. The new records are include the uniqu...
Hey All, I built an Airtable base for a consulting client and their flow relies heavily on being able to print information from Airtable. I set them up with 6 separate Page Designer extensions for them to do so. They're having a consistent problem wh...
Hello all!I don't believe this is possible with how automations work with Airtable as I know them, as they seem to be restricted to only automating one table and that one table's records. Regardless, I'm hopeful there's an extension or something that...
Hi all! I’m Thomas, an engineer working on Airtable AI. We are excited to share that AI in Automations is available for everyone participating in the AI beta, along with the ability to generate automa...
Announcements
Hey there, Airtable Community! Get ready to celebrate because it's time for the October edition of our Top Contributors post! These incredible individuals have truly rocked the Airtable Community an...
Announcements
Hi all! I’m Kelly - a product lead at Airtable focused on helping users create and drive adoption of powerful and easy to use apps. I’m excited to introduce a bundle of new Interface features that mak...
Announcements
Hey Airtable Community! I’ve been your Community Manager for a couple of months now and I’ve loved getting familiar with the space, and seeing what gets you excited about Airtable. As we continue to s...
Announcements
