Skip to main content
Solved

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

  • July 18, 2020
  • 4 replies
  • 41 views
A

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

Best answer by Kamille_Parks11

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”

4 replies

Kamille_Parks11
Forum|alt.badge.img+27

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.

A
  • Amplify_LA
  • Author
  • New Participant
  • July 18, 2020

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.


Hi Kamille,

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

Thank you!

Kamille_Parks11
Forum|alt.badge.img+27

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”

A
  • Amplify_LA
  • Author
  • New Participant
  • July 19, 2020

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”


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

J

Terms & ConditionsAccessibility statement