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...
I am looking to get the user ID from the person who interacted with a Slack Actionable Message. From the Automation Run History, I see the User ID is saved, but for an audit trail I would like to automatically assign that user to the record they acte...
I am building out an intake form for system issues. When a form comes in I want the ticket to be assigned based on who moves the ticket into in progress. I see that I can put conditions to assign to a certain person but not build it out based on how ...
Hello!Is there a way to get a public expiring url of an attacement through a script?I use this code to get the cell value: let aTable = base.getTable("Table Name");let queryResult = await aTable.selectRecordsAsync({fields: [aTable.getField("Attachmen...
I've set automation to create record which get value from a field when a value is entered to that field (use trigger type "when record matches condition"). But the automation is real-time triggered when the typing has not finished yet, so the getted ...
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
