Hi, I need to throw an error if certain values are not true. The values are in a different list so I am doing the code like this fd.spBeforeSave(function () { var id = fd.field('ID').value; var length = 0; var string = "Bid_x0020_Line_x0020_ID eq " + id + " and Submit ne false"; sp.web.lists…

Hello @Ramiz , To update a field on the form, you need to add code outside of asynchronous function like this: fd.spBeforeSave(function (){ pnp.sp.web.lists.getByTitle('ListName').items.get().then(function(items){ length = items.length; return length; }).then(function(leng…

Hi @Margo I tried this but in any case I am receiving the error message. Kindly see the attach image and my code. var length = 0; var string = "Bid_x0020_Line_x0020_ID eq " + id + " and Submit ne false"; fd.validators; fd.validators.push( { name: 'SubmissionValidator', error: "Please su…

@Ramiz , Please try out this code instead: var length = 0; var string = "Bid_x0020_Line_x0020_ID eq " + id + " and Submit ne false"; pnp.sp.web.lists.getByTitle("Bid Type Lines").items.filter(string).get().then(function(items) { length = items.length; return length; }).then(function(leng…

Hi @Margo Thank you for your help. This code works fine but this doesnt refresh since the pnp code is on spRendered it works when I open the form. After opening the form If I receive the error and I fixed by submitting all documents which is a list or library control the length variable still conta…

Hello @Ramiz , Are you using List or Library control for displaying all related items from the Bid Type Lines list? Then you can add validation based on the List or Library control values.

Hi @Margo Yes I am using the list or library control to display related items. Add validation based on list or library control means add event function on list or library control like this fd.control('SPDataTable0').$on('change', function(changeData) or fdfd.control('SPDataTable0').validator?

@Ramiz , You can add validator that checks the length (count of records) of the List or Library control, for instance: fd.spRendered(function() { fd.validators; fd.validators.push({ name: 'SPDataTable validator', error: 'Error message', validate: function() { if (fd.contro…

Hi @Margo Thanks for the help. You did mention above to assign/update value we need to add code outside of asynchronous function lines.items.filter(myfilter).get().then(function(items) { alert(items.length); no = items[0].Title; return no; }).then(function(no) { fd.field('Title').v…

Hello @Ramiz , Under which event are you running the code? spBeforeSave or spRendered?

I am running under spBeforeSave.

Throw Error on SpBeforeSave

Forms

Margo (Margo) October 29, 2020, 6:57pm 14

Hello @Ramiz,

You can run PnP request under spSaved event to update the Reference number column. Please see the code example in this post:

And then redirect the user to the edit form: