Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 440
  • Last Modified:

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

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
Fordraiders
Asked:
Fordraiders
  • 4
  • 2
1 Solution
 
madheeswarCommented:
You can do it by using AJAX or using Div tags for the SiteProjectManager field.
0
 
FordraidersAuthor Commented:
since i'm new to lotus...is this applicable to Lotus Nots r5 domino r5   ?
0
 
FordraidersAuthor Commented:
I need Lotus script or formulas please...not javascript
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
madheeswarCommented:
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
 
FordraidersAuthor Commented:
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
 
FordraidersAuthor Commented:
got it to work,,,...appreciate all the help...
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now