Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 18, 2020 12:26 PM
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
Solved! Go to Solution.
Jul 18, 2020 01:45 PM
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”
Jul 18, 2020 01:36 PM
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.
Jul 18, 2020 01:42 PM
Hi Kamille,
I would like to just change that status, not delete the record.
Thank you!
Jul 18, 2020 01:45 PM
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”
Jul 18, 2020 07:35 PM
Thank you so much Kamille! I ended up doing just that with filtered views.
J