Logging Stuff on Google Docs with LSL

Logging Stuff on Google Docs with LSL
======================================

► Step 1: Setting up the Goodle Docs document

Example (entry ids and form id are fictional):

Create a form on Google Docs.

Add a field Key (type: Short answer text)
Add a field Name (type: Short answer text)
Add a field Date (type: Date & Time)

Fill in the example and then click the options (3 vertical dots) in the upper right and select "Get Prefilled Link". This will give you a link that looks something like this


https://docs.google.com/forms/d/e/2DDpoQLSdTworfMiRoPy2kwWGk1gAboHb_AG2AF35X11B1nUNHP969Nc/viewform?usp=pp_url&entry.948371827=7cea7636-9167-44e4-ab7b-9a3ba11c330a&entry.839710298=Ema+Nymton&entry.205968371=2020-04-14+20:25

This can be split up in the following elements:

• Base url: https://docs.google.com/forms/d/e/
• Form id: 2DDpoQLSdTworfMiRoPy2kwWGk1gAboHb_AG2AF35X11B1nUNHP969Nc
• Entry id for Key field: entry.948371827
• Entry id for Name field: entry.839710298
• Entry id for Date field: entry.205968371

Plus, you can see how all the formats are (like Ema+Nymton for the name)


► Step 2: Constructing the url:

Based on the information above, you need to create an url that contains the same format of data. The only thing that is different is that instead of viewform, you will use formResponse and you need to add "submit=Submit" at the end.

With the example above, our url would look like this:

https://docs.google.com/forms/d/e/2DDpoQLSdTworfMiRoPy2kwWGk1gAboHb_AG2AF35X11B1nUNHP969Nc/formResponse?usp=pp_url&entry.948371827=7cea7636-9167-44e4-ab7b-9a3ba11c330a&entry.839710298=Ema+Nymton&entry.205968371=2020-04-14+20:25&submit=Submit

After that, all that remains is a simple llHTTPRequest with that url and Bob's your uncle and Ema's logged.