Salesforce IdeaExchange
Calling Salesforce Administrators!!!! Time to Automate the Tedious Maintenance of Salesforce
Have you noticed that SFDC does not have a "Stored Procedure" tool?
I was shocked to learn that my organization has manually processes tasks such as, filling empty fields based on the content of a "key field"
For example, we have a .jpeg for each of our VP's signatures which we merge into our mailings for a personal touch. This field is conditional on the "Contact Owner" field. Thus, each contact must be looked at, edited and saved in order to fill this field.
A possible automation of this process could be a "Stored Procedure" object that would allow a write command to be executed based on the users' parameters at a set time every day.
Currently, this can be done with SQLServer, however this eliminates the benefit of having an online CRM.
If you are not sure what I am talking about, I urge you to vote anyway.
I assure you, when the time comes in your development as a database administrator, you will greatly appreciate this feature.
Thanks for your time,
- J
|
Tom_Tobin 08/01/07 |
This is what Apex is all about, and S-Controls that can check a set of records returned by a SOQL query. |
|
Scott_Jorgensen 08/01/07 |
Jeff: Apex Code is available for you to use in Unlimited Edition with Summer '07 and it includes "Triggers" which are extremely similar to stored procedures. You can learn more here: http://wiki.apexdevnet.com/index.php/Apex_Code |
|
Heros 08/02/07 |
When will this be avalible for Atleast Enterprise Edition Users. I do not want to go Unlimited. |
track comments for this idea
- AlexCRMmanager
- craskulinecz
- bhare
- gaiser
- avickers
- genedata
- Heros
- RK
- Jeff@AIR
POST IDEA