Does anyone have any suggestions or input they would like to offer to help me decide the best way to organize my companies new lobby base? The project is tied to a sign in form (AirTable Form) for anyone coming into our lobby to sign in to.This inclu...
Hello!I am trying to set up a formula to when a checkbox in the field "Invoiced?" is checked, the "Status" field is then changed to "Invoiced". I am setting this up so that Zapier can (hopefully) check a box if a record is still there and override an...
Since the DATE field/column in any Airtable has a timestamp option, it would be helpful if the conditions allowed for the TIME to be inluded and not just the date.For example... If DATE is BEFORE NOW then xyz happens. Either on a Filter Condition or ...
We review a variety of documents for client. Such as bylaws, legal governance documents, and financial statements. Currently I have a base and a form set up. The form allows a client to submit the documents they would like to have reviewed and provid...
Hi all,I'm working on building a base for my team, and am having an issue with automating a copy-and-paste function.I have a formula which calculates the due date for tasks based on a set number of workdays from the start date. However, sometimes we ...
Hi folks,Trying to create a column with one email address in, it's currently showing 3, any idea of a formula to remove two of the addresses so I can send an automation?
Hi all!Here's a question... I'm making a basic task list in my base, I added a {Due Date} column with field type 'Date' and I have the time also showing in the same column. This will help me schedule tasks by date and time.Values in {Due Date} look l...
I am hoping someone can help answer this basic question.We have a survey where our athletes answer using a ranting system. I want to take the rating once in airtable and assign it a number value. 1 star = 1, 2 stars = 2, 3 stars = 3, 4 stars = 4, and...
I've got a handful of companies that had meetings taking place on various dates. I want to filter out those companies who did not meet on both 07/17/2023 and 12/05/2023. For example, if Company A met only on 07/17/2023, it would not be shown. If C...
Hi! In my project plan I need to use hierarchical (or outline) numbering such:1 ~ 1.1 ~ 1.2 ~ 1.2.1 ~ 1.3 ~ 1.4 ~ 1.4.1 ~ etc. (print 1) I've be doing this manually, but it would be great to have it being created automatically. I got the...
I am creating a mapping from record_ids to view name. IIRC there is no better way to to do this than list all records in each view and then create this mapping. To reduce the traffic, I would like to return no fields, when I am traversing each view. ...
Hi everyone! I'm trying to tackle an issue that I'm not sure I can solve with Airtable, but hoping to alongside Zapier integrations. I want to randomize monthly meetings across our staff, volunteers, and board. Not everyone is willing to use Slack, w...
Hello,I want to make an automation to send an email at a specific time. When I choose the trigger "at a scheduled time" and go to write the message of the email, I can write a message, but I cannot input any data from the base. When I click on the bl...
Hey All!I need some help! I'm relatively new to Airtable and currently diving into setting up an inventory/project management system for my team. Our approach involves utilizing Airtable as a combined solution for both project and inventory managemen...
I have some interfaces where list views are grouped by client name. I would like a "collapse all" or "expand all" function so that in those interfaces, it is possible to quickly expand all the lists or collapse them and then go one-by-one. The only...
Today there was an update called Refreshed linked record picker in Interfaces which makes the record picker for linked fields more compact and consistent. I like the idea, but it breaks some important things in our workflow.Namely, it does not show ...
Hello, It is my company's first attempt at using Twilio. We already have our account and phone number. Was wondering how do I set it up so we can test if the message was successfully sent to this number. Such as updating a Single Select field in Air...
I have a form built. Today I was asked to add an option to a multi-select field and published it. I added the option and it is showing in all views and in the preview, but it is not showing on the public-facing version of the form. I am not sure what...
Greetings. My automation receives a webhook from a form. In subsequent steps, I'm unable to reference the field values: it's gray, and hovering displays the error "Cannot assign list of collection of complex types to collection of complex types."How ...
Hi AT community,I'm trying to get around a script (as part of a larger automation, first step being a form submission) in which I want to:1. Grab the options available of a "link to another record" column (especially the id)2. Cycle through the ids a...
Hey Airtable Community, It's time to celebrate our November Top Contributors! These remarkable individuals have truly made a splash in the Airtable Community and left a positive impact on their fell...
Announcements
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
