?
Solved

lotus script to assign a value to a field on condition

Posted on 2008-10-21
3
Medium Priority
?
737 Views
Last Modified: 2013-12-18
lotus notes  4.6/r5
domino r5


what I need:
I have a field that is a radiobutton - editable   with 2 options...

Off-Site/Desktop | Off-Site/Desktop
On-Site | On-Site


If a person selects   "On-Site"

I need another field("SiteProjectManager_1")  to change a value called   "JIM PARKER"
SiteProjectManager_1 -  a "Text"-computed for display....

I currently already have this in the "Value" for  "SiteProjectManager_1"

@If(ProjectSize = "";@Return("");@Success);
@If(ProjectSize ="20-200" ;"David Thomas";ProjectSize ="501-1000" | ProjectSize ="1001-2500"|ProjectSize = "2500+";"Tom Hobbs";"Dale West")

Thanks
fordraiders







0
Comment
Question by:Fordraiders
  • 2
3 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 22767933
Do you mean that you want a second field to be computed, with a value that depends on the value of your radio button field?

Make the second field a computed field, with formula @If(RadioButtonField="On-Site"; "Jim Parker"; "Lady Penelope")

Set the options in the first field to Refresh fields on keyword change (in the field's Properties box)
0
 
LVL 3

Author Comment

by:Fordraiders
ID: 22768124
no the same field:

The first field is :  "WorkRequestType"(radiobutton)   if its value gets changed to "On-Site"

I want the second field :  "SiteProjectManager_1"  changed to "   "Lady Penelope"

but as stated above I already have code in the  "Value" property in "SiteProjectManager_1"
I did not know if what I'm trying to do would interfere with this other code ?

Thanks
fordraiders
0
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 2000 total points
ID: 22768202
Ah, okay, get it. The current formula will always overwrite a value you put in it from elsewhere. It may be the easiest way to modify your formula, like this:

@If(WorkRequestType="On-Site"; "Lady Penelope"; ProjectSize = ""; ""; ProjectSize ="20-200" ;"David Thomas";ProjectSize ="501-1000" | ProjectSize ="1001-2500"|ProjectSize = "2500+";"Tom Hobbs";"Dale West")

Check if this is really what you want, because the value will be set to "Lady Penelope" whatever the value of the ProjectSize field.
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.

Question has a verified solution.

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

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Screencast - Getting to Know the Pipeline
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Suggested Courses

569 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