Automation Question

[Bobby_Gay]

I have two tables in a base named Appointments and Revenue. I use Zapier to send appointments and transactions from my CRM to Airtable. The appointment records include a Technician Name. The revenue transactions do not and cannot include a Technician Name. They both, however contain a Job # field.

I'd like to create an automation that is triggered when a new revenue record is created. It would look into the appointment table to find the Job # that corresponds to the Job # in the revenue record and returns the Technician Name from the appointment record and populates a Technician Name field in the revenue record.

Can anyone tell me how to do this (assuming it is possible)? Thanks!

[Dan_Montoya]

This is a pretty standard automation -

Trigger: When a record is created 

Action 1: Find records in technician table where job # matches job # from trigger

Action 2: update (linked record field) technician with record found in Action 1.  Best Practice and an IF statement around action 2.  IF # of records found = 1 then do the update.  This will keep your automation from failing if there is nothing found. Next, I would say if no records found send me a slack to find out why.

[Bobby_Gay]

Dan, again thank you. I am new to automations with airtable, so I'm getting hung up. I have successfully created a trigger for when a Revenue record is created. I have been able to create a Find, in the Appointments table, the Job #.

In the Find Records function I have created a condition where Job # is not empty and the Technician name is not empty.

That action passed the test

My problem is with the Update Record action. My goal is to grab the Technician Name value from the Appointments table and update the Revenue record Technician Name value with the same. I don't understand how to select the correct Record ID and Fields. I have Technician Name fields in both Appointments (which is populated) and a Technician Name field in Revenue (which is blank). 

To make things a little simpler, I renamed the two fields: TechA Name (for Appointments) and TechR Name. Can you give me some more guidance?

Thank you!

Bobby

[Dan_Montoya]

It looks like you are trying to update the records from the find instead of the recordID of the triggering record.  Then your TecRName field should get the "list of techA Name"

[TheTimeSavingCo]

Hi Bobby, I've set up what I think you're looking for here

It's pretty much what Dan mentioned, but I didn't build the best practice bit as I'm running late heh

You can duplicate the base to your own workspace so that you can play with it and figure out how stuff works!

[Bobby_Gay]

Thank you! I will give this a try later.