Ok I've solved issue 1 by using the following command:
Insert Current Date [Select; Job_Updates::Date]
This only leaves issue 2 to sort out. How do I prevent this happening:
Do in your script what you are doing manually. Clicking a blank area of the layout commits records and closes the record--allowing you to open it for editing in the new window. Have your script do a commit records while the first window is selected. (But becareful of when you commit records, make sure you capture the needed values from the last portal row record before committing records as this will remove the focus on the last portal row.
I had a feeling that was the case but how do I capture the values?
If I commit the record in the "New Job Updates" script when it goes to run the "Job Updates" script it doesn't bring up the record I've just created.