Simple Script to add text to beginning of field

[AgentsSka]

I have a "Notes" field on a layout that is a text box that could potentially have alot of text in it.

What I want to achieve is a script that does the following:

Place the following text string before the existing text "abc: (carriage return) (carriage return)"

Place the cursor before the first carriage return for new input.

Does anyone know of a way to achieve this with scriptmaker?

[bcooney]

Yes, I do, but I would suggest that you have a separate table for Notes and display these related records in a portal.

Then you can give each Note a CreatedDate, CreatedBy (AccountName) and perhaps a priority.

[AgentsSka]

actually, my "abc" string was going to be a time/date stamp and userName.

and for readability purposes, I just figured it would be easier to have it in one field...

Edited June 3, 2009 by Guest

[bcooney]

You could gather all the notes into one field with List ( ).

[AgentsSka]

Ok... Let me think about this with you...

I am going to have a notes section in various tables - on a company level, on a contact level, and on an invoice level.

What benefit do I get from having a "notes" table rather than simply having a running field in the appropriate table, on the appropriate record?

[mr_vodka]

Easier maintenance, searching, indexing, better normalized, etc.

[bcooney]

If that's so, then there's more reason to have one Notes table. Just have the respective foreign keys in Notes. So a note record that belongs to an Invoice would have an Invoice foreign key, and perhaps a Customer foreign key. Not all foreign keys need to be populated.

[TELEPATH]

I've been trying the same thing for years - did you ever get an answer? ( without Tables, and keys?)

[TELEPATH]

Worked this out yesterday:

I searched the web forever for months to try to solve this for myself, so yesterday I just sat down and tried 20 different things and I figured it out:

I'm using FM 7

In the Editing section of the Scripts, choose

Set Selection ( optional to name the field) ; Start Position 0

Insert text ( return )

Set Selection; Start Position 0

this will force you to the BEGINNING of the field where you can insert Date Time ( we insert user name) with appropriate insert test " " between date, time, user and after user