AnsweredAssumed Answered

Script for "automated" data entry using portal

Question asked by wilz on Jan 3, 2013
Latest reply on Jan 3, 2013 by philmodjunk

Title

Script for "automated" data entry using portal

Post

      

     Need some help writing a script that "automatically" enters data for me.  Ive got some of it written, but cannot get the desired result.

     The process I'm trying to create:
Step 1: "Maunally" Enter Data in "Portal Test"

     Project ID(PK)    TeacherName   TaName
     HE001                 John 

Step 2: "Manually" Enter data in "Proposed" 
     Project ID(FK)    Class Name     StartDate         Finish Date
     HE001                 English Lvl1     01Jan2012     04Jan2012
     HE001                 English Lvl2     01Jan 2012    04Jan 2012

Step 3: Run script to automatically fill in "Actual" so it will end up looking like this.  
     ProjectID (FK)   Class Name    Teacher Name   Date
     HE001                English Lvl1   John                      01Jan2012
     HE001                English Lvl1   John                      02Jan2012
     HE001                English Lvl1   John                      03Jan2012
     HE001                English Lvl1   John                      04Jan2012
     HE001                English Lvl2   John                      01Jan2012
     HE001                English Lvl2   John                      02Jan2012
     HE001                English Lvl2   John                      03Jan2012
     HE001                English Lvl2   John                      04Jan2012

     LAYOUT SETUP
     ON the "Portal Test" Layout, I have setup a portal to "Proposed" (so I can enter them all in one go).
     Relationships are setup so the ProjectID is automatically filled in. 

     PROBLEM
     Seems taht whatever I try to do, the script only knows to enter the "English Lvl1" and not for "English Lvl2".  

     I'm pretty sure I have multile problems (Design problem? Wrong script logic? Wrong script usage?) Anywa any help would be greatful.  Thanks! 

Portal_Script_Help.jpg

Outcomes