Does anyone faced infinite loop when you use valid...
# suitescriptb
Boris Yasen
09/01/2023, 3:09 PMDoes anyone faced infinite loop when you use validateField in client script please?
c
Clay Roper
09/01/2023, 3:11 PMAre you editing the field that's being validated? Consider setting a flag of some kind in the browser window to provide an exit
b
Boris Yasen
09/01/2023, 3:12 PM@Clay Roper could you elaborate a little more please?
c
Clay Roper
09/01/2023, 3:13 PM@Boris Yasen I'd be happy to; it would be best to do so with the context of your code. Can you add a snippet here with the text of your function as it stands?
b
Boris Yasen
09/01/2023, 3:14 PMIt's just simple as this
Copy code
if(scriptContext.fieldId == "custpage_end_date"){
dialog.alert({
title: 'You can\'t edit End date',
message: 'It\'s already started'
});
return false;
}
return true;Boris Yasen
09/01/2023, 3:15 PMActually it's a sublist column field, not the header field
Boris Yasen
09/01/2023, 3:15 PMso I don't want user to be able to edit that specific line column
Boris Yasen
09/01/2023, 3:16 PMso if he is trying to edit it, I'm throwing an error
a
Anthony OConnor
09/01/2023, 3:16 PMare you wanting to prevent them doing that based on something else they already did in the client context?
c
Clay Roper
09/01/2023, 3:17 PM@Boris Yasen Have you tried disabling the field?
b
Boris Yasen
09/01/2023, 3:17 PMthe issue is only for some lines
Boris Yasen
09/01/2023, 3:17 PMnot all sublist
👍 1
Boris Yasen
09/01/2023, 3:17 PMYes @Anthony OConnor
c
Clay Roper
09/01/2023, 3:18 PM@Boris Yasen You can disable the field dynamically in lineInit based on your business logic
b
Boris Yasen
09/01/2023, 3:19 PMcould you send me the code snippet for that please?
Boris Yasen
09/01/2023, 3:19 PMI didn't know it's possible
Boris Yasen
09/01/2023, 3:20 PMSo let's say sublist has 3 rows and 3 columns.
I want to disable 1st row 2nd column and 3rd row 3rd column?
e
Edgar Valdes
09/01/2023, 3:37 PMWhat are the criteria for rows? Always disable the first or when a condition is met?
s
Shawn Talbert
09/01/2023, 3:45 PMan easy infinite loop solution is something like
_.debounce()c
Clay Roper
09/01/2023, 3:50 PMTry something like this.
Clay Roper
09/01/2023, 3:50 PM@Boris Yasen You would manage the disabling each time a line is selected, thus the usage of lineInit
b
Boris Yasen
09/01/2023, 4:00 PMThank you
c
Clay Roper
09/01/2023, 4:01 PM@Boris Yasen One thing to note that I'm dealing with at the moment: Purchase Order item lines can fight your efforts to manage the fields, maybe only if you have the Purchase Contracts feature enabled.
b
Boris Yasen
09/01/2023, 4:02 PMCan I disable the column based on same row value in lineInit?
c
Clay Roper
09/01/2023, 4:04 PMYou mean select the value of a field on the line being selected then disable the field according to that value or logic derived from that value? You should be able to do so with
rec.getCurrentSublistValue()b
Boris Yasen
09/01/2023, 4:30 PMSorry but it changed all rows, not only one certain row
c
Clay Roper
09/01/2023, 4:30 PM@Boris Yasen Can you share your code?
b
Boris Yasen
09/01/2023, 4:32 PM Copy code
function lineInit(scriptContext){
if(scriptContext.currentRecord.getValue('custpage_hidden_is_fully_loaded') && scriptContext.currentRecord.getLineCount({sublistId: 'custpage_lines'}) > 0){
if(scriptContext.sublistId == "custpage_lines"){
let LineStatus = scriptContext.currentRecord.getCurrentSublistValue({
sublistId: 'custpage_lines',
fieldId: 'custpage_line_status'
});
console.log('lineInit', LineStatus);
if(LineStatus == 1){
const { currentRecord: rec, sublistId } = scriptContext;
const line = rec.getCurrentSublistIndex({ sublistId });
console.log('line');
rec.getSublistField({
fieldId: "custpage_line_end_date",
sublistId,
line
}).isDisabled = true;
}else{
const { currentRecord: rec, sublistId } = scriptContext;
const line = rec.getCurrentSublistIndex({ sublistId });
console.log('line');
rec.getSublistField({
fieldId: "custpage_line_end_date",
sublistId,
line
}).isDisabled = false;
}
}
}
}c
Clay Roper
09/01/2023, 4:34 PM@Boris Yasen Are you saying that every line you select has this field disabled?
b
Boris Yasen
09/01/2023, 4:34 PMyes
c
Clay Roper
09/01/2023, 4:34 PMEven when LineStatus !== 1?
b
Boris Yasen
09/01/2023, 4:34 PMyes
c
Clay Roper
09/01/2023, 4:35 PMCan you console.log from inside both branches of the if/else?
b
Boris Yasen
09/01/2023, 4:35 PMI tried and it returned correct value
Boris Yasen
09/01/2023, 4:35 PM2 or 1
Boris Yasen
09/01/2023, 4:35 PMbut always disabled
c
Clay Roper
09/01/2023, 4:36 PMIf you log from both branches of the if/else, we can ensure it's reaching the right branch
s
Shawn Talbert
09/01/2023, 5:20 PMSorry I'm not entirely following along, but AFAIK you can only disable columns - you can't disable individual cells.
c
Clay Roper
09/01/2023, 5:28 PM@Shawn Talbert Correct, but the column is only represented on a line by line basis, so you can manage it when the line is selected.
Clay Roper
09/01/2023, 6:02 PM@Boris Yasen I've deployed this to Sales Orders and am seeing it function as expected -- lines with a quantity higher than 10 when selected disable the description field; otherwise, it's enabled.
Clay Roper
09/01/2023, 6:03 PM@Shawn Talbert See the snippet above.
@Boris Yasen this method of disabling fields may not work for all field types; in those cases, you can perform a hack with jQuery
s
Shawn Talbert
09/01/2023, 6:31 PMThat does disable it for the entire column right? You're just saying that doesn't matter because the user is focused on a single line at a time?
c
Clay Roper
09/01/2023, 6:35 PMI don't know that we can even really speak about it being disabled for the whole column when the only way to interact with a given field is one line at a time. It might be different if I was addressing the column, but I haven't worked with Columns in that way to be able to say.
8 Views