Remove available inventory based on date

[Amplify_LA]

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!

Joanna

[Kamille_Parks]

There’s no way to do this without code.

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

Asset Reservations: No Double-Booking Scripting app

Use Case: You have a table of assets (library books, conference rooms, etc.) that you want people to reserve, but don’t want people to be able to reserve an individual asset at the same time it has already been reserved. Solution: No-Conflict Asset Reservations script by Kamille. This script allows you to schedule a new asset reservation in a form-like interface by setting a date range, then selecting from a list of assets which are un-reserved for that time period. [Screen Shot 2020-03-20 at…

or you could use this custom block:

Devpost

Scheduler

This custom block allows users to schedule events, reservations, or appointments without double-booking any of the selected records in a simple, easy-to-use calendar interface!

[Amplify_LA]

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