Problems with medication name auto-complete
When entering a letter into the "medication name" input on the "Post new activity" form, an auto-complete dropdown appears. There are two bugs with this in my opinion:
1) Any medication that contains the entered letter(s) is listed in the dropdown. E.g. entering "M" matches "Kids vitamines". I find it unlikely that this is what the user wanted and would suggest to only match medications starting with the entered letter(s), as opposed to containing them anywhere. (Expressed in SQL: ... WHERE medication_name LIKE 'M%' ... instead of ... WHERE medication_name LIKE '%M%').
2) Medication names that are on several different schedules show up twice or more often. (Expressed in SQL: add a GROUP BY medication_name).
This image hopefully clarifies these issues: