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
troubles1troubles1 

Excel Connector

I LOVE THIS THING!!!

Would like to continue the efficiency by utilizing a current spreadsheet with a BUNCH (technical term!) of customized forms, code and functions already built-in.  This spreadsheet gets updated frequently and already have the update logic built into the application.

Would like to â¬?callâ¬? the connector to search for SFDC Accounts, Contacts and Oppty records.  How (where) would I stick in some code to have the connector pull data from SFDC and populate my application?

Thanks in advance

 

Ron HessRon Hess

Crack open the sforce_connect source (alt F11) and look for the public functions sflookup(), sfaccout(), sfemail() etc, they are in s_force and utils modules.

you shoudl be able to call these and / or modify them to meet your needs.  they mostly return the ID, but you can extend them easiliy enough.
troubles1troubles1
thx!