Google Apps

hpo2gforms creates Google App scripts that automate the creation of the Google Forms that we will use for creating the online questionnaires. There are several steps.

Open the Google Apps Scripting Window

Open a google form in Google. Go to the ellipsis (three dots) on the upper right and open the scripting console.

Opening the Google Apps Scripting Window.

Add hpo2gforms-generated script

Run the hpo2gforms application as explained here. If you use this command

$ java -jar target/hpo2gforms.jar gforms -t 0000758 

the we expect to find new output files of the form

HP_0030506_1.txt
HP_0030506_2.txt
(...)

Each file needs to be pasted into a separate window and will create a separate questionnaire/form. This is what the Google Scripting App window should look like after you have pasted in a script.

Replace the entire contents of the scripting window with the code generated by hpo2gforms.

Create the questionnaire

Rename the file from "Untitled project" to a recognizable name. In the Google environment, save the code.

Saving the script.

If there are no syntax errors, the run button will be activated. Click it. It may take a few minutes for the Google form to be generated. You may need to grant permission for the script to run.

Running the script.

When the script is finished, if things have gone well, you will see "Execution completed" in the Execution Log pane at the bottom of the window.

The created form

To find the created form, one can use the "Recent" button in one's Google Drive account. The title of the form is determined by the title in the script. In our example, we have

var form = FormApp.create('Yellow/white lesions of the retina (HP:0030506) part 1');

Using the "Recent" button in Google Drive, the top file is called "Yellow/white lesions of the retina (HP:0030506) part 1".

The top of the Google form created by the script.

Form items

The script creates one set of questions for each term

Example item.

Inviting participants

Use the "Share" link to obtain a link to send by email

Share a link to the Google Form

Responses

There is now a tab called "Responses" that contains a graphical summary of the answers and a link to the corresponding Google sheet.

Links to Responses/Google Sheet

The response page looks like this, with one Figure for each item

Responses

We can create a google sheet with one row for each set of answers.

Google sheet with detailed answers

Evaluation

The HPO team will use a script to summarize the counts for each question; this will allow us to determine if a sufficient degree of consensus has been obtained, and will provide a summary for the Delphi steering committee.