0

Ninox Timesheet template

Hi All,

I want to create something similar to the ninox timesheet template they have and I just wondered if someone can help me.

Within this template they have a sub table called "Calendar Days" which has a row pre populated with the date field upto 2031 and possibly beyond, how are they doing this?  Screenshot attached.

I cannot see any functions onload or onopen that creates all those records, any help in replicating this function would be ace

1 reply

null
    • Fred
    • 5 days ago
    • Reported - view

    If you look at the Options section of the DB, you will see there are scripts in the Trigger after open section. Here is the relevant section:

    if record(Admin,1).'Reset all dates' then
    let myDays := days(date(2022, 10, 19), today());
    (select Contracts).('Valid from' := newDate('Valid from', myDays));
    (select 'Time tracking').(Date := newDate(Date, myDays));
    (select 'Calendar days').(Date := newDate(Date, myDays));
    record(Admin,1).('Reset all dates' := false)
end;
Login to reply

Content aside

  • 5 days agoLast active
  • 1Replies
  • 34Views
  • 2 Following