I wrote a script in my automation to create a linking table of sorts that carries over records from two different tables. I have a field that is a formulated value in both source tables and in the target table I want that to be single-select. Is this...
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...
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 ...
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 ...
Dear AllI am trying to automate "master project status" in the base, hopefully through creating a formula. "Master project" is a made of all small "projects". Logic as below: - If all of "project status" is "concluded", then "master project status" i...
Hello! Here's my situation.I have a table 'Part List' that is automatically updated with parts from an external base that I do not control. One of the data entries inputted is "version" and "iteration". So I could have the following table:Part #Versi...
Hello everyone, I need help with automation. 1. I have Table 1 with the primary field 'Date' where I receive in a column 'Complete Description' a long and annoying detail2. I want to simplify step 1. based on the primary field of Table 2 'Expense' wh...
Hello, I am trying to create an algorithme in AIRTABLE using the script automation. I have 3 tables : Mission_Request, Cookers and Companies. My script compares all the pattern in both Mission_Request (wich is connected to Companies table) and Cooker...
I am trying to assign 4 different users records as the come in. I found this code const collaborators = [ {name: "Person 1"}, {name: "Person 2"}, {name: "Person 3"}, {name: "Person 4"} ] const chosenOne = collaborators[Math.floor(Mat...
Hello Airtable Community,I’m currently working on improving our Airtable system and could use your expertise. We have a setup where participants sign up for trips, and upon signup, we need to automatically generate a billing record. Here's the challe...
Hi all! I am reaching out in hope of finding a solution. So I work for a music instrument manufacturer where we track each job (all instrument specifics) in our airtable database. I am trying to find a way to have a price column that calculates as yo...
I use Airtable to track and schedule vaccinations for the animals in my calf barn. Using the birthdate of the calf, I have formulas in the due date fields to calculate the appropriate date to give each vaccine to each animal. Then I have a field with...
Looking to use a button that when clicked, links that associated record to other selected records.
What's a good way to copy data from one field to another in the same table?Currently, I have data in Field A that I want to copy to Field B because I want to deactivate Field A (probably hide it.) Then, going forward current processes where data was ...
Dear Community,I do have a table with a formula field, which tells you how many times a row has to be copied.I did set up an automation which tells you to copy the row, when formula field is bigger than 0.What I can't figure out is how to tell the au...
Hi! I'm trying to create an automation to assign a due dates to tasks that all have a due date of Thursday, and the tasks vary by how many weeks out they should be completed. For example, our "Final Paperwork Due" task always needs to be due the Thur...
HII'd like to update my current job submission form to collect extra details on certain projects. I only want this new field to appear if Job Type "XYZ" is selected (I know how to do that part!)Part I need help with:I need the submitter to answer a ...
Hey guys,I'm totally new to Airtable and just trying to find my way around. I am or was a private Notion user for a long time, but was looking for a DSGVO-safe alternative with end-to-end encryption for a simple database or customer overview. Current...
Hi All, I'm trying to use a linked record to pull up the TRT of an asset that's listed out as a full timecode, extract just the hours and minutes and put that into a duration field. I've gotten so far as to pull the hours and minutes but when I set t...
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 ...
