I'm looking for a way to implement a calendar component that can display appointments from my Retool database. In my database, there's a column with the email addresses of users associated with these appointments. My goal is to place a multiselect component alongside the calendar component, which will display the email addresses of users. When one or more users are selected in this multiselect, I want the corresponding appointments for these selected users to be displayed in the calendar.
In summary, I want to provide the user with the ability to select multiple users in a multiselect component, and then have the appointments of these selected users displayed in a single calendar component. Does anyone know if this is achievable?