Print letters - leave "Done"message on each record

[Maxwell Morlay]

I want to print Letter No. 1 to a batch of clients. I want the script to leave a message in LETTERS SENT field on each record, "Letter No. 1 Sent, today's date."

Later, I want to print Letter No. 2 to a batch of clients. I want the script to leave a message in LETTERS SENT field on each record, "Letter No. 2 Sent, today's date."

I want the messages to accumulate so I will have a record of all letters sent to each client.

I always appreciate your assistance. Maxwell Morlay

[transpower]

In the script, as you're looping through the records to print, use the Set Field step put the text you want with the date appended by Status ( CurrentDate ). You could use the same field and overwrite the information or use a different field each time you send a letter. Or you could use a repeating field, specifying the repetition in the Set Field step.

[T-Square]

If you plan on this being a large or long-term kind of solution, I would recommend breaking the notifications out into a separate table. While appending the text onto the end of a text field achieves a result of storing this data, it's not really usable there. Instead, create a Messages table, with this structure:

ID - Unique ID (Either a serial number, or, better, see CaptKurt's suggestions)

Date

ClientID

MessageText

Then instead of adding to the text field, create a new record in this messages table.

With this structure, you will be able to search for Messages in a broader number of ways--most importantly by Date.

HTH.

David