The Geospatial & Data Services team operates out of Groundwork London's Morley Street office and hence works closely with Groundwork London on the various projects they are involved in. Contributions to projects can range from small jobs such as creating an area profile for a new recycling hub to long-term contracts such as the systems-management of the Thames Water Progressive Metering Programme.
The Loops are two award-winning community reuse hubs designed to help communities recycle and reuse more household goods, which reduces fly-tipping and amount of waste sent to landfill sites. At The Loops we collect, repair, up-cycle and sell unique, reasonably priced furniture and other household goods. Many local people have become part of the re-use movement with the Loops also providing training, employment and volunteering opportunities for residents in a range of specialist skills, including furniture restoration.
Rework is a Groundwork London initiative delivered in association with the Western Riverside Waste Authority and Cory Riverside Energy and supported by the Masonic Charitable Foundation.
Each year thousands of electrical items in the workshop, including washing machines, fridges, cookers, microwaves and other household electrical goods are being processed. These appliances that would have been scrapped, recycled or sent to landfill, are returned to full working order and given a second life. They are then passed onto charity retailers and social enterprises who sell them at affordable prices.
The team at Rework needed a solution to create a live inventory of goods that had to go through a complex checking process in stages by different team members with different duties. Given the nature of the work being done, the system needed to be fully compatible with mobile devices (iPads).
The application created by the GDS Team on Zoho, was based on the idea that barcode stickers applied to white goods were scanned with iPads. The barcode functioned as a unique identifier for that appliance and followed the item through the whole refurbishment process.
The workflow was built so that employees had to follow a strict procedure aimed at minimising users' error. Custom scripts helped users accessing the right form and insert relevant information only when needed.
Views and reports were designed to count and track items so that managers could assign and monitor jobs in real-time.
Dashboards and reports were designed to allow monitoring performance and quantify the positive environmental impact of Rework.
The employment team all work from different offices/co-locations all across London, so in the past it's been quite difficult to facilitate cross team information sharing. Individual teams can be quite good at sharing information about job vacancies etc., but when you're looking at an overall Employment function of around 30 who work out of up to 20 different locations it's a lot more complicated! Across all the locations and programmes we have Employment Advisors (EAs) signing up new clients who are candidates in the job market - providing 1-2-1 advice and guidance on finding a new role.
The app is designed so that an EA is able to upload core "candidate" details which will be useful to help them with their job search. This means for the first time we will be able to track what types of jobs are being sought after by the candidates in different locations across London all in a single place. This means that the team of Employer Liaison Officers (ELOs) can more easily identify the types of businesses in each area we need to be developing relationships with so we can put forward candidates.
The app also has a section where the ELOs can upload any live vacancies onto the system. EAs can review these vacancies and submit candidates for those jobs - and with the ability to track what jobs are being submitted against, we can work out which types of jobs are more/less suitable for the candidates. The teams also use the list of live vacancies to send out to our referral partners - showing them the types of opportunities we can help candidates get work in and therefore encouraging them to refer us candidates for the programmes.
For 14 years Groundwork London Green Doctors have been helping households in London save money, stay warm and improve energy efficiency at home. In partnership with London Boroughs and Housing Associations they visit residents’ homes to install free energy-saving measures, give advice on bills and provide referrals to further services to improve health and well-being. The HEART iOS app project addressed the need for an intuitive UI, offline capabilities and dynamic calculations of energy, water and financial savings for residents.
The GDS Team worked with a well-established UX-consultancy (Lion+Mason) to conduct a user research and to define a UX strategy and design for the creation of a bespoke iOS app fully integrated with the Salesforce platform.
A team of developers worked on the creation of the iOS app, which featured:
Complex and dynamic formulas to calculate energy, water and financial savings from behavioural changes, energy and water saving measures, based on user’s selections
Creation of a bespoke pdf report for the resident
Framework for the creation of scheduled messages (text) to residents to remind them of pledges made during the visit
For 14 years Groundwork London Green Doctors have been helping households in London save money, stay warm and improve energy efficiency at home. In partnership with London Boroughs and Housing Associations they visit residents’ homes to install free energy-saving measures, give advice on bills and provide referrals to further services to improve health and well-being.
With hundreds of residents visited every month, Green Doctors need a reliable CRM to book and deliver home visits and telephone consultations. Despite the use of other CRM platforms, Green Doctors asked for a more intuitive, secure and reliable application fully compatible with mobile devices.
The GDS Team has worked closely with Green Doctors to identify areas of improvement for the current CRM and develop a customised user experience that kept well established workflows, but allowed offline editing, an integrated calendar system and a more engaging experience for Green Doctors and residents alike. Salesforce offered all this.
The development included:
Force.com development (enquiry form and data protection consent) with custom APEX and Visualforce
Workflow design, execution and automation using Lightning components
Fully integrated mobile experience
Offline editing capability when needed
Comprehensive reporting solutions and dashboards
A fully integrated calendar system to create and manage bookings, developed with Lightning components.
Force.com questionnaires with a focus on the creation of an intuitive interface and logic implementation to ensure residents and Green Doctors have the best possible experience
For over 15 years Groundwork London has been helping Londoners stay warm & well & save money on their household bills through the Green Doctors service. Over 3,300 households in London last year were visited by Green Doctors, and the entire workflow – from enquiry, through booking and the visit, to reporting - of each visit was recorded and managed in an especially designed Zoho Creator application.
An early challenge in development was to design an architecture of forms or tables, which would collect the enquiry, booking and visit data, and establish relationships between them. Zoho Creator allowed us to build this with ease, and enabled unique records for schemes, projects, green doctors, engagements, enquiries and visits to be created without unnecessary duplication, and to be collated in a master table from which monitoring and management reports could be fed.
Zoho Creator then enabled us to customise these forms, so that manage every aspect of the Green Doctor project could be managed within the app. Using a dedicated script (deluge), bespoke functions, and schedules, these forms and tables came together into a seamless workflow. Capturing enquiry data from residents and referees, feeding this to Groundwork staff who engage with residents and book visits, and finally through to green doctors who take the residents through a custom, project-specific form which captures everything from the energy savings calculations, advice given and its feedback, and energy saving devices installed.