I'd like to do something similar to Jeff, without necessarily having to export data into a CSV. It would be ideal if Forms data could appear automatically in an Excel spreadsheet, in real time.
Like Jeff, I'm not much of a coder, but my thought was to do something from Excel with ODBC/JDBC. I was thinking it could access the h2 database directly and pull data into the Excel sheet.
I'm running into technical dead ends, however (and may even be barking up a totally wrong tree!) -- is there any possibility with this method/outcome?
We did talk about the potential of allowing incoming Form data to trigger an action in "External Commands", which could have written the data to an external database, CSV, or whatever. We're not planning on doing much further development with Forms right now, but Alex might have some ideas about how you might be able to knock something together here. I'll ask him to comment.
If you use a MySQL database with FrontlineSMS, I expect you could poll this periodically from Excel using VBA. I've no experience with VBA though, so I can't suggest much more than that.
Thanks, Alex --
I was able to install and configure a MySQL database on my machine (key step was actually creating the database from the MySQL client, then FL took it from there!). I have further succeeded in pulling in table data into excel using the MySQL ODBC driver. It even pulls in new Forms data automatically! Last step is getting the data to be displayed correctly, in a normalized list like it displays within Frontline itself. Am exploring creating a custom table, but am so new at this that I am rather slow! Thanks for the suggestions and advice!