# Artist Management for a Cabaret / Checking Number of Attendances on a Given Date / Dashboard **URL:** \ **Category:** Ask for Help\ **Created:** [April 20, 2024, 2:25pm UTC](https://community.glideapps.com/t/artist-management-for-a-cabaret-checking-number-of-attendances-on-a-given-date-dashboard/72758 "2024-04-20T14:25:12Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![ludovic\_LISON](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ludovic_lison/32/73915_2.png) [@ludovic\_LISON](https://community.glideapps.com/u/ludovic_LISON)\ **Post date:** [April 20, 2024, 2:25pm UTC](https://community.glideapps.com/t/artist-management-for-a-cabaret-checking-number-of-attendances-on-a-given-date-dashboard/72758/1 "2024-04-20T14:25:12Z")
Hello everyone, I am currently developing an application for a client who manages a cabaret and needs to closely track the number of artists present each night. The main objective is to ensure that there are at least 15 artists per evening. To achieve this, I am using the GLIDE platform to create this application. **Client’s priorities:** 1. **Visualization of artists per evening:** The client wants a dashboard that displays the number of artists for a given date. 2. **Tracking the 15-artist goal:** They would also like a weekly graph to check if they have reached their goal of 15 artists per evening. 3. **Identification of nights where the goal is not met:** Finally, they want to be able to view a list of dates where the quota of 15 artists is not met. **Challenges encountered:** 1. **Date verification:** I am facing difficulties in verifying if a given date falls between two dates within GLIDE’s database functionalities. 2. **Existing templates:** I am searching for a similar template to this project for inspiration or to share ideas. 3. **Utilizing GLIDE’s AI:** I am wondering if it’s possible to use GLIDE’s native artificial intelligence to extract all dates between two dates (start/end). I would greatly appreciate your assistance in resolving these issues or sharing your tips and experiences with GLIDE. Thank you so much for your invaluable help! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 20, 2024, 2:33pm UTC](https://community.glideapps.com/t/artist-management-for-a-cabaret-checking-number-of-attendances-on-a-given-date-dashboard/72758/2 "2024-04-20T14:33:00Z")
> [@ludovic\_LISON](#): > > **Date verification:** I am facing difficulties in verifying if a given date falls between two dates within GLIDE’s database functionalities. You can use an [if-then-else](https://www.glideapps.com/docs/automation/computed-columns/if-then-else-column) column for this: - If Date is before Start Date, then `null` (leave empty) - If Date is after End Date, then `null` (leave empty) - Else `true` The result will be that any rows where the Date value in that row is between the Start and End Date will appear as a checked boolean in the if-then-else column. > [@ludovic\_LISON](#): > > **Existing templates:** I am searching for a similar template to this project for inspiration or to share ideas. I wouldn’t bother with this. Your use case is pretty simple, you will learn more if you build it yourself. And there is plenty of help and advice to be had here in the Community. > [@ludovic\_LISON](#): > > **Utilizing GLIDE’s AI:** I am wondering if it’s possible to use GLIDE’s native artificial intelligence to extract all dates between two dates (start/end). Absolutely not! AI is notoriously bad at this sort of thing. ---
**Author:** ![ludovic\_LISON](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ludovic_lison/32/73915_2.png) [@ludovic\_LISON](https://community.glideapps.com/u/ludovic_LISON)\ **Post date:** [April 20, 2024, 9:50pm UTC](https://community.glideapps.com/t/artist-management-for-a-cabaret-checking-number-of-attendances-on-a-given-date-dashboard/72758/3 "2024-04-20T21:50:22Z")
Thanks a lot ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [April 20, 2024, 10:03pm UTC](https://community.glideapps.com/t/artist-management-for-a-cabaret-checking-number-of-attendances-on-a-given-date-dashboard/72758/4 "2024-04-20T22:03:11Z")
I’m curious: what plan are you using and how long a history does your client wish to keep?