Sign Up ›
  • Jeff Solomon
  • NEWBIE
  • 5 Points
  • Member since 2006
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 3
    Replies
2 replies

Transferring data via S-Control

I want to be able to transfer data from one object to another in SFDC, and I want to know if I can accomplish this via an S-Control. 
 
I want to be able to take data populated in fields in the account and automatically transfer that data to an opportunity that is linked to the account.  So, once someone clicks the link in an account to create a new opportunity, I want this data to automatically show up in the opportunity.
 
Is this process possible and if so, does anyone have a sample of code as a thought starter for how I might build this out?
 
Thanks. 
2 replies

Running a report with no filter-suppose to bring all records

Hello,
 
i'm trying to run a report using the Excel Connector which will bring all contact records.
 
So I'm choosing the contact table, the fields that I want to see in the report, and when I get to the "Add Clause" screen I do nothing, I'm leaving it as is and doing "next".
 
Whan I'm expecting is that all the contact records will appear in the results excel table. The actual is that the following line appears at the top of the file
System Modstamp>21/12/2006

and I get only few contact records. For example: if there are 20,000 records in the system for contacts (which is what i'm expecting to get in the Excel) - I'm getting only 500 contact records.

When I'm going back to refine my query I see in the "Add Clause" screen I see the following query: System Modstamp>21/12/06 - althiught I didn't enter anything there!

Why is that? What is the logical "filter" he does to give me those 500 records? How can I over come it?

  • December 28, 2006
  • Like
  • 0
2 replies

Running Queries on Pick Lists

Question -- I'm having difficulty contructing a query that will pull records that have a certain pick list item selected.  For example, I'd like to find all Account records where the picklist item in Account Type field contains phrase "VAR".  We have different types of VARs (i.e., resellers).  I've tried using 'like' or 'includes' but get error messages:  For example:
 
ERROR at Row:1:Column:45
expecting a left parantheses, found "'VAR'"
ExceptionCode:  5087
 
Similarly, when have a field in Leads called 'Partner Involved".  This is a non-required picklist so sometimes there is a specific picklist item selected, other times there is nothing selected.  I've not been able to figure out a way to construct a query that pulls any records where there is any picklist item selected (ie.., there is data in the field).
 
Ideas ?
 
Thanks