How can I add a data from a pick list to a dynamic table? I am having a pick list with a list of products and each time i select a poduct from the pick list it should get added to the dynamic table. Please help me
Thanks in advance…
Subject: Some Clarifications Please
is this functionality for Web or Notes Client?
By Table do you mean that against each slected product there is more data entered - say quantity, date expected ?
IfYes How many rows and columns does this table need to be?
These are just a few of the considerations before we could suggest one or more suitable techniques
Subject: RE: Some Clarifications Please
Hi Alan
Thanks for your response. I will explain my requirement more precisely.
I have a dynamic table with 1 row and 1 coloumn for product number and product name. The select product button pops out a pick list that contains the documents(products) from a view. I can select one product at a time. Once the product is selected it should be added to the table. If i want to add one more product i should be able to do that also. The idea of dynamic table is to enable the user to add more than one product. This needs to be implemented in notes client. I hope you understood my issue now
Thanks in advance…
Subject: OK - many ways to attack that
simplest does not even need a table provided you dont mind the values displaying like this
prodnum1: proddesc1
prodnum2: proddesc2
…
prodnumm: prodescm
for this to work you need 3 things
First
a simple form to produce documents
(with fields containing product number and product description)
Lets call them pnum and pdesc
Second
a view listing all such product documents nicely formatted
(with a column calculated in the format you want )
in this case it might be something like
pnum + ": " + pdesc
Third, on he document wherte you want teh “table”
a single field
field properties
on first tab:
type dialog list
Multiple values selected
on second tab
Choices
use view dialog
pick the view you just built
pick the column that you created
slect display helper button
on third tab
Multiple value options
select newline as ONLY entry option
select newline as display option
when you create the document
you’lll be able to pick one or more values from teh view
and they make a kind of table
Have fun & let us know how you get on