Adding to portal row - Overwrite?

[ataft]

I'm stumped. I have three fields that are just collection points for adding information to a portal below it. The fields are:

date, name, and notes

The user will click a button next to the fields that will add the information into the portal. The script goes like this:

Freeze Window

Goto Portal, last row

copy (current record) date

paste (related file) date

copy (current record) name

paste (related file) name

copy (current record) notes

paste (related file) notes

clear (current record) date

clear (current record) name

clear (current record) notes

Goto field (current record) date

Refresh window

I thought this method and script would cut and paste the data into the portal, the portal would refresh/resort, and then I could post data after data into the portal. Buuuuut... in reality, what's happening is every time I run the script, the new data overwrites the last post even though the last post is not in the last row of the portal (it's in the 1st). Any suggestions?

Here's what I ultimately want: A "journal" of posts to a portal where the fields aren't modifiable by the user. Are there better methods to achieving this?

Thanks!

-Ansel

[BertBoye]

Did you click

[jasonwood]

You want to turn off "Allow creation of related records" so that users cannot add related records through the portal. Then you want your button to set globals in your JournalEntriesDB to the values of your entry fields (do not use copy/paste, use "set field".

Then run an external script in your JournalEntriesDB which creates a new record, and sets the fields to the values stored in the globals. Again, use "set field" NOT copy/paste.

You could also add a few extra steps to the main script which clears the entry fields.

[ataft]

Jason,

That was the ticket. I left the house without my brain that day. Thanks so much!

-Ansel