Solved

Auto Script or Agent in Lotus Notes

Posted on 2004-10-11
6
215 Views
Last Modified: 2013-12-18
Hi all,

When a LAN admin being asked to do some coding, is a real messup. With every keyboard key I press, I whisper F**k you chief.......... lol...

Anyway, I have 2 questions.

1-   I wrote a small script to initiate database variables, so it can be excuted automaticaly once a user opens the database. where shall I place such script ?

2-   When I create a form and specify it as Response, would it work like the original form, I mean, if I create a view to list the documents created with the parent form, what shall I do to tell Notes that such document have Responses created with another form and they shall be listed under original form also? is it possible ? or shall Parent and Response have the same form ? I'm sorry if my question is confusing, but I'll try harder to explain it if it's not clear.

Kindest Regards.
0
Comment
Question by:Faraj1969
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 19

Expert Comment

by:madheeswar
ID: 12284350
1) In database scripts.

2) Yes. it is possible.
In the view, after selection formula place this
Select form="formname" & @ALLchildrren
or u can use @AllDescendents for response to response.
0
 
LVL 19

Expert Comment

by:madheeswar
ID: 12284375
and few more details:
1) It depends on what youa re doing. If u let us know, we should be able to tell u, where to place the code and when to execute.

2) it will work as original form and u can display the response in views using the below said formulas.For more info, check Designer help on these formulas.
SELECT Form="YourFormname" | @AllDescendants

or
SELECT Form="YourFormname" | @AllChildren
0
 

Author Comment

by:Faraj1969
ID: 12284430
Hey madheeswar.... hope u r doing great.

1-   I've created a form like a Setup for database, that list the company name, path to server and another database cause I'm expecting the database to go to another companies and I didn't want to hardcode those values, each company can change them to suit their environment without going into the script, so I need current database to pick up those values and place them in memory. I did this script but I don't know where to place it exactly so it can be excuted automaticaly, for the variables to be available all the time.

2-   Does Parent and Response should have the same form ? and if so, how shall I tell parent form that it have responses ? What i did now exactly, that I created parent form, and another form for responses, but till now I couldn't try it since I'm playing with live data, which kinda risky.. u know....


Many thanks...
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Faraj1969
ID: 12284459
Sorry...

let me clear it more.

The parent form holds the information for Staff member, and the first response, should have his spouse info (if available), then rest of responses depends on how many kids (dependants) he/she have, so the view should list staff member, and under him/her should spouse and kids be listed. Why we doing this, cause each one of them have medical insurance and when any of them claim something for mediacal, Personnel section should fill a form for either Staff member, Spouse or dependants, so users should be able to select the name from view and click a botton called CREATE MIP.

Hope this made it a bit clearer.

0
 
LVL 19

Accepted Solution

by:
madheeswar earned 125 total points
ID: 12284537
for second:

response document may not be the same as Parent form. So, u can use the formula wich I have given.
for first:

you can store the setup in profile documents. if it is per user. or u can create a master profile and store them in a view if it is for all users. And u can prompt setup in Database scripts Postopen event. open the form.
0
 

Author Comment

by:Faraj1969
ID: 12284595
Many Thanks madheeswar

Cheers EE.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question