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

Automations Activity

Automating new row creation in a user submission form

Hi there,I have a registration form. A single respondent will enter the the following data: name_1, email_1, an ID code, name_2, email_2, name_3, email_3.Instead of this being stored as a single row. I need this to be stored as multiple rows.row 1: n...

  • 11 Views
  • 0 replies
  • 0 kudos

Delete record along with linked records from a specific field

Using airtable for project management, so far the set up etc is fine. One thing I am trying to set up is a script (can be put into a field as a button) that deletes the record that the button is in but also deletes all linked records in the sub task ...

  • 26 Views
  • 0 replies
  • 0 kudos

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
  • 82 Views
  • 1 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
  • 120 Views
  • 4 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
  • 119 Views
  • 2 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...

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

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

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

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

  • 88 Views
  • 2 replies
  • 0 kudos

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

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

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

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

  • 181 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
  • 61 Views
  • 2 replies
  • 0 kudos