Help
Automations
cancel
Showing results for 
Search instead for 
Did you mean: 

Automations 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
  • 50 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
  • 77 Views
  • 2 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
  • 89 Views
  • 1 replies
  • 0 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...

  • 114 Views
  • 1 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 ...

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

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

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

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

  • 105 Views
  • 2 replies
  • 0 kudos

Upload .wav file to airtable from html javascript recording

I have a javascript code that basically displays a recording menu that allows you to record your voice, and then I added that on stop you can click to send the file to airtable. But I keep getting 422 error. I read somewhere that when sending attachm...

  • 66 Views
  • 1 replies
  • 0 kudos

Reduce Script Runtime

I have a script that takes a fuel price increase in a single cell and applies it in each cell in a row of fuel prices at various Fuel Stations. The code is copied below. How can i optimise the code to run in as little time as possible?let table = bas...

  • 55 Views
  • 1 replies
  • 0 kudos

Month End Close

I am attempting to use Airtable as a month end close tracking form. Is it possible, that once a task is completed, it will create a new task for the same day in the next month? As an example, this task would be completed on December 15th, then once c...

  • 178 Views
  • 1 replies
  • 0 kudos

Linked records overwriting eachother

 Hi, I need help with an automation that I can't get to work. I have set up 2 separate automations, both triggers "when record matches condition" (different conditions) one adds one linked record, to field "work" and the other automation adds another...

IMG_8839.jpeg
  • 58 Views
  • 2 replies
  • 0 kudos

Generic error on automation to update linked records across tables

My data schema is such that I have Programs which contain projects, each has its own table. I then have workers as a separate table, where I can link the workers to programs and/or projects. I am trying to set up an automation that checks if a worker...

  • 61 Views
  • 1 replies
  • 0 kudos

Column Width in Email Digest Grid

I'm trying to adjust the column width in an digest email but the truncate fields doesn't change the layout and I'd like the columns to be spread out more. Is there any way to set this? Even adjusting the view I'm pulling from doesn't change anything....

email_column_width.jpg
  • 76 Views
  • 2 replies
  • 0 kudos