Solved

lotus script to assign a value to a field on condition

Posted on 2008-10-21
3
730 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
[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
  • 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 500 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

726 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