Home > IT Answers > Lotus Domino > Can you show lotus notes table rows as rows i...
Penguins
10 pts.
 Can you show lotus notes table rows as rows in a view?
Lotus Notes 8.5.3, Lotus Notes, Microsoft Excel
I have a table with 5 columns. Each row as 5 fields.
first row, Field A, Field B, Field C, etc
second row, Field X, Field Y, Field Z, etc
I need to be able to show the table rows as as rows in a view to export to excel. I have tried using a lot of formula language in column formulas and it is not working.
In addition the table that exists in the document needs to show several other fields in the view along

Software/Hardware used:
Lotus Notes 8.5.3
ASKED: Jan 30, 2012  7:37 PM GMT
UPDATED: February 29, 2012  11:55:13 AM GMT
RELATED QUESTIONS
Shivasanjay
520 pts.
Answer Wiki:
Hi, This is not possible in a view column, instead you can open a document in a dialog form ans there you can show the fields in a table., For this you need to program in document open even in a view , when you open a dialog form of your choice where required fields can be show in a table format
Last Wiki Answer Submitted:  Feb 29, 2012  11:55 AM (GMT)  by  Shivasanjay   520 pts.
Latest Answer Wiki Contributors:  MTidmarsh   145 pts., Glory150   2,855 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

There are many ways to export to Excel. I would not try to use a view in Notes, because what you are suggesting is not possible. However, you could use a view in a web browser. To do this, you would add html content in the view columns so that, viewed from a browser, the view contents would become rows. If you know HTML, you can figure that one out.

Otherwise, you could create a lotusscript to export your data to Excel from Notes.

Those are the two solutions I would consider.

Brooklynegg
 3,845 pts.