I have a nightly upload to salesforce which maps a string from my database to a custom field in sfdc using jitterbit. 
What I want to do is append the string that is already in sfdc to the new string that is coming in from the nightly upload and build up the string.
Basically we have account notes in my db that need to be added to a text area to sfdc without having to re upload the entire account notes table.
So for example, the text area shows:
Dec 10, 2017 called customer
Dec 9, 2017 payment made 
....

After the nightly upload it would show:
Dec 11, 2017 account closed
Dec 10, 2017 called customer
Dec 9, 2017 payment made
...

The upload would only have the string "Dec 11, 2017 account closed" and that would be appended the string
Dec 10, 2017 called customer
Dec 9, 2017 payment made


It would be simple if i can modify the value with itself but that can't be done in a formula, i.e.
newString = "Dec 11, 2017 account closed<br/>"
currentString = "Dec 10, 2017 called customer<br/>Dec 9, 2017 payment made"
currentString = newString + currentString 

I was thinking of a bunch of placeholder fields to hold intermediate values however I can't seen to figure out the logic to do this. 
I was thinking maybe to do something like this (each variable is a custom field)
newString //coming in from the db upload
currentString = newString  + oldString // formula field to show in the text area the newString appended with the string already in sfdc
oldString = currentString // formula field to hold the current string 

Are there any potential issues here?  Any experienced admin/developers that can provide any comments or how they would approach this issue?
I am pretty new to sfdc so I have not had any experience with workflow rules. Would that be a more proper way to tackle this issue? If so how would that be implemented?

Thanks in advance.





 

I have a nightly upload to salesforce which maps a string from my database to a custom field in sfdc using jitterbit. 
What I want to do is append the string that is already in sfdc to the new string that is coming in from the nightly upload and build up the string.
Basically we have account notes in my db that need to be added to a text area to sfdc without having to re upload the entire account notes table.
So for example, the text area shows:
Dec 10, 2017 called customer
Dec 9, 2017 payment made 
....

After the nightly upload it would show:
Dec 11, 2017 account closed
Dec 10, 2017 called customer
Dec 9, 2017 payment made
...

The upload would only have the string "Dec 11, 2017 account closed" and that would be appended the string
Dec 10, 2017 called customer
Dec 9, 2017 payment made


It would be simple if i can modify the value with itself but that can't be done in a formula, i.e.
newString = "Dec 11, 2017 account closed<br/>"
currentString = "Dec 10, 2017 called customer<br/>Dec 9, 2017 payment made"
currentString = newString + currentString 

I was thinking of a bunch of placeholder fields to hold intermediate values however I can't seen to figure out the logic to do this. 
I was thinking maybe to do something like this (each variable is a custom field)
newString //coming in from the db upload
currentString = newString  + oldString // formula field to show in the text area the newString appended with the string already in sfdc
oldString = currentString // formula field to hold the current string 

Are there any potential issues here?  Any experienced admin/developers that can provide any comments or how they would approach this issue?
I am pretty new to sfdc so I have not had any experience with workflow rules. Would that be a more proper way to tackle this issue? If so how would that be implemented?

Thanks in advance.