Solved

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

Posted on 2008-10-15
6
421 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
[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
  • 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
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!

 
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

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!

Question has a verified solution.

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

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvinā€¦
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the adminiā€¦
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.
Suggested Courses

739 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