timesheet | Odoo Timesheet Management Addons

At the moment I am working on an addon for the timesheet_grid module for odoo13. I came across this problem, cant find any solution. I think it says the view name is already taken, is this right ?

My code

I have a json object which i like to save in mongodb,

I want to write a simple desktop application to track the overtime work of our employees. Whenever one of our employees needs to perform some tasks outside our normal working hours we want to track them using "Kimai Time Tracking".

The application I am programming needs to get the duration of all recorded tasks from Kimai, add them up and store them on a local SQL Server as an overtime contingent for the employee to claim later.

This is the GET request I'm mainly gonna use:

GET /api/timesheets (Returns a collection of timesheet records)

and this is an example output from the Kimai Demo (Sorry for length)

I have a macro (below) that inserts a new row into an un-defined number of Named ranges using ParamArray, it works fine except for when I try to assign the macro with more than 5-6 arguments I get a message box that says "Formula Too Complex to Assign To Object" (see picture above)

(see assignment string below)

'InsertNewRow "ServiceCrewDay_EmployeeList", "SAP_SCD_InPool", "SAP_SCD_OutPool", "SAP_SCD_SecondaryIn", "SAP_SCD_SecondaryOut", "SAP_SCD_ORD","SAP_SCD_THF","SAP_SCD_LH", "SAP_SCD_LH"'

Macro:

I have created a formset to let users log hours on a weekly basis. The issue I'm having is that I can't save "0" in the input fields - any decimal works but 0 (see gif at the end for illustration)

TLDR: Formset saves any input except 0, no idea why. See gif here for illustration: https://imgur.com/a/iCMexQk

My Timesheet and TimesheetEntry models looks as following:

Following the example at https://material-ui.com/guides/composition/#button, i define in my main page a button:

I have a table I need to complete, for now, it has 3 columns DATE, SHIFT and STATION.

I only want the data that is attached to the logged-in user.
I have a pivot table where I can call the data from for DATE and SHIFT, but Stations is a separate table,

My pivot table is to display my many to many relationships between USER and SHIFTS called shift_user. this works, the STATIONS table relationship is a one to many relationship with USER as a User will belong to one station, but a station will have multiple users

Stations model

I have created the 3-way pivot table for Users, Shifts, Patterns. It is called pattern_shift_user.

[pattern_shift_user.][1]

I need a bit of help with sql query for MS Access and not sure if it is possible.

We have a database for our clock machine, MySql which I have linked to access in order to pull the clockins from the database and be able to generate a timesheet.

The relevant tables that I am Using Are:

• Table: Checkinout - Fields: ID, Checktime, Checktype (In or Out) and userid
• Table: Userinfo - Fields: userid, name, company_id and badgenumber
• Table: Company - Fields: company_id, company

I have a report form that is used to select the company, reporting period (today, yesterday, custom, etc) and from above selection a timesheet is generated for the specified company which is working nicely.

What I am struggling with is filtering out all clockout (checktype) before a specified time on start time and filtering out all clockins on last day specified. But in between the start and end date checkin and checkouts but me shown as per attached image. .

My current query that is not working that i have placed in qrycheckin: