A row condition is used to define whether data in the child fields should be imported based on a Boolean expression. Any OpenGround expression can be used here as long as it returns a True or False value.

In the below example, a row condition has been setup to check that the HOLE_ID (LocationDetails.LocationID in OpenGround) is one of the locations selected for import. This prevents orphan records being added to the system or at least prevents OpenGround from attempting to import incorrect data.

It is possible to combine multiple expressions into one to return a final true or false value. For example, in the below image, both the HOLE_ID being valid and the IOBS_LEVL must have a record for any data to be added.

It is also possible to use an OR expression if required to include the data if any of the conditions are met.

It is also possible to define whether the data should be merged if conflicting data is found using Merge, Safe-Merge or Merge-Only. More information on these are found in the sections below.