I want to update Account.Name with ( FirstName__C + LastName__C) whenever FirstName__C or LastName__C is changed or new account is created.
Workflow/process builder/trigger will not work as it will work when event is raised and Account.Name is mandatory field. Any suggestion.