Hi all!

Script newbe here. I'm having a problem creating a posting comments script. I have comments to add field were the person would type a comment, and I have the comments compiled field were the comments are posted. I was able to write a script were it would post a date and time stamp, and who made the comment, but no luck on the comments. The fields I mentioned are in one database, and their are no relationships to any other database.

Thanks in advance!

Hi There,

If I understand what you're trying to do correctly, I think there are two things you need to look at:

1) Make sure you are creating a new record to store the comments (use the New Record/Request script step).

2) Use the Set Field script step to set the value of the CommentsCompiled field to the value of the CommentsToAdd field. If you want to preserve any comments already in the "Comments Compiled" field, you set it to Comments Compiled & "<the paragraph character...found in the calculation window>" & CommentsToAdd

I'm not exactly sure about what you're trying to achieve, but you may want to make the CommentsToAdd field a global field (shared across all records)...in fact, that might be the problem you're having. If CommentsToAdd is not a global field, you lose it's data when you make a new record for the new comments to be stored (i.e. the user entered data in one record...but once you've created a new record, the current record's fields (including CommentsToAdd) are blank).

Hope this helps!

Cobra