Difference between revisions of "ISNEW"

From AgileApps Support Wiki
imported>Evelyn
m
 
imported>Aeric
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
The ISNEW function determines if data has been added to a text field for the first time. If the field has new data, this function returns TRUE. If the field has not changed, this function returns FALSE.
The ISNEW function determines if the current record is being added. If the record is being added, it returns TRUE. If it is being updated, the function returns FALSE.


;Syntax:
;Syntax:


  ISNEW(field)
  ISNEW()


;Return:TRUE or FALSE
;Return:TRUE or FALSE
Line 9: Line 9:
;Example:
;Example:


  ISNEW(last_name) = TRUE
  IF ( ISNEW() , value-if-true, value-if-false)
<noinclude>


[[Category:Formula Functions]]
[[Category:Formula Functions]]
</noinclude>

Latest revision as of 23:11, 12 April 2012

The ISNEW function determines if the current record is being added. If the record is being added, it returns TRUE. If it is being updated, the function returns FALSE.

Syntax
ISNEW()
Return
TRUE or FALSE
Example
IF ( ISNEW() , value-if-true, value-if-false)