i currently work on a project where i have to write a programm which processes raw data from a Notes Database into an excel file using Lotus Script. The Database contains time information about how long different devices have been lend out. The output from my script looks like this:
| June | |||
|---|---|---|---|
| Device | Counter | Times(Minutes) | Times(Hours) |
| -------- | -------------- | -------------- | -------------- |
| TestDevice1 | 3 | 270 | 4,5 |
| TestDevice2 | 2 | 210 | 3,5 |
I am finished with the programm itself, now i need to have the same Output inside a Lotus notes View. I am very new to lotus notes and i have no idea how to do this. I know that it is possible to use Lotus Formula to programm. But i cant find anything about the language and how to use it. Maybe someone here can help.
You can look at the online documentation provided by HCL "About Designing Views"
Pay particular attention to "Selecting which documents display in a view" and "Creating columns in a view" (and its subsection " Adding programming to columns").
That should give you a few ideas of how to progress.