List and library control prepopulate data

[Rinu (kannan)]

Hello,

In one of the list and library control it is mandatory to enter certain number of records to be entered. currently users are entering the details one by one. Is there a way we can prepopulate the list items at the time of form load?

1. I was wondering if there is a way on form load to add all these values by default to make things easier, rather than add new items each time when the user opens up the form. If on form load all the list items are already added, users will just have to edit to make changes and submit.

2. Also is there a way to color code a Colum based on field value in list or library control?

3. Is there a way for fields such as comments and Recommendation to be rich text when I tried to change the type of these fields to rich text the field gets disabled and i am not able add/edit in the list and library control.

Please see my attempt.
fd.spRendered(function () {

    var list = pnp.sp.web.lists.getByTitle("mylist");
   
		list.items.add({
                RFP: "sometext",
                Risk: "", 
                Comment: "sometext",
                Recommendation: "some text"
                //LookupID: fd.field('ID').value
		}).then(function(){
    		fd.control('SPDataTable1').refresh();
	});
});

the items gets added to the list but not in 'SPDataTable1'

[Margo]

Hello @Rinu,

1. Yes, and the code that you've shared is valid.
   Are you using this code in a New Form?
   This is not the best approach, that may cause the creation of multiple unwanted records. You can make users to fill out basic information and save the item. When the item is saved, redirect to edit form and create child records on load of the edit form.

2. You can customize view of columns in List or Library control, please find the example here.

3. Rich text columns are disabled in inline editing mode. You can switch to dialog editing mode to work with all fields.

[Rinu (kannan)]

Hi Mnikitina,

@Margo

Are you using this code in a New Form?

no, I am using the code in the edit form. In this particular case the data is not entered via form we have provisioned it via flow to the list, users will only edit the list item.
2nd question for customizing column it is not working, please see the code below.

fd.control('SPDataTable1').templates = {
PercentComplete: function(ctx) {
var value = ctx.row.Risk;
if (!value) {
return '';
}
if (value == "No risk item"){
return '' + value + '';
}
if (value == "Low risk/potential risk item"){
return '' + value + '';
}
if (value == "High risk item"){
return '' + value + '';
}
}
}
for the 3rd question as soon as the "Add new button" or "Edit" button is clicked it gets redirected to the list form associated with the list and library control (not staying with the current form). Before we just had to change the editing property to "Dialog". to make it work.

[Margo]

@Rinu,

1. I suppose that the view is filtered by the lookup field. You need to populate the lookup that binds parent and child with the current item id:

var list = pnp.sp.web.lists.getByTitle("mylist");
   
		list.items.add({
                RFP: "sometext",
                Risk: "", 
                Comment: "sometext",
                Recommendation: "some text",
                //populate lookup with the parent item ID
                LookupID: fd.itemId
		}).then(function(){
    		fd.control('SPDataTable1').refresh();
	});

2. Are you getting any errors in the browser console?

3. Have you customized the buttons of the List or Library control?

[Rinu (kannan)]

Thanks for the reply,

I managed the 1st with flow. but 2nd and 3 issue still remains the same.

2. there is no error on the browser control Please see the code below

   fd.spRendered(function() {
   fd.control('SPDataTable1').templates = {
   PercentComplete: function(ctx) {
   var value = ctx.row.Risk;
   if (!value) {
   return '';
   }
   if (value == "No risk item"){
   alert(1);
   return '' + value + '';
   }
   if (value == "Low risk/potential risk item"){
   return '' + value + '';
   }
   if (value == "High risk item"){
   return '' + value + '';
   }
   }
   }
   })

3. I have disabled the customizations the issue still remains. it works as expected in google chrome, but not in edge.

[Margo]

@Rinu,

You need to replace PercentComplete with the internal name of the column that you want to customize.

@Rinu

PercentComplete: function(ctx) {

I couldn't reproduce the issue with the List or Libary control on my form. Could you please share the screenshot of the control setting and share the screenshot of the form behavior in Edge.
Also, are you getting any errors in the browser console when clicking Add new item or Edit buttons?

[Rinu (kannan)]

Hi Mnikitina,

please see the screen shot below.

[Margo]

@Rinu,

Are you getting any errors in the browser console (F12) when clicking the 'New Item' button ?

Filter messages to show errors only, and share the screenshot of all errors in the console.

What version of the desktop designer are you using? You can find it at the top left of the designer.

Please also check the version of the app package. Open developer tools (F12) >> Source >> Page >> forms.plumsail.com.

The latest version is 1.0.8. If you are using the outdated version, please follow the instructions on how to Update the app package.

[Rinu (kannan)]

Hi Mnikitina,

It got fixed itself without making any changes, It works on both edge and chrome.
Before it was only working on chrome.