When a RECORD of a data source is modified, errors can occur. Network failures, INSUFFICIENT permissions, and edit conflicts are all possibilities.

The Patch and other data functions do not return errors DIRECTLY. They instead return the outcome of their operation. You can use the Errors function to get the details of any errors that occur after a data function has been completed. The [IsEmpty] function in the formula IsEmpty( Errors (...) ) can be used to check for errors. Using the Validate and DataSourceInfo functions, you can prevent some mistakes from occurring. For additional information on how to work with and avoid errors, see Working with Data Sources.

The Errors function returns a table of errors with the columns listed below:

• Record: The data source record that included the error. This field will be blank if the mistake occurred during the record creation process.
• COLUMN: If the issue can be traced back to a single column, here is the column that caused it. Otherwise, this will be left blank.
• Message: An explanation of the problem. For the end-user, this error string can be displayed. Be aware that the data source may generate this message, which may be long and contain raw column names that the user may not understand.
• Error: An error code that can be used in formulas to assist in the resolution of the problem. Syntax: Errors( DataSource [, Record ] )
• DataSource: This is a must-have. The data source for which you'd like to get error messages.
• Record: It is optional. You wish to return errors for a specific record. If this PARAMETER is omitted, the function will return errors for the full data source.