Update the previous record using automation - Help Needed

[CottageKeeper]

Hello! I’ve created a simple way to track time with clients using two forms.

Basically using their mobile phone:

The agent will complete the ‘Start Time’ form to record their start time with a client. When they are done they will complete the ‘End Time’ form.

This creates two records as shown:

What I would like to automate is when the ‘End Time’ form is submitted I would like it to update the previous record with that end time. So it looks like this after the automation:

I’ve tried multiple triggers with actions but I can’t figure it out.

I would be most grateful for any insights the Airtable Ninja’s could provide!

[ScottWorld]

As of last week, automations now give you the ability to search for records, so you could search for the previous record and then update it.

[CottageKeeper]

Thanks @ScottWorld - this is the very reason I’m trying the automation. But I’m doing something wrong…

I think I do not understand the logic of how to access the previous record correctly.

[CottageKeeper]

Here is the base if anyone wants to troubleshoot with me.

Agent Time Tracking

[ScottWorld]

For your trigger, you’ll probably want to use “New Record”.

For the update record step, for the Record ID field, you need to choose the Record ID from Step 2.

I would highly recommend watching the Getting Started videos, so you can learn more about automations:

Automations Overview

Here is a 1-hour training video on Automations as well:

Training video - Airtable