How do I write this Lotus Script

Posted on 2004-12-01
Last Modified: 2013-12-18
If the value of fieldA is a certain thing,
take the value of fieldB and put it in fieldC
Question by:rbend
    LVL 14

    Accepted Solution

    if doc.fieldA(0) ="Yourthing" then
    doc.fieldC  = doc.fieldB
    end if

    LVL 31

    Expert Comment

    1) Why does this need to be LotusScript.  It is much easier as a formula for C:
    oldValue := FieldC;
    changedValue := FieldB;
    @If(FieldA = "some value"; changedValue; oldValue)

    Or, simpler: @If(FieldA = "some value"; FieldB; FieldC);

    If it does need to be in LotusScript, then it depends on when you want it to get triggered.  Before saving?  As soon as A changes?

    Author Comment

    ok..thanks...I picked up what I needed.
    LVL 19

    Expert Comment

    which one u picked? If it solved your problem, then close this question with grade "A".


    Pls don't accept this as Answer.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    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…
    Article by: Rob
    Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now