Title
Multiple values in 1 field
Post
I have a system where users email contacts via a script that pops up the email dialog. I use a Set Field function to create a Timestamp whenever the email button is clicked. For example: user clicks the email button and emails John Doe; A field designated to catch the timestamp via Get (currentdate) is populated. Is there any way to add multiple values in this 1 field so that each time a user emails the contact, a timestamp is captured? thanks
It is possible, but this sounds like a case where adding a new record in a related table where you have a date field would work much nicer.
Set Field [YourTable::EmailDateList ; List ( Get ( CurrentDate ) ; YourTable::EmailDateList ) ]
will build a list of dates with the most recently added date at the top of the list. You can reverse the two parameters used in the List function to put the post recently added value at the end of the list.