I have a complex formula I am trying to write, and unfortunately it says there is an error in my code, but I can't seem to work out what! I am trying to write a custom field that says LIVE, FUTURE or COMPLETED depending on the number of days away an ...
Hi!Fighting with third party services that have limits on executions that are limited to 1 per seconds or something like that?I'm fighting this inconvenience that i'm creating queues with data...Just wondering if it make sense that Automations have a...
Hello, i'my trying to compare efficiency of real-time project durations to theoric template durations. Projects are linked to tasks and tasks templates ;-> total duration of a project = sum of the duration of each task-> duration objective (efficienc...
Hi,i connected my Airtable to a Salesforce Report. Now the long text fields are cut and it does not show the entire Text.Is there a Solution to this problem?It is cutted like: Text Text Text...
Imagine that I have three different fields.Disboard URLTop.gg URLOfficial invite URLHow do I make it so if a field isn't found in the formula, it'll fallback to the next one of lower priority.For now I would like my formula to lookup three fields.Her...
I have table descriptions that I want to edit. I am able to use the arrows to move around within the description section (including cmd+A on mac to highlight everything) but if I want to get to a specific area by clicking, the box stops responding (a...
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...
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
