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

Forum Posts

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

JN-AAAS by 1 - Visitor
  • 8 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
ajewell by 4 - Data Explorer
  • 80 Views
  • 1 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 ...

cnc2611032 by 4 - Data Explorer
Solved
  • 122 Views
  • 2 replies
  • 2 kudos

Resolved! Marking if entry is newest iteration

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

vvakharia_0-1701375081066.png
vvakharia by 4 - Data Explorer
Solved
  • 144 Views
  • 4 replies
  • 2 kudos

Create an algorithme with script automation

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

Seren by 4 - Data Explorer
  • 114 Views
  • 0 replies
  • 0 kudos

Automation Code help

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

Alg by 4 - Data Explorer
  • 144 Views
  • 1 replies
  • 0 kudos

Price Builder

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

Resolved! Automations to remove calendar entries?

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

Lulabirdy10 by 4 - Data Explorer
Solved
  • 157 Views
  • 2 replies
  • 2 kudos

Resolved! Copy data from one field to another in the same table

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

CharlieMullin by 6 - Interface Innovator
Solved
  • 279 Views
  • 4 replies
  • 1 kudos

Automation to copy rows based on formula

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

Lethokis by 4 - Data Explorer
  • 180 Views
  • 1 replies
  • 0 kudos

Automate due dates based on days of the week

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

MichelleS by 4 - Data Explorer
  • 563 Views
  • 1 replies
  • 0 kudos

Use a customer data record multiple times in the calendar view

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

Vogtei by 4 - Data Explorer
  • 187 Views
  • 0 replies
  • 0 kudos

Resolved! Automation to convert text timecode string to a duration field

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

trt.jpg

"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 ...