An example of what I mean:
An order form in Notes with five order lines. For each line, there may be five fields that contains information about the order. Making it a total of 25 fields for five order lines.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqMh6dDVGSVg6oGC4MHxLoZRrCagfY9SSN1vBZOOddC5Bk0H_91YWQexlRkz0Rgw56M1WmQzDsGJLJGDNYqYkC-ki0bGe3hORR2ra2k-HbGP9GzUSIjM2Uhs10liI-AbdnORNkGo5fG8th/s1600/ScreenShot001.png)
Traditionally, if you want to show this data in a regular notes view, you have to have a column per field.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6Kt2tM0JwuvnbA2-a3U-_pwVI_VjMUq67vrQnB7u1UoBFKio0DjGQoR8PaQJ48KMzGmu3bsCpsvOYlNwMdDnpc7qO_b8Fgc59JlBIYCCdHQF-bGaiZPMH2rwPkIAI5jvQlFtkanPWN-zH/s400/ScreenShot002.png)
Thanks to the way the index is organized in a Notes view, you can show this data vertically using Show multiple values as separate entities.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiie0rP-oKBRcR2p1Qya8ddQjEERUWWYTxIQxPrz5JUqQmip3ZH6g8APjsnEUpcXXjC20Qd1yZsSKeUZ29YzMWQ5JpWorrlBslIBV_wbxWmOhQuWQyMfNLLUiAkknUYu6cd-v7KSkDDHVJa/s1600/ScreenShot004.png)
A summary of the technique:
- In each column, create a list of the field values that you want to show
- Each column list has to have equal amount of values
- Each column has to have Show multiple.. property enabled
- Only the first column can be sorted (it can be categorized), or you end up with a lot of rows.
This is probably due to how the index is organized/matching of multiple values
Here's the demoapp I took the screenshots from:
>> Download
Take a look at the Vertical view to see the technique I used.
Thanks to this technique, I can simply pull the data from a view using view entries/column values/send row by row to a stored procedure in SQL. The alternative would be to write code for each field.
Share and enjoy! :)