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

Forum Posts

Multiple Record Specific Update

I am working on a massive update to my table 250+ records. Each record has a "terpene profile" field that can contain anywhere from 1-9 terpenes, each with their own associated "effect" , "flavor and aroma profile" and "helps with" fields that all ne...

Resolved! Using time-based formulas to trigger automations

I am collecting survey results into an airtable base.This includes two tables:The index for all surveys (and including key information such as deadline).The responses for the various surveys (each response is linked to a survey)Each survey has a dead...

Nils by 4 - Data Explorer
Solved
  • 90 Views
  • 2 replies
  • 1 kudos

Create a script to upload an attachment via SFTP/FTP

Hello. I'm looking for a script or an automation that I can use in Airtable to automatically upload an attachment to an SFTP/FTP site. I have made it work using Zapier and EasyFTP but I was wondering if there was a script that could do this. 

Mike_Martins by 5 - Automation Enthusiast
  • 133 Views
  • 1 replies
  • 0 kudos

Exactly match condition

Hello, is there a way of Exactly match a word, I am trying to do an automation that includes Only "Capital" . the condition automatically returns any cell that has  Capital, and the whole point is to only return the cells that contain Capital by itse...

Matching records from two tables

I have "table A" that holds clients. "table B" holds items. I want to see if there is a match for a field value. If "value 1A" from table A is < than "value 1B" from table B its considered a match and i like to receive the recordID for both.

Expiring Download URL Attachment Filename

Hi,I have been cracking my head for hours trying to find something in Airtable documentation for this.We are trying to upload Airtable attachments to our website (so we don't have to rely on Airtable). Is there a way to:1. display the Expiring Downlo...

siliceous by 6 - Interface Innovator
  • 206 Views
  • 11 replies
  • 2 kudos

Resolved! Automation Based on Formula Field Result Changing?

I have a formula field in one of my bases that is designed to show us how much work is left to be done before a project's start date.So we have the start date and the number of outstanding tasks.  The formula field looks at those two fields and lets ...

Resolved! create a dynamic form embed to webflow

Hello,I would like to create a job board with webflow and use Airtable as a backend when an application is submitted and send an automatic email summarizing the application (for the applicant and for me)First question :- Does an airtable form can be ...

camilledvz by 4 - Data Explorer
Solved
  • 92 Views
  • 1 replies
  • 1 kudos

Resolved! Workday formula and Dependency Automation

I have a work date formula in the 'end date' column.IF(AND({Start Date},{SLA (days)}), WORKDAY({Start Date},{SLA (days)}))When someone changes the SLA number, start dates and end dates changed because I setup a dependency automation.However, I'm seei...

JaclynB by 5 - Automation Enthusiast
Solved
  • 256 Views
  • 5 replies
  • 0 kudos

Resolved! Automation - update fields with sum of other fields

Hi there,Hoping someone can help with something I hope can be automated. I have multiple fields with numbers in, let's say:Field 1A: 100Field 1B: Field 2A: 250Field 2B:Field 3A: 500Field 3B:I then have a % field, based on which I would like an automa...

jwag by 5 - Automation Enthusiast
Solved
  • 119 Views
  • 2 replies
  • 0 kudos

Duplicating Records via Automation Script

Javascript baby here. My ultimate goal is that when a record is created and matches conditions, a script will run that will duplicate that record a number of times and update it's status. I've been modifying a duplication script from an extension scr...

Teagan_Clark by 5 - Automation Enthusiast
  • 178 Views
  • 3 replies
  • 1 kudos

Resolved! If statement with date formula

Hi there, Im new to airtable and Im having difficulty with formulas in general.Currently on my table is Name, Date and the PromoWhat Im trying to achieve is that every time a new person and the date is added, the person is given a promo based on the ...

dre_1 by 5 - Automation Enthusiast
Solved
  • 306 Views
  • 6 replies
  • 2 kudos

Automatically duplicate a record

Hey there Y'all - I am trying to have Airtable automatically duplicate a record in the SAME table when the status of another record is "approved". The duplicate record would have all the same information except the status would be set to "editing" an...

MelHA by 4 - Data Explorer
  • 183 Views
  • 3 replies
  • 1 kudos

Resolved! Update Status Field Across Multiple Tables for Specific Records

Howdy AT Community! Hoping a kind soul can provide some assistance with an automation query. I'm trying to track subscription activations for a University cohort, pulling from a large Uni Cohorts table to update a specific cohort tracker table.  Desi...

Gruss by 6 - Interface Innovator
Solved
  • 257 Views
  • 6 replies
  • 1 kudos

"Message" could not be converted to a string.

I am trying to insert a formula field for a "friendly name" into an automated email.The formula just looks to see if a person has a nickname and then either uses the first name or the nickname.IF({Nickname},{Nickname},IF({First Name},{First Name}))I ...

Record Update

Hi All,I am a Recruiter and I stored my candidate details in Airtable like Name/Contact No./Current Company.Now I want to share an automated email to my candidates to update their respective record. Note: My candidates don't have edit permission. Ple...