function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ForcefeverForcefever 

How to create an excel like sheet on the object page?

I have to create a object page where I have to perform calculations, like we do in excel. But cannot find any field in SFDC which creates an excel like sheet.

For ex: I have to calculate area of a rectangle, for multiple dimensions on the same page. One option is to define mutiple fields  on the same page such as defining length, breadth fields muttiple times and then calculate their respective areas. But that is too lengthy. In excel its too easy o perform calculation for multiple enteries. Please suggest any short method of achieving the desired result. 

 

            

SFDC Consulting 123SFDC Consulting 123

Hi ForceFever,

 

What you are asking is not possible in SFDC.

 

Please do not expect excel kind of functionality in other programming languages.

 

Best Wishes,
ForcefeverForcefever
Hi,

Thanks, Is there any way to load the the data from excel to SFDC where I
have the option to create the data in Excel initially and then migrate it
to SFDC.

Thanks and Regards
SFDC Consulting 123SFDC Consulting 123
Yes,

Please use Apex Data Loader.

Its a free tool provided by Salesforce.com for these purposes.

Setup->Admin Setup -> Data Management then download the data loader from
your salesforce.com org.

Best Wishes

--
-----------------------------------------------------------------------------------------------
*Jay Guruswamy *
*sfdcconsulting123@gmail.com - **# 1 831 435 1752 - **skype: JMeansJay*