Sample form for lead questions

[anirudh4792]

I really did try to understand what you were saying with the voting system, but I think I am lost. Here are two attempts of me trying to implement this. Thank you for your patience, and if this doesnt work, please let me know and I would be happy to learn. The new google forms is terrible and I preferred using the old one. Also, google forms cannot have two answer types (eg text and mcq (for voting) under one question)

1) editable version: https://docs.google.com/forms/d/e/1FAIpQLSfHocu9M5jpVO2P9797T2q8iWY7-lPwY_kipO-OYPoB888IFw/viewform?usp=send_form Please add your lead questions in place of 'your name' + placeholder by editing the form The person who fills the lead questions last will have to send the form to all three of us for the voting

2) text based answer version: https://docs.google.com/forms/d/e/1FAIpQLScEqVHPMiNMPZWfuLmipAXXwYm-Y29LxLU18BjTC1bE7-NhBg/viewform?usp=send_form I have sent you the form, for you to add your lead question in the text box (other's responses will not be seen by you). I have activated a 'publish and show a public link to form results' option OR you will view the responses since you are collaborators You would then vote by re-editing your forms/change my responses

[shnizzedy]

I think your option 1 was so close to what @binarybottle suggested.

Instead of putting in placeholders and requiring us to edit the form directly, just add an "ADD OTHER" option to each multiple-choice question, keep responses editable, and you're golden. I made a copy to try it out, and it seems to work just right.

Unfortunately, I didn't see an easier way to create all the questions than to copy-paste. The populate-from-a-sheet add-on that I was thinking of only updates options within a given question from a spreadsheet column as far as I can tell.

[shnizzedy]

Web Form to Google Sheet (No Backend)

HTML forms @ W3Schools

Write to a Google Spreadsheet from a Python script

[anirudh4792]

@binarybottle After a quick discussion with Jon where we explored options on Google Forms, I feel option 1 is the easiest for all concerned (2 steps - add your answer as an extra option by editing the form; vote once three options are present)

Regarding HTML, I can learn somewhat to code in HTML and create a form online. I look forward to learning this. What I did not understand was the backend part with python and excel.

Also, realised I have lots of work neutralizing several symptoms and adding lead questions if we want to cover the questionnaires used in CMI (eg I included one question to cover for sleep but now, I would have to neutralize 50 sleep symptoms and generate lead questions for each) - so I am going to choose select fe w areas first

[binarybottle]

I just filled out your first questionnaire in a google form. This format works fine for voting on wording.

[shnizzedy]

Working from revised structure for neutral states & lead questions, I'm starting to encode the relationships from this workbook as described in this diagram:

[binarybottle]

This issue is subsumed within issue #61 -- closing this issue.