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...
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...
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...
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...
Hi I have user information in 2 different tables but in both I have a field with the user email that could be used as a linking field. I would like to set an automation to update a specific field from table B into table A using the email as a matchin...
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...
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...
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...
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...
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...
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...
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...
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...
I have an automation that invokes an API taht requires authentication credentials. What is the best way to store those credentials so they cannot be read outside of the automation? Does the input.config do anything to obfuscate them?
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 ...
Hello, Recently I have got an excel with information about customers and their ordered products and quantities.I have added all the tables and fields in order to turn this information into airtable orders with line items.Is there a way to automate th...
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.
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 ...
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 ...
Hi all,I have a problem that feels like it should be simple but is giving me a huge headache, lol. Here are some past questions I found that seem to intersect, but I couldn't seem to find my answer in the replies: 1, 2 I replicated my problem in a sa...
