Hope someone can help me out for a little bit here.
First, I know my explanation will be confusing, so I am attaching a link to a base showing what I want to accomplish: https://airtable.com/shr6FQZzExhS9nMXK/tbloqyvdM3fTPGRs7/viweFLF5nx2Fn54Du
I have 2 tables, referencing each other:
Project - all my projects
Equipment - devices used in the projects.
When a project ends (shown by the ProjectFinished date field), I want the DeviceName in the CurrentDevice-field to be moved to the DeviceUsed-field.
The FileteredView-view is filtered on todays date, so whenever a record is in this view, I would like the move to happen.
The reason is that I don’t want equipment attached to a project that is not running anymore, I want it to be “free” for a new project.
I assume this can be done through Zapier, but I have not figured out how. Even better of course if it can be done directly in Airtable.
Thanks in advance!