Help

Welcome to the Airtable Community!

59294members
139402posts
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Activity

Date error in copy-and-paste automation

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 ...

Screenshot 2023-12-08 at 1.28.46 PM.png Screenshot 2023-12-08 at 1.30.34 PM.png Screenshot 2023-12-08 at 1.30.23 PM.png Screenshot 2023-12-08 at 1.31.00 PM.png
  • 9 Views
  • 0 replies
  • 0 kudos

Time changes date

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...

  • 12 Views
  • 0 replies
  • 0 kudos

rating to number

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...

  • 49 Views
  • 2 replies
  • 0 kudos

Select Filtering

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...

  • 14 Views
  • 0 replies
  • 0 kudos

How to automatize hierarchical or outline numbering

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...

NLOIA_0-1702040415076.png NLOIA_1-1702040446264.png
  • 37 Views
  • 2 replies
  • 0 kudos

Return only ids when calling List records

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. ...

  • 16 Views
  • 0 replies
  • 0 kudos

Randomize meetings

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...

  • 28 Views
  • 0 replies
  • 0 kudos

Can't Pull Data from Base for Automated Email

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...

natalie_stein_0-1701982603615.png
  • 47 Views
  • 1 replies
  • 0 kudos

Limitations with New Linked Record Picker

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 ...

Calvin_Young2_4-1701976168697.png Calvin_Young2_1-1701975724986.png
  • 163 Views
  • 7 replies
  • 3 kudos

AirTable x Twilio

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...

  • 81 Views
  • 0 replies
  • 0 kudos

Unable to Choose Values from Webhook

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 ...

  • 42 Views
  • 1 replies
  • 0 kudos

Getting "User Action" from Slack Actionable Messages

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...

  • 49 Views
  • 0 replies
  • 0 kudos

Resolved! Updating a field by automation based on action by someone

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 ...

  • 76 Views
  • 2 replies
  • 0 kudos

Resolved! Get an expiring url from an attachment cell value

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...

  • 65 Views
  • 2 replies
  • 0 kudos

automation problem: incomplete value

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 ...

  • 96 Views
  • 2 replies
  • 0 kudos

Announcements

Airtable Top Contributors | November 2023

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

Introducing AI in Automations

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

Airtable Top Contributors | October 2023

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

An Improved App Building Experience

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