Dashboard Template

Sotirios Zormpas yessssss, I managed to assign color for choice field like you described here

let x := (select Appointments); let _events01 := x[choicefield=1].{ //some code here   }; let _events02 := x[choicefield=0].{ //some code here   };

Now, how can I assign color by employees?

thnx a lot

Sotirios Zormpas Good morning  thank you very much. The docs from fullcalendar with respective demos and last but not least learning by doing helped a bit to understand some more to understand - Greek.

For now there are only two employees, but maybe I will have to use two records for each employee, so there could be four 'colors' - maybe more to come.

thnx

Sotirios Zormpas me and logic... Well here I used the unique events based on the choice field and I have only two choices, so I am not sure how to create other four? I dont know how to achieve this. My first approach ist that each employee has a record ID.

In one of your previous suggestions you wrote

let x := (select Appointments);
let _eventsUser01 := x[text(_cu)="User01"].{
backgroundColor: if 'choice field'=1 then "#3485FF" end,
borderColor: if 'choice field'=1 then "#73455FF" end,
textColor: if 'choice field'=1 then "#6578FF" end,
//some code here
 };

So, is there a way to - lets say -

let _eventsUser01 := x[Employee_record_id=1].{  
 

thnx

Sotirios Zormpas I have linked the employee table with the appointment table - here is a screenshot

thnx

Sotirios Zormpas please excuse me, but I have another question. I was trying to add another calender. Right under the existing one, but the formula field is empty. I suppose it has to do with html. So I put it in Tab 2 and it worked, but the calendar is absolutely the same, which I do retrace. I guess there must be something like calendar2, right?

I just cant figure out how to achieve this. Can you help me please, do you have an idea how this works?

TY :-)

Sotirios Zormpas omg!!! thats so awesome!!!thank you very much for all your patience and help. Now I will have to find the script pieces for CSS.

Sotirios Zormpas this is too tricky for me I managed to add your code. At first the formula field was empty. Then I found out that there are other three lines where I needed to change from calendar to calendar2. The fullcalendar showed up, but its still the same calendar as calendar1.

Sotirios Zormpas omg, I feel so dumb! Yes, now I used different event sources and it works as it should. Thanks so much :-)))

Sotirios Zormpas yes definetly!!! Thank you so much for that. Now every employee has its own calendar.

Another issue(s) I found useful to add and I would like to share 

1. calendar week,

2. a line which shows the actual time and

3. drag the appointments/events in calender.

headerToolbar: {
                            left: 'prev,next today',
                            center: 'title',
                            right: 'dayGridMonth timeGridWeek timeGridDay listMonth'
                           },
            weekNumbers: true,
            nowIndicator: true,
            droppable: true,