In order to have secure LAN or WAN client-database connections, we should implement TLS/SSL secure connection from FMF client to mysql-server.
libqsqlmysql MySQL driver library included in current Qt5 packages (5.3, 5.4, 5.5) is buggy and doesn't allow TLS connection with MySQL server. A patch has been released for the upcoming Qt 5.6 release in February 2016: https://codereview.qt-project.org/#/c/96849/ This patch was successfully applied by its author on Qt 5.3, so we could keep 5.3 compatibility with Debian Stable and implement our own patched mysql driver. We already build our own driver from source for Mac OS X. We would have to do this with Debian/Ubuntu and Windows too, unless we decide to switch to Qt 5.6 for Windows build in February (but only using features available in Qt 5.3 for Debian Stable compatibility).
Having secure TLS/SSL database connections option would make off-site database possible (as primary database or live backup option) and would bring more users to FreeMedForms EMR.
Work with us on the mysql TLS requirement specification.
When reading an episode of a form created at a given date, clicking in the list of other forms in the left menu should display episodes of this form created at the nearest date. For instance, if user is reading a POMR consultation episode created on 2015-12-01, clicking on the labtest result item in the left menu should display the chronologically closest labtest episode, let's say the episode dated 2015-12-05, instead of the last created episode as is the current default.