The idea is simple, if a user modifies the address of an account, I need to make sure they are reminded to update it on the contact record it corresponds to. So I can create a Task every time the account address is updated through a workflow rule, but the only options for "Assigned To" don't give me an option for the user who triggered the update! Is this possible to do within SalesForce?
We are used to a system where we can add unlimited addresses, assign a "Address Type" to each address and mark one as "Default". In Salesforce, the "Address" type is not available to us, we can't have a dynamic list of any kind of field (this would also be useful for phone numbers, email, etc).
We deal with the idea of Households + Individuals. So say we have a client (a husband and wife) and we set them up in Salesforce as a new Household (Account) with a separate Individual (Contact) record for the husband and wife (and maybe any children). We'd like to keep their work information separate, so we store them on the individual level as "Work Address". But what about other addresses? Summer Home, Winter Home, etc. Instead of splitting the addresses on multiple levels, we try to make it all available on a single level, the Individual, with only the "Shipping Address" on the Household level updated to the now-current mailing address for that client (whether it be the summer home, wife's work address, husband's work address, etc.). It is not uncommon to switch a client's mailing address 2-4 times in a year.
The goal of these tasks is to make sure we keep any changes to the shipping address updated in the individual level. Any shared addresses would be loaded into the Individual marked "Head of Household". We created a bunch of fields to add Street/City/State/Zip/Type for up to 4 addresses per individual.
Maybe I didn't think this through properly when I implemented it this way, so other suggestions are welcomed. Speaking with "Salesforce migration specialists" and reading their community forum, a solution to problems similar to mine are all somewhat non-ideal.
I don't mind using custom APEX code, however, given how we store addresses, I'm not sure it would be very straightforward to automatically update the address from the Household Level to the Individual Level or vice-versa.
I hope this clarifies things!