IsNewRow

The IsNewRow() function returns a boolean value that indicates if the specified row is newly created and not yet saved to the database.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns true if the specified row is not yet saved to the database. Returns false if the specified row is already saved to the database.

• If the parameter is a list, then the current row of the list is taken.

• If the parameter is a reference, then the referenced row is taken.

Syntax

IsNewRow(list)

IsNewRow( [Users] ) => yes - when a new row has been created and not yet saved

IsNewRow( [Products] ) => no - when there is no new row created in current session.

IsNewRow(reference)

IsNewRow( [CurrentUser-Reference] ) => yes - when the current user reference field is pointing to a row which has just been created and not yet saved

IsNewRow( [CurrentProduct-Reference] ) => no - when the current product reference field is pointing to a row which has been saved or retrieved from the database (previously saved).

Parameters

Name	Type	Required	Description
list	list	☑️	a database list
reference	reference	☑️	a reference to a row of a database list