cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mhashemyan
Frequent Visitor

Booking the same item between different dates??

So I was working on inventory app all looked good until I realised I messed up

 

I have 2 tables

 

1- Event list (Starting Date, Ending Date, ID)

1- Kit inventory (List of equipment, {Name, Category, Starting Date, Ending Date, Event ID)

 

The idea is we will have events planned ahead. I have a screen for the user to create events.

 

Then equipment is assigned to the events. Currently being patched so Event ID and Start and End are patched from the Event list to the Kit inventory.

 

That tells me for what its assigned to and whether its available to be booked again. I have the filter bits (toggle become locked) working so the user is not able to double book.

 

However now I realised using this method I can't book the same kit item for multiple upcoming events which has made my efforts so far pointless. As I have now no clear idea on how to do it in a different way or if its even possible.

 

Any suggestions would be greatly appreciated.

Thanks

0 REPLIES 0

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,766)