Skip to main content
shubhama926776
Brainy
Aug 18, 2021 1:45 PM UTC
Solved

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

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

Is that possible?

    shubhama926776
    Brainy
    Aug 19, 2021 4:44 AM UTC

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

    शुभम्

    7 replies

    dastagirid756
    Participating Frequently
    Aug 18, 2021 2:05 PM UTC

    [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
    Aug 19, 2021 4:44 AM UTC

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

    शुभम्
    dastagirid756
    Participating Frequently
    Aug 19, 2021 4:53 AM UTC

    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",""))