I have a form where the user can select a name from a list to assign a task to. I use a picklist and populate the AssignedTo field with the result from the picklist. This has worked fine however I now need to get two names from the picklist: the assigness and the backup assignee (lets say columns 2 and 3 from the picklist view). Can I do this? This is an example of my code:
stringArray = ws.PickListStrings( _
PICKLIST_CUSTOM, _
False, _
"MYSERVER", _
"FOLDER\\SubFolder\\Database", _
"Picklist View", _
"Select the assignee", _
"Please select a user to assign this to.", _
2, _
"Assigner" )
make a second field for the backups, and do another picklist to extract them. be sure to detail the dialog boxes indicating to the user who they are supposed to be extracting…
I want the backup be be hard coded so that when the assignee is choosen the name of the backup is brought over too. In other words I don’t want a second dialog box to pop up asking for a backup to be selected. Is there any way to bring over two field values using one picklist?
Is the items you are trying to get within the same document (ie 1 row on the view), or are there 2 docs you have to select in order to get the values?? Also, do you have to use LS to do this, there are some good stuff using dblookup to get your things, especially if the view you have contains all of the info you need to get.
The fields would be say the 2nd and third column from the same document in a view. I am using Lotus Script and it would be too time consuming to redeign the whole action.
Try using PickListCollection instead – then you can pull out all the field values you want from the selected document. Or, add a hidden column to the view that contains both values in a single column.
OK, I am not sure multiple columns can be chosen in the picklist. I thought thast maybe a parameter like “:” could be used, but ahhhh nope! It does not say wether multiples can be used in the designer help. If i find anything out i will let you know. Sorry…
Maybe you could use the get coulumn method after finding the doc you need with getdocument or getentrybykey, or something.