Remove non-numeric inventory from one table as it's assigned to another

[Amplify_LA]

Hello all, I’m new to the community and have been finding so many valuable resources here - thank you!

I did some research on this question but wasn’t able to quite find the solution.

Here is the basic layout of the two tables in question:

RIGS table // Shows all our available inventory
Rig 01
Rig 02
Rig 03
etc

EVENTS table // Shows event details including which pieces of Inventory are assigned to which Event
Event 1 - Rig 01
Event 2 - Rig 02, Rig 03
etc

Objective: As Inventory is assigned in the EVENTS table, I want to remove the assigned Inventory from the RIGS table dynamically. I can make this happen per field, however it doesn’t translate to all records globally.

Thank you so much for your help in advance!

Joanna

[Kamille_Parks]

Do you want inventory deleted from your records, or marked as “unavailable”? Deleting the record from your inventory table will render your current setup moot.

[Amplify_LA]

Hi Kamille,

I would like to just change that status, not delete the record.

Thank you!

[Kamille_Parks · Accepted solution]

Well in that case you can do this with a formula field, filtered views, or both.

You could have a Status field with a formula like this IF({name of your record link field}, "Unavailable","Available")

For filtered views, you could set the filter based on that formula field, or by “if {name of your record link field} is empty”

[Amplify_LA]

Thank you so much Kamille! I ended up doing just that with filtered views.

J