Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Remove available inventory based on date

Topic Labels: Base design
836 2
Showing results for 
Search instead for 
Did you mean: 

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!