Validation is not working

Hi Saurav,

If possible can you please share the code snippet here?

I have added validationGroup: "Submit" on submit button and on main form i am calling another mapping grid where i have put validations:--- . Its working n showing red color . AFter on click on submit button page is getting refresh & saving data in DB .

validations: {
rule!validateGrid(
ri!Data[ri!index].oneCell,
ri!Data[ri!index].twoCell
),
if(
contains(
touniformstring(
a!flatten(
{
ri!mapData.twoCell,
remove(
ri!mapData.oneCell,
wherecontains(
ri!Data[ri!index].id,
ri!mapData.id
)
),
ri!mapData.threeCell,
ri!mapData.fourCell
}
)
),
tostring(
ri!Data[ri!index].oneCell
)
),
"This cell is duplicate.",
""
)
},
validationGroup: "Submit",

Hi,
If you are using buttonwidget(), do check if validate: true is set for validationgroup to be considered.
Also, if you have any with() in child rule of mapping grid, try to move it to the main rule.

I cannot move this to main grid.

Hi Saurav,

In the Submit button if you have given skipValidation:true(), it will skip any validation on the form and submit it.

I have just added validationGroup over there. I tried to add same group here also but in that case also its not working.

Could you please paste the code defined in rule!validateGrid?

That is just plane if else condition nothing more than that. Here i have added two validation under one validations tag.

I have used the following code and entered the duplicate celltwo value. 

 

load(
local!isShowWhen: false(),
local!mapData:{{"id":1,"oneCell":"AAA","twoCell":"BBB","threeCell":"CCC","fourCell":"DDD"},{"id":2,"oneCell":"OOO","twoCell":"LLL","threeCell":"KKK","fourCell":"XXX"}},
local!Data:{{"id":1,"oneCell":"PPP","twoCell":"QQQ"},{"id":2,"oneCell":"RRR","twoCell":"SSS"}},
local!index:1,

a!formLayout(
label: "Form",
contents: {
a!gridLayout(
label: "",
emptyGridMessage: "No Records Available",
headerCells: {
a!gridLayoutHeaderCell(
label: "ID",
align: "LEFT"
),
a!gridLayoutHeaderCell(
label: "Cell 1",
align: "LEFT"
),
a!gridLayoutHeaderCell(
label: "Cell 2",
align: "LEFT"
),
a!gridLayoutHeaderCell(
label: "Cell 3",
align: "LEFT"
),
a!gridLayoutHeaderCell(
label: "Cell 4",
align: "LEFT"

)
},
columnConfigs: {
a!gridLayoutColumnConfig(
width: "DISTRIBUTE",
weight: "1"
),
a!gridLayoutColumnConfig(
width: "DISTRIBUTE",
weight: "1"
),
a!gridLayoutColumnConfig(
width: "DISTRIBUTE",
weight: "2"
),
a!gridLayoutColumnConfig(
width: "DISTRIBUTE",
weight: "2"
),
a!gridLayoutColumnConfig(
width: "DISTRIBUTE",
weight: "2"
)
},
rows:
a!forEach(
items:local!mapData,
expression:
{
a!gridRowLayout(
contents: {
a!textField(value:local!mapData[fv!index].id,saveInto:local!mapData[fv!index].id),
a!textField(value:local!mapData[fv!index].oneCell,saveInto:local!mapData[fv!index].oneCell),
a!textField(value:local!mapData[fv!index].twoCell,saveInto:local!mapData[fv!index].twoCell),
a!textField(value:local!mapData[fv!index].threeCell,saveInto:local!mapData[fv!index].threeCell),
a!textField(value:local!mapData[fv!index].fourCell,saveInto:local!mapData[fv!index].fourCell)

}
)
}

)

)
},
validations:if(
contains(
touniformstring(
a!flatten(
{
local!mapData.twoCell,
remove(
local!mapData.oneCell,
wherecontains(
local!Data[local!index].id,
local!mapData.id
)
)
,local!mapData.threeCell,
local!mapData.fourCell
}
)
)
,tostring(
local!Data[local!index].oneCell
)
),
"This cell is duplicate.",
""
),
validationGroup: "Submit",
buttons: a!buttonLayout(
primaryButtons: {
a!buttonWidgetSubmit(
label: "Submit",
validationGroup: "Submit",
style: "PRIMARY"
)
},
secondaryButtons: {}
)

)
)

Output: