Is Contacts::Log defined as a date field? Is it available for editing in Browse mode?
Just as an aside, you're usually better served to use Set Field if you don't need to actually insert a value inside some other text. It doesn't require the field to be on the layout, and is thus immune to these peculiarities.
Contacts::Log is defined as a Text field and yes it is available for editing in Browse mode.
I will try the Set Field approach anyway.
I'm with Mike, use Set Field. Insert requires a field to be ON a layout to work (much like paste). Also I have found sometimes that the formatting of the field is not correct and what I inserted (set or paste or enter) does not appear. "boolean" formatting of a number field (as default) has caught me several times!
What are you actually trying to accomplish?
The Set Field approach worked. Thanks.
I ask about what you are trying to accomplish because the field name and the use of Insert suggests you might be trying to do something like append the date to the beginning or end of the field contents.
Also, by using insert, you leave the user in the field. Which - considering that the field name is "Log" suggests that it might be something you are trying to do: start a log entry with a date and let the user add to it.
As mentioned by others, Set Field is extremely useful and is almost always the better way to go.
If you want to over-write the contents of the field, that is what the existing Set Field instruction will accomplish.
Thanks Bruce for the comment. I am trying to create a running Log for phone call notes with each note time-stamped followed by the user added text for that note. So therefore I do not wish to over write the previous entries.
1 of 1 people found this helpful
You should probably create a separate table for these notes. Keeping multiple entries in a single field confuses data entry and retrieval. If you keep each note as a separate record, you can easily create reports that, for example, show a range of dates and times. Trying to do that with a single field is a nightmare.
That said, you can still use Set Field to append data. Just use:
Thanks Mike. I will do this.