Hello ,

I'm using below code for date validation

 sheetForNPD.range("O2:O100").validation({
        dataType: "date",
        showButton: true,
        comparerType: "between",
        from: "DATEVALUE(\"1/1/1900\")",
        to: "DATEVALUE(\"1/1/2050\")",
        allowNulls: true,
        type: "reject",
        titleTemplate: "Start Date validation error",
        messageTemplate: "Start Date should be between 1899 and 2050 year."
    }).format('MM-dd-yy');

But i need if user enter in these format then also acceptable 

Hello,

I have applied range validation for numerical type data it's working until i'm entering single record but it's not working when i'm paste multiple record it's not validating please give me any solution.Thank you

I use kendoEditor(jQuery) to let user create html content. Then, saving this content as html and using this html content to export to a pdf document by xmlParser. 

I also restricted the width of kendoEditor by A4 page width in order to create a PDF document without fitting problem.

But the problem is the users are not able to know page end so their contents might be split. For example, they create a table and table header in kendoEditor but this table and its header can be split in two pages when exporting to pdf document.

So, is there a way to show page layout or a page end marker or line in kendoEditor?

        toolbar: ["create"],
        columns: [
            { field: "id", title: "Id", hidden: true },
            { field: "type", title: "type", hidden: true },
            {
                field: "tenantId", filterable: { multi: true, search: true} ,width: "200px", dataTextField: "name", dataValueField: "id", dataSource: {
                    type: "json",
                    transport: {
                        read: {
                            url: '@Url.Action("GetSyncingTennantsJsn", "dB")',
                            data: { type: ##I want to pass 'type' value for this row## }
                            }
                    }
                }
            },
            { field: "folder", title: "Folder" },

Many thanks!

Rob

I have two Kendo Schedulers. In the first one the WorkDayStart and WorkDayEnd should be custom to the day(s) being viewed. They are not static at one single time. If I am viewing one single day, I am sure I could inject some Javascript to find these and update them, then rerender the scheduler. But when viewing a week that would not help. Really they need to be a function. Is this possible?

The second scheduler is grouped by a resource of an Employee. So in this case it is more complicated. I have this one locked down to viewing only a single day view (or other views that don't include slots that may be closed like Agenda). But the columns here are dependent on the employee's availability for the day selected. So again a function is needed.

Alternatively, digging in the kendo.all.js, I see a property called "slotTemplate" but this doesn't seem to be exposed in MVC. Is there a workaround using this?

[EDIT]: I finally found the SlotTemplate as part of the views in MVC. Will play around here and possibly I can solve this on my own.

[EDIT 2]: I did get SlotTemplate working, but the real solution is to fix the WorkDayStart and WorkDayEnd. Let's say this is a program for a store. Bob logs in. Bob sees his own schedule on one tab, and the store schedule on another tab. Bob works different hours per day. The store is open different hours per day. It's not always the same. When viewing a week we need to be expanded to the most open day. When viewing a single day we should match that day.

Here's a SlotTemplate tagged in CSHTML:

views.DayView(v => v.Selected(true)).SlotTemplateId("shopSlotTemplate");

<script id="mySlotTemplate" type="text/x-kendo-template">
   #= getSlotTemplate(data, @loggedInEmployeeId) #
</script>

<script id="shopSlotTemplate" type="text/x-kendo-template">
   #= getSlotTemplate(data) #
</script>

<script id="acSlotTemplate" type="text/x-kendo-template">
   #= getSlotTemplate(data, 0) #
</script>

function getSlotTemplate(data, employeeId) {

   // Get employee ID if not passed in. If still not found then this scheduler is not grouped this way.
   if (employeeId === undefined) {
      employeeId = data.resources().EmployeeId;
   }

   let isClosed = isShopClosed(shopSchedule.Shop, data.date);

   if ((!isClosed) && (employeeId > 0) && (shopSchedule["Employee" + employeeId] !== undefined)) {
      isClosed = isShopClosed(shopSchedule["Employee" + employeeId], data.date);
   }

   return "<div class=\"" + (isClosed ? "k-nonwork-hour" : "") + "\">&nbsp;</div>";
}

This required new CSS since the TD element has margins.

div.k-scheduler-content > table > tbody > tr > td > div {
   margin: -4px -0.5em;
   height: calc(100% + 8px);
   width: calc(100% + 1em);
}

The end result is that the grid for the scheduler appears how I want it.

But working hours are still inaccurate. They are based on a single date and don't change as I move between days.

What is returned in variable grid in following code line?

var grid = $("#GridCompetency0").data("kendoGrid");

How do I use to access the fields of my Model?

I am using it in the following onChange function.

Hi, I want to create a bullet chart in the form of group data and set a unique target data, color, tooltip-template for each bar like "column chart" in picture but I can't find how to bind data for bullet chart 

Is there a way to make the chart look like the example? Please advise if there is a more suitable graph format to display this type of data.

I have a kendo grid with server side paging and client side sorting. while clicking the sort in the grid, data fetch request(Request to fetch data from server) is getting triggered from frontend. but I'm using the client side sorting it shouldn't be the case. Is it possible to restrict it, without calling the server, Sort should be done in the frontend level. I hereby attach the my code sample images for your Reference. Anyone can point me to the right direction? Thanks.