I have a sublist which has 3 columns (name, percen...
# suitescriptb
Boris Yasen
07/10/2023, 5:46 PMI have a sublist which has 3 columns (name, percent, price), a field named "Total" and a field named "Total with Taxes"
Name is string, that price should be total * percent / 100
So if sublist has 3 rows Total with Taxes should be some of Total and that 3 Prices.
However when I try to set Price using ValidatedLine or SublistChanged it throws me an error saying "RangeError Maximum call stack size exceeded".
It looks like because of loop I think. I tried to use "ignoreFieldChange" but it didn't work
Could anyone help on this please?
s
scottvonduhn
07/10/2023, 6:21 PMI don’t think a large loop would affect the call stack (but I’m not sure how the JS to JVM code is transpiled), but it’s not uncommon to have a SuiteScript that can loop on a few thousand search results just fine.
More likely, you have some deep recursion. ignoreFieldChange is just a setting on a SuiteScript API call and will have no impact on the call stack.
Anyway, no code was shared, so there’s really no way anyone here can know what the issue is. You’ll need to provide the relevant part of the script at least.
b
Boris Yasen
07/10/2023, 6:22 PMYes I mean to say deep recursion
s
Shawn Talbert
07/10/2023, 7:43 PMif you can't easily prevent your function from being called by NS many times, you can try using
_.debounce()n
NickSuite
07/10/2023, 8:05 PMI would say something is wrong with your script. It's getting stuck in a loop of validateField/ValidateLine and that's why throwing the range error.
Share your code.
s
scottvonduhn
07/10/2023, 8:47 PMI can’t really think of a reason why you’d need a recursive (and especially not a deeply recursive) function in most SuiteScripts, though possibly a third party library might make use of them. Usually you would use iterators & callback functions or a loop (do, while, for) to go through each line. Again, you’d have to provide the code, as there’s no way to troubleshoot based on on the error message alone.
s
Shawn Talbert
07/10/2023, 9:50 PMthe recursion is not likely end-user code - more like NS calling the entrypoint repeatedly. If that happens when it seems it shouldn't, _.debounce() is an easy get-out-of-jail-free card.
b
battk
07/11/2023, 12:47 AMnothing that you shared looks like it could cause recursion, which probably means the problem is elsewhere
battk
07/11/2023, 12:47 AMthe logic within your for loop doesnt actually commit anything
battk
07/11/2023, 12:48 AMso the validateLine shouldnt come into play
battk
07/11/2023, 12:49 AMthat means that either
Copy code
form.selectLine({
sublistId: "custpage_fee_lines",
line: i,
});battk
07/11/2023, 12:51 AMor
Copy code
form.setCurrentSublistValue({
sublistId: "custpage_fee_lines",
fieldId: "custcol_fee_calced",
line: i,
value: rate * Amount * Price,
});battk
07/11/2023, 12:52 AMor the more unlikely
Copy code
form.setValue("custpage_price_per_gallon", total / Amount);
form.setValue("custpage_total_with_tax", total);2 Views