Why do you want to select only certain data from a source?
Oftentimes, you have no control over the content of the source. You have access to it, but no ability to dictate content. The source, therefore, contains records you do not want to move to Notes. Use the Notes Formula section of the form to pick only certain records from the source.
How it Works
In the Notes Formula section, enter any Notes formula. For example, if your source contains all customer in the United States, but you only are interested in those in New Jersey, type the following: Notes Formula: Select CustomerState = "New Jersey"
Note: If you want to Select every record from the source, type Select @All in the Selection Formula section of the form.
Using Notes Select statement (instead of SQL Select)
If you are uncomfortable with SQL syntax, but are comfortable with the Notes syntax, you could leave the SQL Select Statement section blank and use the Notes formula Select CompanyCity = "Boston" instead of the familiar Select @All . This will move more data across the network, but the Sentinel will discard all but that data that fits the Notes Select statement.