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

Forum Posts

Automating increments

Hi, I have been trying to figure out how to increment a number upon adding a new line. For example, Line 1 = A0001 Line 2 = A0002 Line 3 = A0003 I understand that the function of auto-number helps but i would like the characters in the front and want...

Translating Spanish Field to English Field

Hello! I work at a nonprofit that offers technology training to bridge the digital divide. We are transitioning to Airtable and Typeform to manage our classes, partner relations, survey data, and more. We have many different class types that each hav...

elle by 1 - Visitor
  • 15 Views
  • 0 replies
  • 0 kudos

Calculate a date for an automated task

Hi,I'm trying to set up an automation that generates tasks with due dates. For example, when I create a project with an overall due date in a "projects" table, I plan to create a record in the "tasks" table with individual tasks and due dates calcula...

Sarah_Krutz_0-1685729597696.png
Sarah_Krutz by 5 - Automation Enthusiast
  • 17 Views
  • 0 replies
  • 0 kudos

Fetch generated "TypeError : ... not permitted"

Hello !I am encountering a problem when creating an automation script for one of my tables. I set up a trigger to occur when the user creates a record. I then wrote a script to be run as an action of the trigger. This script contains a 'fetch' call t...

s_kmb by 5 - Automation Enthusiast
  • 293 Views
  • 14 replies
  • 0 kudos

Resolved! When a record is created create a record only is value is unique

Hi there,I have a form that captures emailHere is an example of what the data could look likeI'm trying to create an automation such that any time a unique email is entered, data is populated here. In the table above you see that ethan@abc.com is ent...

ethang_0-1685633493366.png ethang_1-1685633521792.png ethang_2-1685633557770.png
ethang by 4 - Data Explorer
Solved
  • 49 Views
  • 2 replies
  • 1 kudos

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
  • 71 Views
  • 2 replies
  • 1 kudos

Track Last Edited By

I have an interface to track overtime opportunities for my team. There is a button to click if you'd like to express interest in working an event with an automation set up to:1) send an e-mail with your name and the event you're interested in to mana...

pantostada by 5 - Automation Enthusiast
  • 63 Views
  • 2 replies
  • 0 kudos

Google sheets being updated twice

I'm using an automation that updates a Google sheet automatically, however it is updating adding the rows twice for each entry. I have no idea why it's doing this. My only thought could be because it's a linked record. If anyone has an idea that woul...

qwik3r by 5 - Automation Enthusiast
  • 51 Views
  • 2 replies
  • 0 kudos

Automation to update a field via linked field

Not sure if this is possible but I'm trying to use an automation that updates fields based on something that occured in a linked field. e.g. Table A contains events:Event 1Event 2Event 3Table B contains attendees for each event and are linked togethe...

qwik3r by 5 - Automation Enthusiast
  • 62 Views
  • 2 replies
  • 0 kudos

Automation Upsert

I have a transaction table that is collecting post information through a serverless function. When I get those transactions, I want to run an automation that will look for am email address and, if found, update the contact record, if not found, inser...

When form is submitted, update record in another table?

I have a set of records that are connected for our market garden. One is a "Bed history" table that keeps track of all events that happen in a garden bed. One of these events is "transplanting.""Transplanting" is linked to another set of records call...

oreocereus_0-1685607746124.png oreocereus_1-1685607764852.png oreocereus_2-1685607805843.png
oreocereus by 5 - Automation Enthusiast
  • 41 Views
  • 3 replies
  • 1 kudos

Trigger to update all records in a table

I want to be able to send SMS and emails to a group of attendees of a workshop in bulk via Zapier. It seems that the best way to do it would be to use the "when a record in Airtable is updated" action but I don't want to have to update each record in...

qwik3r by 5 - Automation Enthusiast
  • 91 Views
  • 6 replies
  • 0 kudos

Updating an existing record through a form- a few issues

I have a table (Table #1) in which we keep upcoming events, along with their dates, topic, marketing content etc. I created a mirror table (Table #2) with the same fields. Table #2 has a form our staff uses when they need to update any of the events ...

Limi by 5 - Automation Enthusiast
  • 52 Views
  • 3 replies
  • 0 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
  • 128 Views
  • 1 replies
  • 0 kudos

Multiple forms on same page with single submit button?

I have a form for our market garden, which the user inputs information for direct seeding a bed. Each record is the date+crop, and keeps information on how much seed was used, how it was sown and such.There is a repeating automation, for if the user ...

oreocereus_1-1685567150878.png
oreocereus by 5 - Automation Enthusiast
  • 77 Views
  • 4 replies
  • 0 kudos

Resolved! Need to Populate a Linked Record Field with Automation

Big Picture: Im trying to accomplish a process to automatically link records between tables. The use case is automating a process where when a user updates their membership in an external system, airtable creates a new membership record and links it ...

Webs by 5 - Automation Enthusiast
Solved
  • 68 Views
  • 2 replies
  • 1 kudos