Hi all,When someone submits a form, I already know we have a relatively empty record that exists for that submission. I want an automation to do the following:Trigger: When a form is submittedAction 1: Find a record by matching phone numbers in the t...
Hi, I'm new to automations on Airtable and am facing an unusual error:"Name is "foo", Invalid filter on Email (Invalid choice name or id: foo@bar.baz)"My "Find records" step has two conditions (OR), attempting to match on "Name" or "Email".Here you c...
Hi, Table A, B, and C. Table B fields are linked with Table A and Table C. I'm trying to run automation. Whenever a new record is added, I will filter the records from Table A and Table C based on the condition. Then I need to create a record in Tabl...
Hello,As the title implies I am looking for an automation to catch records created by a form and notify via email when there is a discontinuity from the last submission. For example if the miles entered on a particular vehicle in the last submission ...
let table = base.getTable("Orders"); let field = table.getField('Order Info'); let record = await input.recordAsync('Choose a record', table);I know that if I make this script, I can press the button and then select the record to run the automation....
I have two tables in my Airtable database: "Interfaces" and "Participants Backend V1". In the "Interfaces" table, I have columns like "int_Email", "int_Name", "int_Dance Course", and "int_Today's Date" (Ceckbox). The "Participants Backend V1" table c...
Hi! Thanks for any help.Not sure what is causing this. I set up an automation to send an email when a field is updated to a certain value.The email is sent but the data from the specified fields are not included and there is an error. Here is the ema...
Hi all!I've created an automated email and am trying to include our company logo as a footer.The code I've used in the input is: <img width="200" height="50" src="https://www.the-page.co.uk/psoostoo/2022/05/The-Page-LOGO-2048x486.png">In the preview,...
Hi all, Any help would be appreciated on this one. I'm working on an automation in Airtable we previously used Zapier for to try and streamline some self-fulfilling on-demand educational resources. The way I currently have it set up is in one Airtabl...
Hi Airtable Community,I have a table with events. New events can be added via a form and various needs can be requested for the event using a multiple selection field.A record is generated in a second table for each need.I have currently created an a...
