I'm not pretty sure if posting this in ODK-Dev it's Ok or if it's better in
ODK Community, but here we go.
When i launch a project, as standard process i publish the results into
Google Spreadsheets. From there i can use the data for further analysis.
In some projects i need to take photos and i need to download and identify
that files (matching with the record where the picture come from).
Nowadays the process i do is basically manual and is as follows:
- identify the url in the spreadsheet
- add the "as_attachment=true" sufix to the url in order to download the
file (copy-paste url into browser)
- once stored in hard drive i rename the file with
- then upload-it back to google drive.
Of course this way, is slow, messy and error-prone
I was thinking (lightly, if you want) on some other possibilities to
exploit data from Google Spreadsheets,
Recently (3 days ago) i discover Google Apps Script and start to
play-around with visualize data and i was wondering if it is possible to
"going beyond", and develop a server side method to work around my manual
method using this Language.
I'd like to brainstorm with you regarding this issue: perhaps we can
discover something useful for the entire community.
Please, share your thoughts.
Thanks in advance.