What’s Notes Function – Version Technical
Everyone know Lotus Notes is a database system but most Notes environments consist of a collection of databases that might interact with each other at some level. Lotus Notes is not a relational database system. A Notes database is a collection of unstructured data, combined with various design elements that allow you to access and manipulate that data.
A Form allows a user to view or manipulate the data fields of a given record in the database. Lotus Notes format is quite customizable in terms of colors, fonts, and layout. However, the Form does not actually hold the data itself.
Another interesting aspect of the Notes data store is that the data fields are not strongly typed. In other words, even though you initially set up a field as a numeric field, you can later add text data to that field (if you modify your Form or add data programmatically). In this way the data fields are more like columns in a spreadsheet than columns in a table. In a spreadsheet, you might be able to store dates, numbers, text, and objects all in a single column. Notes is the same way. A field can even hold items such as file attachments or OLE links.
While all this seems to be a terrible “loose” approach to processing data, in fact, more likely to develop and update applications. If you need to form a new field, you just add them. If you need a whole new group of the formation of a new field, you can simply add it also. If you need to change the numeric field in the text box months later, database development, you can change it does not [necessarily] worry about old data. You do not know anything about tables and data normalization and relational database theory,Lotus Notes handles everything internally.
Anyway, now that you’ve started storing data in the internal table, you’ll want to start viewing it as well. In the relational database world, you’d normally write a query to filter and sort your information; in Notes terms, you create a View.
A View is a tabular presentation of a filtered subset of data in the internal table. You define not only the filter that you want to apply (like “all records that were created using the ‘Car Data’ form”), but also the individual fields that you want to display in columns, and the way that the data is categorized and sorted. You can even add programmatic columns to the View, to display conditional data, totals, sums, or many other manipulated versions of the data in the fields.
Viewed 12054 times by 4272 viewers
