Fordraiders
asked on
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
Lotus Notes4.6/5
I have a form called "Pipeline"
Current Load Event:
if(document.forms[0].Focus
document.forms[0].SellerVM
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
You can do it by using AJAX or using Div tags for the SiteProjectManager field.
ASKER
since i'm new to lotus...is this applicable to Lotus Nots r5 domino r5 ?
ASKER
I need Lotus script or formulas please...not javascript
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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"|Project Size ="2500+";"Tom"|ProjectSize = "Not Applicable - On-site";"Dale"; "Dale");
Thanks
fordraiders
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"|Project
Thanks
fordraiders
ASKER
got it to work,,,...appreciate all the help...