Challenge Overview
Project Overview
The CPQ application has been developed to provide sales users at a outdoor advertising media company the ability to create advertising campaigns plans and generate dynamic proposals for their customers. The solution has been built on the Salesforce platform leveraging multiple integrations to obtain availability data, OOH ratings and inventory maps as well as leverages Heroku to create the proposal outputs - which is referred to as the "Output Builder".
Competition Task Overview
This is a 48 hours contest! Review phase is 24 hours!
The Output Builder will receive a JSON request, fetch data from SalesForce and generate PDF/Excel file.
We want to improve the excel output format in this contest.
- Remove merged data columns (e.g. currently columns: B+C and K+L). Do not render any values in merge cells.
- "NoWrap" across all Cell values (*Values may appear chopped) however, User may
personalize their view by using Excel functions to expand/wrap align the cols and
values. - The Output will need to prepare all values in contiguous columns (No hidden or
Merge cols) .
Environment Set Up
- Request SalesForce Test Environment Login in Contest Forum
- Login to SalesForce Test Site and find the session id in cookie.
- Download the Modified Code for developers from this page.
- Update the Hard Code session id, JSON Request and salesforceURL for testing.
- Run the project and verify the generated PDF file.
Final Submission Guidelines
N/A