Dashboard Template

Sotirios Zormpas good morning - I have some problems adapting this awesome calendar! Its amazing what you create and share in Ninox - chapeau!

Here is my adapted code - no error is shown, but still the calendar wont show up.

let _events := x.{
        id: number(Nr),
        title: let t := this;
        (select '2. Standortvorschläge' where Nr = t.'Standortvorschlag zu Firma/Eigentümer').(Vorname + "  " + Nachname),
        start: format('erstellt am', "YYYY-MM-DDTHH:mm"),
        end: format('Fällig am', "YYYY-MM-DDTHH:mm"),
        extendedProps: {
            description: Informationen
        }

I believe that the issue is here

        (select '2. Standortvorschläge' where Nr = t.'Standortvorschlag zu Firma/Eigentümer').(Vorname + "  " + Nachname),
 

In your version

Nr = number(t.Name)).('First Name' + " " + 'Last Name')

the number(t.Name)) its a dynamic choice field, in my case its a linked table.

Do you have an idea what might be wrong in my script?

thanks Kruna

Sotirios Zormpas I must be missing something because calendar wont show up.

Sotirios Zormpas now it shows some errors, which hadnt been there before.

Sotirios Zormpas does look the same, doesnt it?!

Sotirios Zormpas Hi Sotirrios, I imported the db from scratch and it would work except when wanting to enter a new task I get this error messages

but I do see the other task and I can open them by clicking on them..

Sotirios Zormpas you rock!!! that did it - tons of thank you!!! now everything works perfect.

I have two questions left please.

I tried to translate here

  headerToolbar: {
                            left: 'prev,next today',
                            center: 'title',
                            right: 'dayGridMonth timeGridWeek timeGridDay'
                           },

     to    left: 'vor,nach heute',

but its left empty. Is there a way to translate? I was looking at the script, but couldnt find another piece of code and the other question is whether it is possible to start week on monday insted of sunday?

Thank you so much for your great help!
 

Sotirios Zormpas yes I noticed that cool thing too  and therefore I managed to make it work. THANKS!!!

Yet I am facing another challenging issue for me. I have task and appointments, therefore I have a yes/no field for wheather it is a task or appointment. For task I have two date fields and two hour fields seperated. The first date and hour field is for when the task is made the second when its due. For apppointment I have the appointment field. I need those fields to show in ninox calendar as it syncronizes with Apple iCal. The date+hour field in this awesome calendar wont show up in ninox calendar.

I tried 

start: format('erstellt am', "DD-MM-YYYYTHH:mm"),
end: if 'als Termin festlegen' then
format(Termin, "YYYY-MM-DDTHH:mm")
else
format('Fällig am', "YYYY-MM-DDTHH:mm")
end,

als Termin festlegen is the yes/no field Termin is the appointment field and Fällig am is the date field and hour field seperated. So basically what I am trying to achieve

if yes/no field checked then appoinment field else date and hour field. Do you have an idea, if this is possible at first place?

Kruna 

With the slotMinTime and slotMaxTime you can adjust the day time.

initialDate: savedDate,
            slotDuration: '00:30:00',
                        slotMinTime: '08:00:00',
                        slotMaxTime: '18:00:00',

Sotirios Zormpas yes, you are right and that works perfect now! thank you so much for helping me sort out this issue.

Next and hopefully last I am trying to resolve here is the yes/no field issue - the code is

start: format(start(Termin), "YYYY-MM-DDTHH:mm"),
end: if 'als Termin festlegen' then
            format(endof(Termin), "YYYY-MM-DDTHH:mm")
        else
            format('Fällig am', "YYYY-MM-DDTHH:mm")
        end,

It doesnt show any error, but doesnt work at all. It seems not to be as easy as I thought , but I am not sure wheather its possible at first place?

Rafael muchas gracias Rafael, when I insert your script it shows me errors 

Edit: I put it in the wrong lines, now its correct and a good point!! Thank you for the helpful hint

If I put 18:00 it just shows till 17:00 and 18:00 its not clickable - is it supposed to be like that?

Sotirios Zormpas good morning - it somehow doesnt work for me. The appointments are shown however the date field not. I also tried to use a choice field 

start: format(start(Termin), "YYYY-MM-DDTHH:mm"),
        end: switch Auswahl do
        case 1:
            format('Fällig am', "YYYY-MM-DDTHH:mm")
        case 2:
            format(endof(Termin), "YYYY-MM-DDTHH:mm")
        end,

but case 1 doesnt work. :-(

Sotirios Zormpas its only a date field the hour field is seperate. The reason why I have them seperated is that combine date/time field doesnt show in ninox calender. I need all fields with dates being showed in ninox calender too as its synchronized with iCal - the apple calendar. By the way is there a way to sync FullCalendar with iCal?

I tried this without success...

end: switch Auswahl do
        case 1:
            format('Fällig am', "YYYY-MM-DD") + "" + format(Uhrzeit, "THH:mm")
        case 2:
            format(endof(Termin), "YYYY-MM-DDTHH:mm")
        end,

thanks