It's not possible to specify that location but thanks for reporting the issue. I'm going to improve the functionality related to Google Sheets so I'll take it into account.
I started a few topics with other issues:
Currently all media file uploaded to Google Drive are stored in Open Data Kit > Submissions. That means files from different forms and different submissions of those forms are mixed there.
Probably it would be better to have a separate directory for each form and for each submission. It could be:
Open Data Kit > Submissions> Form name > Submission name > File name
sample:
Open Data Kit > Submissions> All widgets > All widgets_2019-11-20_01-00-04 > 1574204528724.jpg
In my opinion it would re…
When we upload a filled form to Google Sheets and the form contains media files we put links which don’t contain their media file names. They look like:
https://drive.google.com/open?id=1p6HKVuna8rsKII5ChXbxXaAPOnQoHETT
For users who need to export such filled forms and operate on them locally it might be a problem to refer to downloaded media files.
Sample complaints:
In Collect v1.14 we used hyperlinks which contained file names but it was a problem for other group of users:
so we de…
Currently there is no option to specify which sheet in a spreadsheet should be used to receive filed forms, the first one on the list is always used.
Why this is a problem:
We can’t use one spreadsheet to receive data from different forms (maybe it’s not a good idea in case of complex forms with repeatable groups but simple forms, why not)
It’s confusing for our users that the target sheet must be the first on the list and I’ve solved many problems on the forum like
Question: “I can’t send f…
Since you are real users I would love to get to know your opinion on them.
1 Like