I've been "hacking" at some of the features of A5V8 just to see how some things work and how far I could push the envelope on many functions that are "right in front of our faces".
I don't know whether the below has been exposed before but I found it important enough to share for those who just might be at "THAT POINT" in their app development to make good use of what I'm going to explain.
I wanted a way to display data in a field that may be blank during Grid update, in essence creating a DEFAULT value. I've only tried this in a Columnar grid but I suspect it will work in other places also.
If you enter in the below in the "Display format" property for a field, you may benefit from being able to easily display "alternate" data. Below are three examples, one
for each data type of Character, Date and Numeric.
iif(len(trim(<value>)) > 0,<value>,"no entry yet")
iif((<value>)> ctod("11/11/1111") ,<value>,date()+30 )
iif((<value>)> 0 ,<value>, 5 * 22 )
I'll explain just the first of the three here:
It says "If the length of the current field value is greater than zero, then print the field value, otherwise enter 'no entry yet' into the blank field.
Basically this iif() functionality says that if the first parameter is true, then print the next parameter,otherwise print the last parameter.
You must create your own ligitimate logical conditions but the above should get you well on your way. What I find nice about this is if you structure your condition(s) well, you'll automatically save the inserted data the next time you click submit.
I don't know whether the below has been exposed before but I found it important enough to share for those who just might be at "THAT POINT" in their app development to make good use of what I'm going to explain.
I wanted a way to display data in a field that may be blank during Grid update, in essence creating a DEFAULT value. I've only tried this in a Columnar grid but I suspect it will work in other places also.
If you enter in the below in the "Display format" property for a field, you may benefit from being able to easily display "alternate" data. Below are three examples, one
for each data type of Character, Date and Numeric.
iif(len(trim(<value>)) > 0,<value>,"no entry yet")
iif((<value>)> ctod("11/11/1111") ,<value>,date()+30 )
iif((<value>)> 0 ,<value>, 5 * 22 )
I'll explain just the first of the three here:
It says "If the length of the current field value is greater than zero, then print the field value, otherwise enter 'no entry yet' into the blank field.
Basically this iif() functionality says that if the first parameter is true, then print the next parameter,otherwise print the last parameter.
You must create your own ligitimate logical conditions but the above should get you well on your way. What I find nice about this is if you structure your condition(s) well, you'll automatically save the inserted data the next time you click submit.
Comment