How to auto populate fields when creating new form

40 pts.
Tags:
Formula Language
Scripting
I have a Action Item Form that is used for a Weekly Meeting. If the Action Item that was created from does not have a completed date, then the item field needs to be moved up into another field which hs a different field name, when the new meeting form is created. I have no idea where to start for this scripting project.

Answer Wiki

Thanks. We'll let you know when a new response is added.

I’ll take a shot: Assuming this is a Notes or browser interface, put this @Formula in the Translation event of the field with the alternate name.

DateCompleteFieldName should be the name of the date field on the document that the new document is created from.
ActionItemFieldName should be the name of the action item on the document that the new document is created from.
ActionItemFieldNameAlternate should be the name of the alternate form on the new document.

@if(@isnewdoc & DateCompleteFieldName = “” & ActionItemFieldNameAlternate != “”; ActionItemFieldName; “”)

The form should have inheritance set.

Now, get training. TLCC.com has lots of good training at good prices. They specialize in Lotus Domino.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Please specify in what program/programming language/platform you are trying to do this.
    70,220 pointsBadges:
    report
  • cast9710
    I am not familar with scripting at all. I do know @functions and commands, sort of. I need the programming for dummies actually. Thank you!
    40 pointsBadges:
    report
  • abcd1987

    Hi all,

    For the form customization in Oracle R12,can anyone suggest me how to automatically populate the subinventory field value for a particular item in a sales order form.
    Even if i donot want to show that field in the form, it should automatically be taken at the backend tables when we book the order.
    I am using
    CONDITIONS--
    trigger--             "WHEN-NEW-ITEM-INSTANCE"
    trigger object-- "LINE.ORDERED_ITEM"
    condition--        'LINE.ORDERED_ITEM'='LINE.ORDERED_ITEM'
    processing mode- both
    ACTIONS--
    type--     PROPERTY
    object type--  item
    target object-- LINE.SUBINVENTORY
    property name-- PROPERTY
    VALUE -- select msid.SUBINVENTORY_CODE
                       FROM MTL_ITEM_SUB_DEFAULTS msid,
                      mtl_system_items_b msib
                     WHERE msib.inventory_item_id = msid.inventory_item_id
                     and msib.ORGANIZATION_ID=msid.ORGANIZATION_ID
                    and msid.default_type=1
                     and msib.segment1 =${item.LINE.ORDERED_ITEM.value}
                  and msib.INVENTORY_ITEM_ID=${item.LINE.INVENTORY_ITEM_ID.value}
                  and rownum<2

    I request you all to give me some solution as its very urgent for me.

    Thanks in advance,
    Nitika

    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following