<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Thomas Hill on Medium]]></title>
        <description><![CDATA[Stories by Thomas Hill on Medium]]></description>
        <link>https://medium.com/@CLICKSIT?source=rss-9c05b7fcf9ff------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*AFvSGFYkDL-qZwfg.png</url>
            <title>Stories by Thomas Hill on Medium</title>
            <link>https://medium.com/@CLICKSIT?source=rss-9c05b7fcf9ff------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 22:31:57 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@CLICKSIT/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Coordination of local delivery for isolated people during Coronavirus]]></title>
            <link>https://medium.com/@CLICKSIT/coordination-of-local-delivery-for-isolated-people-during-coronavirus-2467f58831d0?source=rss-9c05b7fcf9ff------2</link>
            <guid isPermaLink="false">https://medium.com/p/2467f58831d0</guid>
            <category><![CDATA[covid19]]></category>
            <category><![CDATA[corona]]></category>
            <dc:creator><![CDATA[Thomas Hill]]></dc:creator>
            <pubDate>Tue, 24 Mar 2020 09:43:40 GMT</pubDate>
            <atom:updated>2020-03-24T09:57:27.771Z</atom:updated>
            <content:encoded><![CDATA[<p>Using free tools, it is possible to coordinate an organised local delivery operation to supply items to those in isolation. This article will provide a sample of this setup, and introduce the simple tools that can be used to do it. I’ll also outline how a local community website can be created to manage the local community operation. I’ve broken this down into steps starting at the most basic of systems. Implementing the first steps will be enough for some operations, while larger operations may require progressing through further steps. All steps to maintain an organised efficient operation are outlined below.</p><ol><li>Setup a basic contact channel for people in isolation to make requests</li><li>Create a form to capture details of requests from people in isolation <a href="https://docs.google.com/forms/d/1nIE_6QIRRxJeCyfwDFq6mI1la69eohfsWEg2JaDutEg/copy">Example</a></li><li>Create a form to capture details of volunteers <a href="https://docs.google.com/forms/d/e/1FAIpQLSfwFcMhAOAF0NHeDAlxvRj0ig4dc3LUuIwy9vAjjnDOzV4gOA/viewform?usp=sf_link">Example</a></li><li>Get your own community website <a href="https://sites.google.com/clicksit.com/demo/home">Example</a></li><li>Testing your setup</li><li>Plan deliveries, and routeing using software</li><li>Additional steps that may be taken to optimise</li></ol><h3>1. Setup a basic contact channel for people in isolation to make requests</h3><p>A simple group chat, phone number or email may be enough for some operations. This should always exist as a fallback in the event that other systems in this article fail. The options below may be used alone, or combined, to provide a basic system, but any such system would involve manual recording of information.</p><ul><li>Whatsapp group combining volunteers and isolated people. Demo on how to create groups can be found <a href="https://faq.whatsapp.com/en/iphone/26000115">here</a></li><li>Phone number(s) that can be used for those in isolation to make requests.</li><li>Email address(s). This will be created as part of the setup in this article.</li></ul><p>Although the above options will work for ad hoc requests, accurate capture of information and efficiency will be key to ensuring that no requests go unnoticed or unserviced. The further steps, detailed below, deal with creating a system where this process can be automated, and data relating to those isolated, drivers(volunteers) and requests are stored. It’s probably important to highlight that this system outlines digital ways of capturing data. Some people in isolation may not be comfortable with using technology, but the system will still serve a purpose and requests submitted by other means should be logged using the digital forms outlined below.</p><h3>2. Create a form to capture requests from people in isolation.</h3><p>Details should be captured digitally, wherever possible, to prevent error during transfer from written to digital storage. Where they are captured manually, such as using a paper form or over the phone, for example, these details should be entered into the system using the same digital form.</p><h4>Create Google Account</h4><p>The form to capture information will be created with google forms. Firstly you will need to create a google account <a href="https://accounts.google.com/signup">here</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XjiQSv6rFP3DGURAu4cRzQ.png" /></figure><h4>Copy Form template</h4><p>Once your account is created, you can now copy the template form below to your account using the link <a href="https://docs.google.com/forms/d/1nIE_6QIRRxJeCyfwDFq6mI1la69eohfsWEg2JaDutEg/copy">here</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/659/1*TpMlnMgvNle2aTQrl2hj0g.png" /></figure><p>You can find your form in your google account <a href="https://drive.google.com/drive/my-drive">here</a></p><h4>Create your Google Sheet</h4><p>Now you have a copy of the form in your account you can automatically create a Google Sheet where you can view submissions to the form. This takes two clicks to complete.</p><p>Select responses when on the form in your account</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*6zT1fEbiX_x_yPMOTJoM3g.png" /></figure><p>Click the google sheets icon</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*95TpL0gfyqPAg8jNnWU_BA.png" /></figure><p>You are now taken to the spreadsheet connected to the form and saved on your account. This spreadsheet contains all the submissions made to the form.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3nGpCwRBsdR7f3Z9qLavlA.png" /></figure><p>You can find your google sheet in your google account <a href="https://drive.google.com/drive/my-drive">here</a></p><h4>Turn Google Form notifications on</h4><p>A final step is to turn on notifications for your form, so you are notified via email when a new submission comes in. These emails will be sent to the new google email address you setup when setting up your account in the first step. First click 3 dots at the top right of screen, and then tick get email notifications.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*r3fRkuAWnYOF_Q9P3I7tBQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/842/1*api2p0fGzPZjwn_IArwAgw.png" /></figure><p>This spreadsheet can easily be shared with the team to have multiple people monitoring requests.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/756/1*_YULHPxbnxOylqAC9Tvcug.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9J5nmjLQvmtvVQ2bX7PxNw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ocMdg5Y0Ze50QR6qHqnAPA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/984/1*njCprcfhB_e-p76W5EDJ-g.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*6yYUSQoo9uxHUZgMQgF02w.png" /></figure><p>Sample spreadsheet can be found <a href="https://docs.google.com/spreadsheets/d/1i94k4wwVeyXtXbl5PFx6UGjuia_hnWXZEgjVxt6RMqY/edit?usp=sharing">here</a></p><h3>3. Create a form to capture details of volunteers</h3><p>Copy <a href="https://docs.google.com/forms/d/1iAz-qUH30LVFw02Uil_LjPrOIoeJ5LaymESfO2MwfPQ/copy">this form</a> to your google account and follow all steps in step 2 above. Once form is copied create a connected spreadsheet. Again, to do this follow all steps in step 2.</p><p>With the steps completed so far you should have 2 forms and 2 spreadsheets where the data captured from these forms is stored. If you don’t have these revisit the steps above</p><p>All forms and google sheets can be found in your account <a href="https://drive.google.com/drive/my-drive">here</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*UVXUAf8NGbYLfbhD3rOqsQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0WHWny0L6YMJqANDgayhrA.png" /></figure><p>Sharing forms with you community</p><p>First click send at the top right of the form edit screen.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Ype5PDWu8G_P45_uKVc9VA.png" /></figure><p>The menu opened now allows you to share your form with the community through email, web link, Facebook and twitter.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Sp7sA9wLBSZIAaXHFkv1_Q.png" /></figure><p>If you would like to take this a further and create a community website with the forms embedded on the site then step 4 takes you through this.</p><h3>4. Get your own community website</h3><p>With all steps completed we can create you a community website to display your forms to capture details on new helpers and new requests. Community website will be setup at: helpnear.co.uk/yourarea<strong>.</strong> Demo website can be found here: <a href="http://helpnear.co.uk/demo">helpnear.co.uk/demo</a></p><p>If you would like this creating then please submit details <a href="https://docs.google.com/forms/d/e/1FAIpQLScLlO70IcKS9tlZQSqSAIr0wn3j76fHWiwhqxhTODpPGGnrug/viewform">here</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9jn7L221vvyakRMp16_SgA.png" /></figure><h3>5. Testing your setup</h3><p>Completing end to end test for all elements of the system setup is key to ensuring the system works. Run through the process for all three forms as if you were the person completing the form, and confirm that the submissions have been logged in their respective Google Sheet.</p><h3>6. Plan Deliveries, and routing using software.</h3><p>This step now looks at advanced setup. Onfleet have made their service free to those coordinating deliveries during the Pandemic. You will need to speak to them directly regarding setting this up. You can reach them <a href="https://onfleet.com/contact">here</a>. You can create a free trial <a href="https://onfleet.com/freeTrial?creative=346385579906&amp;keyword=onfleet&amp;matchtype=p&amp;network=g&amp;device=c&amp;utm_source=adwords&amp;utm_campaign=branded&amp;utm_medium=ppc&amp;gclid=Cj0KCQjwjcfzBRCHARIsAO-1_Oq8A9TfrlacDCEMNDi7qDOpaXcdrXIgk8j-ICxk4MQ96LTw4R6dvu8aAsNJEALw_wcB">here</a> to try out the product. In my experience this free trial will be converted into a free account if your operation is being setup to assist during the pandemic.</p><p>Within oOfleet you can:</p><ul><li>Create drivers</li><li>Create deliveries</li><li>Assign drivers to deliveries</li></ul><p>A demo of the product can be found <a href="https://onfleet.wistia.com/medias/kobx4p4zs7">here</a> to get you started</p><p>Once setup you will have a dashboard where you can view all local delivery requests and drivers on a map.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Zn3W7gQH-BcjQD1I0wrz7w.png" /></figure><p>Volunteers can install the onfleet driver app to receive delivery requests and get directions. While those in isolation receiving deliveries will get notified of where the driver is on their route.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4YSKxTZEbl3iCYwqD7FskQ.png" /></figure><p>With Onfleet installed the spreadsheet linked to the form, created in step 4, to capture requests from those in isolation, can now be used to input deliveries into Onfleet. See how to <a href="https://support.onfleet.com/hc/en-us/articles/360023910131-Task-Overview#h_3f014ac2-8f08-476a-bf4c-8591f49aff41">here</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4-3Pmz_7s1S-1OeydGzb5Q.png" /></figure><p>Onfleet general guide <a href="https://support.onfleet.com/hc/en-us/categories/360001490311-Dispatcher">here</a></p><h3>7. Additional steps that may be taken to optimise</h3><ul><li>Log driver’s hours of availability to ensure a smoother operation and less inefficient of routing jobs to drivers.</li><li>Standardise the packages that can be requested by those isolated, so that they can be prepacked. This will minimise the time spent in supermarkets finding items.</li><li>Agree with local supermarkets access for picking up.</li><li>Explore ways that a base level of drivers can be paid to guarantee availability while supplementing peak demand with volunteers.</li></ul><p>If you have any questions please don’t hesitate to ask</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2467f58831d0" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>