Maybe my script trigger on exit will help me explain. Pics are worth a 1000 words, right?
The "New Comments" are placed at the end of "Comments", but I want the most recent inserted information at the top of "Comments".
Hope this is more helpful.
PS. I think I'm understanding you post now. I would need to select all correct?
1 of 1 people found this helpful
Welcome to TechNet!
Now, on to the good stuff:
Don't use Insert; use Set Field.
Set Field to calculated result ( NewNoteField & "¶" & NoteField )
Insert relies on the field being available and enterable on the current layout, as do the less reliable Copy/Paste script steps. Set Field works even if none of the data is on the current layout, as long as the data involved is accesible from the Base Table records of the current layout.
With Set Field, you don't have to select anything. The contents of the fields in the calculated result ignore whether or not anything is selected, using the full fields.
My co-workers need to have the newest "notes/comments" at the begging of the field. Not at the very end.
It would be best to create a new record for each note in a related table.