Solved

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

Posted on 2008-10-15
6
412 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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses 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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

708 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

18 Experts available now in Live!

Get 1:1 Help Now