There is a form with a submit button. I can set out any criteria and if i click on the submit button, the page will go to a view with the search results. I have this "Export to Excel" link which will initiate the export agent written in LotusScript and the data in the page is exported to an excel sheet.
The prob comes when a new field which is a text list needs to be introduced in the export sheet. Only the first value in the field gets exported. Ineed to export the whole set of values to the excel sheet.
I used the following code:
If (doctemp.HasItem("CCTSector") And doctemp.CCTSector(0) <> "") Then
supportteam = doctemp.CCTSector(0)
supportteam = ""
Here CCTSector is the list field. And support team is the variable that will be exported to excel.
Thanks in advance!!