I'm making an interface form with Appian. I'm making the form interactive. A textbox should only appear when specific variables are true. Appian offers a wonderful feature for this where you can add an expression to a "only show when" function.
It presently holds the following expression:
edate(today(), -804) >= ri!GeboorteDatum
The variable on the form is ri!geboortedatum.
Another statement that says: only show when the date value is not null is required. I tried everything but nothing worked. Is there a solution? The programming language appears to be similar to Microsoft Excel.
Perhaps something like
edate(today(), -804) >= ri!GeboorteDatum & isnull(ri!Geboortedatum)
Discussion posts and replies are publicly visible
You can wrap both expressions in and()
I think you will be needing not null function instead of isnull()
like:
and( edate(today(), - 804) >= ri!GeboorteDatum, a!isNotNullOrEmpty(ri!Geboortedatum) )
Hi, to check values are not null you can use isNotNullOrEmpty
Try to use the below code in your show when condition
and( edate(today(), - 804) >= ri!GeboorteDatum, a!isNotNullOrEmpty(ri!GeboorteDatum) )
Thank you for that
The ampersand character "&" is used to concatenate strings in Appian. Use the functions and() or or() to build logical expressions.