Remove available inventory based on date

Topic Labels: Base design
1491 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello all!

I am trying dynamically update my available inventory based on dates.

For example:

July 22, 2020
Event 1
Gear assigned A01, A02

July 22, 2020
Event 2
// When I go to select inventory I want to assign to this event, I want to make sure that A01 and A02 are omitted from the list since they are already being used on the same date for Event 1.

July 23, 2020
Event 1
// All inventory will show as available now since it’s different date.

Thanks so much in advance!


2 Replies 2

There’s no way to do this without code.

You could use the script (last post in the thread) here in a Scripting block:

or you could use this custom block:

Nice, I’ll check these both out - thanks!