Skip to main content
shubhama926776
Brainy
August 18, 2021
Solved

How to display validation in Editable grid when value is null (Without button click)?

  • August 18, 2021
  • 7 replies
  • 1 view

I want to display validation on editable grid when user will make the value as null without clicking on any button.

Is that possible?

    Best answer by shubhama926776

    I want to apply validation for null value.
    I mean when value is null want to show validation.

    7 replies

    dastagirid756
    August 18, 2021

    [mention:d2864f253fd842928dc95575c82dd7f6:e9ed411860ed4f2ba0265705b8793d05] You can add validations to an editable grid at individual row component as well as to an entire grid.

    Please find the working example from the Appian documentation recipe-add-validations-to-an-inline-editable-grid.html

    shubhama926776
    shubhama926776AuthorAnswer
    Brainy
    August 19, 2021

    I want to apply validation for null value.
    I mean when value is null want to show validation.

    शुभम्
    dastagirid756
    August 19, 2021

    Use the below code for null check as per your requirement:

    Null Check for Single Value:

     if(or(isnull(ri!value),ri!value=""),"Please enter value","")

    Null Check for List: 

    Â%A0if(fn!isnull(ri!arrayValues),"Please enter values",if(length(ri!array)=0,"Please enter values",""))