Initialize SharePoint Online List Values in Quick Edit

Question

I'm trying to set default values in a new row of a SharePoint Online list in "Quick Edit" mode using code that looks like the below. The date column works as expected: date value is added but the "Init" and "Project" columns get the value but then behave like there is no value, i.e. I get the message that the fields are required and when I click in them the value disappears.

EntryDateTime, Init, and Project appear to be populated as expected: Try to save the row, and get error that Init and Project are required, although they appear to have values: Have to enter the values again manually to get the row to save:

EntryDateTime is working as expected.

Code:

$( document ).ready(function() {
  var t = setInterval(function() {
  if($("#spgridcontainer_WPQ2_leftpane_mainTable").length) {
    clearInterval(t);

    var d = formatDate(new Date());
    $("#spgridcontainer_WPQ2_leftpane_mainTable tr:last td:eq(1)").text(d);

    $("#spgridcontainer_WPQ2_leftpane_mainTable tr:last td:eq(2)").text("TS");

    $("#spgridcontainer_WPQ2_leftpane_mainTable tr:last td:eq(7)").text("307");
  }
  }, 1000);
});

Answer 1

Have you try with JSLink?? Create a js file with SharePoint Designer, for example on: Style Library/es-es/js/jslink_yourFile.js

Inside of this file write this:

(function () {
    var overrideContext= {};

    overrideContext.Templates = overrideContext.Templates || {};

    overrideContext.Templates.Fields = {
        "your_internal_name_column": {
            "View": setDefaultValue
        }
    };

    SPClientTemplates.TemplateManager.RegisterTemplateOverrides(overrideContext);
})();

function setDefaultValue(ctx) {
    if(ctx.CurrentItem.your_column == "")
        return "your default value";
}

Once the file is written and published, go to the page of the view, edit the page and view the webpart properties (yes the view is a webpart), in the properties look for the section called Miscellaneous, expand it and look for te field JS Link. On that field add the call for you js file like this: ~sitecollection/Style Library/es-es/js/jslink_yourFile.js

This javascript will be executed when you enter on the view form, no matter if it is default view or quick edit mode and will set the value if the column does not have value set it.

According to your answer, quick edit always leave the last tr as new row, so you can get it with JQuery, with this:

$(".ms-listviewgrid tr:last td")

That JQuery will return an array of td's from the last tr of the quick edit grid.

greetings :)