Hi all, we have grid components in our forms. as you know, if grid has

i'm using Appian6.71.
it seems it is different from what you said.it will validate the whole column.
maybe my JS code is not corrent.my current logic is if any cell in one column is invalid,then the field is invalid.
could you please take a look at it?

//this function is supposed to validate lenth
//both ordinary text field and grid text field.
function checkFieldLength(fieldId,length,isGrid){
          var value = window.FormAPI.getValue(fieldId).id.trim();
          
          //is grid field
          if(isGrid){
                    //value of grid field contains multiple values which are joined by ";"
                    var valueArr = value.split(";");
                    for(var i=0;i<valueArr.length;i++){
                              valueArr[i] = valueArr[i].trim();
                              
                              //return false if any cell in the column is invalid
                              if(valueArr[i] && valueArr[i].length > length){
                                        return false;
                              }
                    }
          }else{
                    if(value && value.length > length){
                              return false;
                    }
          }

          return true;
}

i'm using Appian6.71.
it seems it is different from what you said.it will validate the whole column.
maybe my JS code is not corrent.my current logic is if any cell in one column is invalid,then the field is invalid.
could you please take a look at it?

//this function is supposed to validate lenth
//both ordinary text field and grid text field.
function checkFieldLength(fieldId,length,isGrid){
          var value = window.FormAPI.getValue(fieldId).id.trim();
          
          //is grid field
          if(isGrid){
                    //value of grid field contains multiple values which are joined by ";"
                    var valueArr = value.split(";");
                    for(var i=0;i<valueArr.length;i++){
                              valueArr[i] = valueArr[i].trim();
                              
                              //return false if any cell in the column is invalid
                              if(valueArr[i] && valueArr[i].length > length){
                                        return false;
                              }
                    }
          }else{
                    if(value && value.length > length){
                              return false;
                    }
          }

          return true;
}