The Answer Archive
Providing students and professionals with answers to their toughest software, technology, math, and science problems. Browse the Archive!
Search Questions and Answers:

Show only unanswered questions

Lotus Notes document database

Posted by admin on 25 Sep 2008 at 05:29 PM
$5.00

Hardware and Networking / E-Mail and Groupware

Dear Mr Barnes,

I am using Lotus Notes R5 to create document library databases, and am getting a little frustrated with the online Help. I have two questions that I'm struggling with:

1) I have a field in the main document form for "Country" that the document relates to. Currently my "By Country" view lists the countries alphabetically. I would like to arrange the countries by Region (Asia, Africa, etc.) but do not know how to do this without adding an extra field titled "Region". Surely there is a way to tell Lotus Notes that Cambodia and China belong to Asia and Zambia and Zimbabwe belong to Africa?

2) I want a new database to have two types of forms: a main form for each project, and an "extra documentation" form (of which there might be many relating to the same project.) Can you help me link the two forms together so that the view will list the main form first (maybe with a twistie to expand/collapse) and then all the related documents underneath?

Thanks in advance.

Helen Carter.

PS: My employer is trying to locate some Lotus Notes Design training for me, but it's difficult to get something suitable when what's on offer in Australia is rather limited.

Accepted Answer:

Answer provided by admin on 25 Sep 2008 at 05:29 PM

Helen,

1) You could define the 1st column of the view to display regions, using a formula like this:

@If(Country="Cambodia":"China"; "Asia"; Country="Zambia":"Zimbabwe"; "Africa"; "Unknown")

Notes @If statements always have an odd number of arguments:
1 - test (Country="Cambodia":"China")
2 - true result ("Asia")
3 - either the false result, or another test (Country="Zamia":"Zimbabwe")
...


2) Create the 2nd form to be a Response type(the 1st should be a Document type). If the 2nd forms are then created by clicking a button on the 1st form, you can also set the option to inherit values from selected document. That way, any values that need to be the same (e.g., project name) will be on the response docs already when you create them. Also make sure the view option 'show responses in hierarchy' is turned on. Then all responses will show up under the main document.

I hope this gets you started well!

Ken

Rating: * * * * *      Awarded: $5.00
Ask a Question
Most Recent Questions
Most Recent Answers
Home Page

Login
Register

Information Technology
Software, Hardware, Design

Programming Languages
Database
Graphic Design
Operating Platforms
Hardware and Networking
- E-Mail and Groupware
- Handhelds and Wireless
- Linux Networking
- Macintosh Networking
- Netware
- Printers and Scanners
- Routers and Modems
- UNIX Networking
- Windows Networking

Math and Science
Homework Help

Biology and Geology
Math and Statistics
Chemistry
Physics
Engineering

Are you an information
technology or
math/science expert?

You can earn money by
providing answers to questions
at AnswerArchive.com.
Learn How

Browse Archive | Ask a Question | Most Recent Questions | Most Recent Answers | Home Page | Contact Us | Help
(c) 2008 The Answer Archive