I have a Lotus Script agent that collects values of 10 fields and concatenate them into a text multivalue field - display new line.When viewed with the Lotus Notes client, you can see the values one under the other.
But when viewed in the browser, the values display horizontally and not vertically.
Here is an extract of my code:
Sub Click(Source As Button)
Dim s As New NotesSession
Dim db As NotesDatabase
Dim view As NotesView
Dim doc As NotesDocument
Dim i As Integer
Set db = s.CurrentDatabase
Set view = db.GetView("Dynamic")
Set doc = view.GetFirstDocument
Call getValues(doc)
End Sub
Function getValues(doc)
For i =1 To 25
ii = Cstr(i)
F1= doc.GetItemValue("RM_" & ii)
'Set new fields with values of the old fields
'If old field= Text and = “”, set to “*”, and If old field= Number and = “”, set to -1
If F1(0) = "" Then
‘C1 is a concatenated value collector
If C1 = "" Then
C1= "*"
Else
C1= C1 & Chr(10) &"*"
End If
Else
If C1 = "" Then
C1 = F1(0)
Else
C1 = C1 & Chr(10) & F1(0)
End If
End If
Next
‘Set the new field to the concatenated value
doc.RMTX = C1
End Function
The RMTX field multivalue setttings are:
… Enter: Semicolon and New line
… Display: New line
Any idea ?
TIA