Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2008-10-15
6
Medium Priority
?
435 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 19

Accepted Solution

by:
madheeswar earned 2000 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

715 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