Short Answer: If you have a Default Value on the Control in addition to Min / Max Value Validation set via the Control's Settings, you're going to run into trouble.
Removing the Default Value should fix things.
If that is not the case, please show us the setup of your Controls, or just export and attach the form here to the forum so that we can take a look at it.
However, if this does solve the problem, and either you or someone else wants the Long Answer as to why this is happening, I'll gladly type it up... just know that it's going to be long and silly.
Thank you for the reply.
Unfortunately, I'm not using the Default Value in this case. As you can see, I just give a name and select "Decimal" as Data Type.
On the calculated field side, I just give a name and some basic function :
calTotalRow = input1 * input2
calSumRows = sum(calTotalRow)
Here is an extra.
I realize when I'm clik on "add new row" I can see an error on my Browser Console tab
I'm missing something a guess.
Here the code (3145) wich is concerned
Ah, well I see.
Then you're running into one of the other strange problems with Classic Forms...
Sometimes the NF.BaseDataAccessHelper just refuses to load and there doesn't seem to be a rhyme or reason as to why it happens...
However, there is a fix that I made and have been using internally:
NWF.FormFiller.Events.RegisterBeforeReady(function () {
"use strict";
if (NF.BaseDataAccessHelper === undefined) {
try {
console.log("Attempting to load missing js file: 'NF.BaseDataAccessHelper.js'");
NWF$.getScript(_spPageContextInfo.siteAbsoluteUrl.replace(/sites.+/, "") + _spPageContextInfo.layoutsUrl + "/NintexForms/JavaScriptStringHandler.ashx?" + "resourceType=jsfile&" + "fileName=NF.BaseDataAccessHelper.js&" + "culture=" + _spPageContextInfo.currentCultureName);
} catch (e) {
console.log("There was a problem grabbing the BaseDataAccessHelper using the JavaScriptStringHandler!");
console.log(e);
}
}
});
That should do it for you. But if you're having problems, I recommend just opening the console and playing with the jQuery.getScript() function directly. The string fed into it should resolve to something along the lines of:
"http://webApplicationURL/_layouts/15/NintexForms/JavaScriptStringHandler.ashx?resourceType=jsfile&fileName=NF.BaseDataAccessHelper.js&culture=en-US"
So if that combo of "_spPageContextInfo" stuffs isn't generating a string like that, then just try manually inputting it and then rewriting it for your own environment (being that I do not know how your environment is setup!).
I hope that this solves your problem!
Great! the fix is working. thank you N M.
I was forced, however, to adapt the script. I'm wondering why the shared code don't work such as ?
See below my modification. I was unable to use the trigger NWF.FormFiller.Events.RegisterBeforeReady
and with the jQuery.getScript()
function "_spPageContextInfo"
doesn't generate the string. So I input it manually.
NWF$(document).ready(function(){
NWF.FormFiller.Events.RegisterAfterReady(function () {
"use strict";
if (NF.BaseDataAccessHelper === undefined) {
try {
console.log("Attempting to load missing js file: 'NF.BaseDataAccessHelper.js'");
NWF$.getScript("https://myWebApplicationURL/_layouts/15/NintexForms/JavaScriptStringHandler.ashx?resourceType=jsfile&fileName=NF.BaseDataAccessHelper.js&culture=en-US");
} catch (e) {
console.log("There was a problem grabbing the BaseDataAccessHelper using the JavaScriptStringHandler!");
console.log(e);
}
}
});
});
One more time, thank you
Lino
I am incredibly happy that it works, and am also perplexed as to why the _spPageContextInfo isn't working in your environment, being that it should be a native part of SharePoint (as far as I know: _spPageContextInfo in SharePoint 2016).
In fact, if you were to open up your chrome dev console and type it in, it should be available to you on every page (including forms)! If it isn't... maybe that's indicative of something? I dunno! But it might be a fun thing to explore!