ws.Pickliststrings question

HCL Domino Domino Forum
1

I have a LS Picklist. It gets the first column value in the view, Location. The second column in the view is city. When the user selects a Location, I need to grab the City too so I can throw it into the new doc that the LS creates. Does anyone know how to capture the second value once the user uses the picklist? Thanks!

picklist = ws.Pickliststrings(3,1,server,dbname,viewname, “Location”,“Select a Location.”,1,“”)

If Isempty(picklist) Then Exit Sub 'they have pressed cancel

location = picklist(0)
2

Subject: ws.Pickliststrings question

Add another (hidden) column to the view with the location + delimiter + city as the formula - eg Location + “|||” + City - then just split them afterwards.

3

Subject: RE: ws.Pickliststrings question

Thanks. I should have known that. I did this in formula language. Still learning LS… :O(