GCortesJr
asked on
How do I grab cell values in a Lotus Notes table?
I have an email that I setup with a table and button from Lotus Notes. I want to be able to send it to people within my company so they can fill out the table. When they finish filling out the table they click the button and an email gets generated and sent right back to me. I want to be able to grab the data they entered into the table and pull into that email that gets sent back to me but I do not want the whole table. Example:
Table filled out by company employee where column 2 and 4 is the employee's data:
Column 1 Column 2 Column 3 Column 4
Store A 456 Store C 323
Store B 542 Store D 186
This is what I want back:
456, 542, 323, 186
Is there a way to do that?
Table filled out by company employee where column 2 and 4 is the employee's data:
Column 1 Column 2 Column 3 Column 4
Store A 456 Store C 323
Store B 542 Store D 186
This is what I want back:
456, 542, 323, 186
Is there a way to do that?
Yes, provided you send them a mail with a form, and they send you the form back as well. Design the form with the fields you need, then send it away with a doc.Send(True) or click Store form in document.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
True, and then there's the part where the user edits the table in the email and adds a row...? It does seem like a lot of work to try and catch all the errors when you can simply send a form or a button that opens a form.
Unless of course you don't have a Domino Designer for the form. Remains the question: how on earth am I going to create that wretched agent??
ASKER
Just wanted to let everyone that I am trying out the solutions provided and will update this call soon. Thanks for all the good responses so far!
ASKER
Sorry I didn't get back sooner to close this call out but the man has got me working hard lately. Anyways, TiwariVikas's code put me on the right track and got me real close to where I needed to go. marilyng & sjef_bosman gave me some food for thought for future planning. Thanks to all for the help.