manifesto icon indicating copy to clipboard operation
manifesto copied to clipboard

Automate extracting details from Google Forms

Open olexandr-konovalov opened this issue 7 years ago • 14 comments

https://github.com/burnash/gspread/pulls may be used for this.

olexandr-konovalov avatar Mar 28 '18 12:03 olexandr-konovalov

Another option is this R package.

egonw avatar May 12 '18 13:05 egonw

How are the GForms details being extracted at the moment and where are they going? If these are meant to go into a file/issue in GH I can take this

trallard avatar Jun 08 '18 15:06 trallard

The links to the forms are here: https://github.com/codeisscience/manifesto/issues/33 - I don't actually have edit access to them to add you or see the results though. @selina-aragon can you help with this?

@trallard failing that, could most of the work be done with a dummy form?

yochannah avatar Jun 08 '18 15:06 yochannah

Processing the results into a file (e.g. an html or markdown file for jekyll) would be perfect.

yochannah avatar Jun 08 '18 15:06 yochannah

We will eventually need access to the forms to creat some authorization tokens for the automation tasks. So Ideally we want access to the form and response (and edit access).

I could work on a dummy form and link to GH ... for a quick mock up

trallard avatar Jun 08 '18 16:06 trallard

@trallard I would like to launch this within the next couple of weeks to time with the talk I am doing at GCCBOSC at the end of June. Is that doable? I'll poke Selina about sharing the forms, but worst case is I re-create them with an account where I have write access.

yochannah avatar Jun 09 '18 22:06 yochannah

It would normally be completely doable... but I am officially on leave from Saturday until the 8th of July and I have a long list of outstanding actions for the week. So I would not be able to pick this up until I am back from holidays (sorry)

trallard avatar Jun 11 '18 08:06 trallard

Hi @yochannah, I've made you owner of the forms. Let me know if that works?

selina-aragon avatar Jun 11 '18 08:06 selina-aragon

@selina-aragon I still can't get in, sorry! These two, either yoyehudi or yochannah at gmail etc. would be great!

https://docs.google.com/forms/d/1W75S7DCa9Iv5FHTL7oeUWAnakl-oaEBoY5oNVcvDX5A/viewform?edit_requested=true https://docs.google.com/forms/d/1qEfuzo3TacqHYBatq9Gea3vPd_SFMpAqjlEe3TGt6ag/viewform?edit_requested=true

@trallard Thanks for letting me know and enjoy your break!

yochannah avatar Jun 11 '18 08:06 yochannah

@selina-aragon I lie, I've just seen the invites in my inbox!

yochannah avatar Jun 11 '18 08:06 yochannah

ah, that’s why. It had [email protected]mailto:[email protected] Changing it just now. Should be accessible in 5 mins.

On 11 Jun 2018, at 09:40, Yo Yehudi <[email protected]mailto:[email protected]> wrote:

@selina-aragonhttps://github.com/selina-aragon I still can't get in, sorry! These two, either yoyehudi or yochannah at gmail etc. would be great!

https://docs.google.com/forms/d/1W75S7DCa9Iv5FHTL7oeUWAnakl-oaEBoY5oNVcvDX5A/viewform?edit_requested=true https://docs.google.com/forms/d/1qEfuzo3TacqHYBatq9Gea3vPd_SFMpAqjlEe3TGt6ag/viewform?edit_requested=true

@trallardhttps://github.com/trallard Thanks for letting me know and enjoy your break!

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/codeisscience/manifesto/issues/3#issuecomment-396166540, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ASpioh9s_HlqSQ1I-yhA2QDmXMwJuqezks5t7iz8gaJpZM4S-hIJ.

The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336.

selina-aragon avatar Jun 11 '18 08:06 selina-aragon

Cool... If I can have a look at the forms and the responses fields I can make a start and will finish over the first week of July if that works.

I suppose for the time being we could keep the data extraction as manual and automated for the future?

trallard avatar Jun 12 '18 19:06 trallard

Hi! I am back. @selina-aragon @yochannah any chance we can get this moving forward?

trallard avatar Jul 11 '18 15:07 trallard

@trallard can you email me your preferred google id to add you? I only have your sheffield email

yochannah avatar Jul 22 '18 16:07 yochannah