?
Solved

lotus script to assign a value to a field on condition

Posted on 2008-10-21
3
Medium Priority
?
733 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 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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
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.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

741 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