Solved

Fill field with value based upon another field... in a form

Posted on 2008-10-15
6
413 Views
Last Modified: 2013-12-18
Domino r5
Lotus Notes4.6/5


I have a form called  "Pipeline"


Current Load Event:

if(document.forms[0].Focus.value == "Yes")
document.forms[0].SellerVM.focus() ;


What I need added below

When My document loads: I need the follwing also to happen:


I have a field called "ProjectSize" -  it is a radiobutton-editable
enter choices per line
choices are:

20-200
201-500
501-1000
1001-2500
2500+
Not Applicable - On-site



What I need to Happen:
Based upon the choice in the "ProjectSize"

I need another field populated with a name based on the choice.
"SiteProjectManager"

If the choice is  20-200 then I need the field "SiteProjectManager" Updated to "Dave"
If the choice is  201-500 then I need the field "SiteProjectManager" Updated to "Dale"
If the choice is  501-1000 then I need the field "SiteProjectManager" Updated to "Tom"
If the choice is  1001-2500 then I need the field "SiteProjectManager" Updated to "Tom"
If the choice is  2500+ then I need the field "SiteProjectManager" Updated to "Tom"
If the choice is  Not Applicable - On-site  then I need the field "SiteProjectManager" Updated to "Dale"

Thanks
fordraiders


0
Comment
Question by:fordraiders
  • 4
  • 2
6 Comments
 
LVL 19

Expert Comment

by:madheeswar
ID: 22727971
You can do it by using AJAX or using Div tags for the SiteProjectManager field.
0
 
LVL 3

Author Comment

by:fordraiders
ID: 22728204
since i'm new to lotus...is this applicable to Lotus Nots r5 domino r5   ?
0
 
LVL 3

Author Comment

by:fordraiders
ID: 22728208
I need Lotus script or formulas please...not javascript
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 19

Accepted Solution

by:
madheeswar earned 500 total points
ID: 22728688
For the SiteProjectManager field, make it Computed. And for ProjectSize field properties in the second tab, enable Refresh fields on key word change.
Now for the SiteProjectManager  field default value:
@If(ProjectSize = "";@Return("");@Success);
@If(ProjectSize ="20-200" | ProjectSize ="201-500";"Dave";ProjectSize ="501-1000" | ProjectSize ="1001-2500";"Tom";"Dale");
0
 
LVL 3

Author Comment

by:fordraiders
ID: 22732120
mad,

0-200  =   David
201-500 =  Dale
501-1000 = Tom
1001-2500 = Tom
2500+ = Tom
Not Applicable - On-site =  Dale
This is the actual breakdown  so is this correct ?

@If(ProjectSize = "";@Return("");@Success);
@If(ProjectSize ="20-200"; "David"| ProjectSize ="201-500";"Dale"| ProjectSize ="501-1000"; "Tom"| ProjectSize ="1001-2500";"Tom"|ProjectSize ="2500+";"Tom"|ProjectSize = "Not Applicable - On-site";"Dale"; "Dale");

Thanks
fordraiders

0
 
LVL 3

Author Closing Comment

by:fordraiders
ID: 31506568
got it to work,,,...appreciate all the help...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

919 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now