Fun Series March - Salesforce - Survey App Challenge

Project Overview

We have launched a new Fun Challenge series to help our members learn new skills/technologies while getting used to the Topcoder platform. This challenge is about Salesforce. In this challenge, we will explore Reports and Dashboards.

Business Requirements

"Fun&Learn" company wants to develop a survey solution. Fun&Learn has identified Salesforce.com as their desired platform to implement the solution.In this month's challenge, we will explore asynchronous processing in Force.com and Apex

Help Documentation & Tutorials

1. https://developer.salesforce.com/trailhead/en/force_com_dev_intermediate/asynchronous_apex/async_apex_batch
2. https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_batch_interface.htm

Technical Requirements

You need a Salesforce.com Developer account to complete this challenge. You can sign up a free account here
A survey is a collection of Questions. A question can be part of multiple surveys. To keep things simple, we will assume all questions are of Free Text.

In this challenge, we will explore Batch Apex to do asynchronous processing

In Previous challenges, we built the object schema. If you haven't participated in previous challenges, please use the package to install the objects and workflows

The new database schema.

This Challenge Requirements

The company, wants to see the all responses made by the contact on the contact record. It would be possible to achieve this by embedding a report on the Contact Layout. But we would like to use Batch Apex, to achieve the functionality.

1. Create a new field of Text Area (Long) with the name "All Survey Responses".

2. Add the field on Contact layout

3. Create a scheduled job, that invokes a Batch job that stores all responses made by a contact on surveys as a comma separated string on the Long Text Area field.

Sample Screenshot