AnsweredAssumed Answered

Tracking a Date & Time Field's History

Question asked by Kayla Ebert on Jan 11, 2019
Latest reply on Jan 14, 2019 by Kayla Ebert

I found the following article to be incredibly helpful for creating a field that tracks the Name History in Sugar.… 


I want to create a similar field that tracks any change made to a date/time field called "Last Phone Call Date"


The original formula for tracking changes made to a name looks like this: 

ifElse(contains($name_history_c,concat($first_name," ",$last_name)),  $name_history_c,concat($name_history_c," ",$first_name," ",$last_name))

I would think the following changes would work to track changes made to "Last Phone Call Date" but I get this error message when I click save: concat: All parameters must be of type 'string'


Did I simply mess up the formula OR can a date/time field not be copied and tracked using a text area field?


ifElse(contains($history_of_calls_logged_c,concat($last_phonecall_c)),$name_history_c,concat($history_of_calls_logged_c," ",$last_phonecall_c))