Fun Series - Salesforce - Survey App Challenge - Using Inbuilt Features

Key Information

Register
Submit
The challenge is finished.

Challenge Overview

.

Project Overview

We are launching a series of fun Challenges, intended for learning new technology and topcoder platform. This is second challenge of the series. 

Important :

This is a fun and learning challenge. No prizes will be awarded for completing the challenge.

 

Business Requirements

“Fun&Learn” company wants to develop a survey solution. FunAtLearn have identified Salesforce.com as their desired platform to implement the solution. We will help them build the survey application, across a series of challenges. In this second challenge, we will add validations, and formulas on objects. The first challenge can be found here

Help Documentation

  1. Building formulas in Salesforce

  2. Defining Rollup Summaries

  3. Defining Validation Rules

  4. Sample Validation Rules

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.

 

Survey ERD - New Page.png

A user should also be able to add data for surveys and questions.

 

1. Validation Rule

The business requirements states that every survey should have minimum description of length 10 characters.

Add a validation rule, on the Survey object to handle the above requirement. Name the validation rule as “Minimum_Description_Length”.

ValidationRule.png

 

2. Rollup Summary

  1. Business would like to see the number of questions on a survey, quickly.

  2. Create a Rollup Summary on the Survey, to show the number of questions in the survey. Name the field as “Number_of_Questions__c”

  3. Similarly create a roll up summary on the Questions object to show the number of surveys, this question has been used. “Number_of_Surveys__c”.

3. Formula

The business user at Fun&Learn would like to see the number of days, that have passed since the survey was created.

To accommodate the requirement, create a formula field, that shows the number of days have been passed since survey created date.

 


Final Submission Guidelines

.To submit your the results, please install the automated checker app . The link will be provided in the forums. This app will review the work and generate a pdf file. Please upload the pdf document generated by the app in a zip file.

Important :

This is a fun and learning challenge. No prizes will be awarded for completing the challenge.

 

REVIEW STYLE:

Final Review:

Community Review Board

Approval:

User Sign-Off

SHARE:

ID: 30050799