Artist Management for a Cabaret / Checking Number of Attendances on a Given Date / Dashboard

Ask for Help
1

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!

2

You can use an if-then-else 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.

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.

Absolutely not!
AI is notoriously bad at this sort of thing.

2 Likes
3

Thanks a lot

4

I’m curious: what plan are you using and how long a history does your client wish to keep?