Home > IT Answers > Lotus Domino > How to auto populate fields when creating new form
cast9710
40 pts.
 How to auto populate fields when creating new form
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.

Software/Hardware used:
ASKED: April 4, 2009  3:39 PM
UPDATED: April 7, 2009  5:49 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  April 6, 2009  1:40 pm  by  Brooklynegg   3,845 pts.
All Answer Wiki Contributors:  Brooklynegg   3,845 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Please specify in what program/programming language/platform you are trying to do this.

carlosdl
 63,535 pts.
 

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!

cast9710
 40 pts.
 

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

abcd1987
 10 pts.