I’ve been trying to wrap my head around this problem but I haven’t found a solution yet. Hopefully, someone in the community can point me in the right direction.
I have a base with:
- Events (date of the event, type of the event and so forth)
- Artists (name, surname, etc + the event date from the other table as a lookup field)
I’d like to see if an artist is available for a specific date and the best way to visualize it. Maybe color filters in a calendar view? But how could I do a search of an artist and return it something like: available, not available.
Is this possible?