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

Forum Posts

How to know if it's a duplicate record or not.

We are currently using dedupe to identify duplicates in our records.Since our records is growing, we need to do it in automated way everytime there's a new record coming in.Here's the scenario:When a new property address will be added, there should b...

Imee_Lee by 6 - Interface Innovator
  • 186 Views
  • 4 replies
  • 0 kudos

Inquiry About Cross-Account Automation Capability

Hi Team,I've one particular requirement that if  I can replicate records from one base to another, especially when these bases are located in different accounts.  I'm aware of Airtable's robust automation features and wonder if there's a solution or ...

RSk by 6 - Interface Innovator
  • 171 Views
  • 8 replies
  • 0 kudos

Automation to Link Multiple Records in 1 field

Hello,I have an automation that updates the Invoice Table paid column with a checkmark when we receive a Payment in the Payments Table with a matching invoice number. We now have noticed that clients may pay the invoice twice. To document this, I wan...

tahsinh by 4 - Data Explorer
  • 113 Views
  • 4 replies
  • 0 kudos

Merge duplicates records and delete last one

I'm working on an automation that is triggered when a record is created.Here's how it works:I have a Fillout academy registration form with the action create a record on Airtable in the Sourcing table;When the user submits the form, a record is creat...

Search and Update Record Between Tables

Hello,I am trying to set up an automation where if the invoice number column of a record in the "Payments received" table matches the invoice number column of a record in the "Invoice" table, it will update the "Invoice" table record with a checkbox.

tahsinh by 4 - Data Explorer
  • 108 Views
  • 1 replies
  • 0 kudos

Send Email Automation with URL Link

Hi - I am just starting out with Airtable and I want to track my yearly memberships and send an automated email to the customers when they are nearing their 1 year renewal period. In that email I would like to include a stripe link that they can clic...

lou2 by 4 - Data Explorer
  • 168 Views
  • 2 replies
  • 0 kudos

Autopopulate address field

Hi! 2 things…I’m trying to find a workaround so that when you being typing in the address field, the address starts coming up like in Google maps. I have the map extension installed and can not figure it out. From what I’m researching it’s not possib...

Debbiedis by 4 - Data Explorer
  • 201 Views
  • 4 replies
  • 3 kudos

Exceeding 30 second limit - Script - Delete and Merge

Hello, I have a DB ~15,000 records. I wrote a script to merge and delete records. It compares three data fields for duplications and combines the duplicate records. It also will merge data from two other fields if the fields are not empty. I tested m...

Help with linked tables automation

Hi everyone,I'm new to Airtable and I'm trying to automate the process of updating fields in a primary table based on records filled out in a secondary table. Both tables share the same ID for each record. The primary table serves as my master record...

Gchoto by 4 - Data Explorer
  • 163 Views
  • 2 replies
  • 0 kudos

new shopify order

hello every one,so i set my trigger on "When webhook received" (i receive a webhook for every new order in shopify) the problem is i wont to create a line on airtable for every line item and it has to contain all clients detail and product info relat...

Run automation if a record is linked / unlinked.

Hi everybody,Let's assume I have 3 tables:ToolsUsersRequests (= Audit Log)Users can create a request to get access to a certain tool. When the tool admin approves the request, the user is linked to the tool. That's fairly simple and already working.N...

0xab by 5 - Automation Enthusiast
  • 184 Views
  • 2 replies
  • 0 kudos

Scanning multiple tables for duplicate records

I have five tables, each with a list of contacts. I want to identify the contacts who appear on more than one table.  One setup is: When a contact appears in two or more tables, I want to add this contact to a new "cross-check" table. The new table w...

lcheung925 by 4 - Data Explorer
  • 174 Views
  • 1 replies
  • 0 kudos

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 4 - Data Explorer
  • 206 Views
  • 1 replies
  • 0 kudos

Problem syncing Excel Online to Airtable

I'm trying to sync an excel online file (that's a .url file) to airtable and airtable won't recognize it. Can anyone help? If this doesn't work I'll have to figure out how to go map fields from oracle to airtable but would be far easier to just use t...