InViewEditing is a brilliant (and often underutilized) feature in Notes. It allows you to set up a view to be editable in a way that's similar to a spreadsheet, with users tabbing between cells and editing right at the view level, without needing to open a document.

The advantages of InViewEditing are simplicity and performance. The downside is that you cannot rely on the built-in editing of a document that forms give you. With forms, when a user types into a field and saves the document, that value is stored (saved) into that field. When you use InViewEditing, all of this needs to be coded by the developer. In addition, your form events such as PostOpen and QuerySave are not triggered, so any data validation or synchronization, security checks, workflow, and so on will need to be coded explicitly, or else skipped entirely.

Therefore, before you use InViewEditing, you should carefully review your application and your data, and identify cases where being able to edit a handful...