{"action":"opened","issue":{"url":"https://api.github.com/repos/medic/medic-webapp/issues/947","labels_url":"https://api.github.com/repos/medic/medic-webapp/issues/947/labels{/name}","comments_url":"https://api.github.com/repos/medic/medic-webapp/issues/947/comments","events_url":"https://api.github.com/repos/medic/medic-webapp/issues/947/events","html_url":"https://github.com/medic/medic-webapp/issues/947","id":76051195,"number":947,"title":"Updates to static form data only apply to new forms, old forms become inconsistent","user":{"login":"btbonval","id":880439,"avatar_url":"https://avatars.githubusercontent.com/u/880439?v=3","gravatar_id":"","url":"https://api.github.com/users/btbonval","html_url":"https://github.com/btbonval","followers_url":"https://api.github.com/users/btbonval/followers","following_url":"https://api.github.com/users/btbonval/following{/other_user}","gists_url":"https://api.github.com/users/btbonval/gists{/gist_id}","starred_url":"https://api.github.com/users/btbonval/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/btbonval/subscriptions","organizations_url":"https://api.github.com/users/btbonval/orgs","repos_url":"https://api.github.com/users/btbonval/repos","events_url":"https://api.github.com/users/btbonval/events{/privacy}","received_events_url":"https://api.github.com/users/btbonval/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-05-13T16:45:44Z","updated_at":"2015-05-13T16:45:44Z","closed_at":null,"body":"So far as I can tell, forms are filled in using static data configured by SMS phone number.\r\n\r\nIf a CHW has their name changed (perhaps the first entry had a typo, or a middle initial was added/dropped), then forms before the change hold the old name for the CHW, while new forms hold the new name for the CHW.\r\n\r\nSimilarly, if an organization or any other static field is changed, it doesn't propagate in a consistent fashion.\r\n\r\nA relational database would help clear this up, but in the meantime, the CHW name inconsistency really messes with our ability to report on CHW activity for impact and activity metrics. The other inconsistencies might cause problems later."}}