I think that, depending on how often you need to move your equipments to the {DeviceUsed} field, you simply can do it by hand within Airtable by cutting (Ctrl + x) the device in {CurrentDevice} and pasting it (Ctrl + v) into the {DeviceUsed} field.

For Zapier, I don’t know as I’m not using it …

Edit :
I think, in fact, that you can cut and paste the entire field from {CurrentDevice} to your {DeviceUsed}when you’re on your filtered view.

Hi,

It´s what I do today actually, but over time it´s not very scaleable, so something automatic would be to prefer.

@EAugum -

Here’s how I would do it.

Rather than bother with changing linked-record fields to indicate device availability, I’d add a few fields to my device record. Now, whenever you are configuring a new [Project], you select the plus sign in the {Device} field and select a record from the list of devices. The first field in the [Equipment] record indicates whether the device is available or not; if the user selects an unavailable device, an alert appears in the linked record, and (if your plan supports record colors), the affected [Project] and [Equipment] records are tagged red.

Within the [Equipment] table, each device record may be linked to multiple [Project] records; only one linked [Project] may be active at any given time. Through the use of interlocking rollups, the date and name of the most recent project with which that device was associated are displayed.

With this approach, devices are automatically tagged as available on the day following the date the most recent project concluded. No middleware or manual toggling of active/inactive devices is required.

Note: Renamed post from “Move record from one field to another” to “Automatically mark resource as available upon end of project” to aid future searchers of the ‘Ask the Community’ forum.

Thanks, this is great! I will be able to tweak this to fit my production base!