Hi,

I've previously posted regarding recursive data structures. But, as it now turns out, it's still causing me some headache.

What I want to model is a many-to-many relationship between the same custom object.

My scenario is this:

I have a custom object called Sales Product. Any Sales Product has a Type of either Subscription, One-Time Fee or Bundle.

Now, the issue is this. In my data model a Sales Product of Type Bundle holds a list of other Sales Products (where Type isn't Bundle). However, these Sales Products (where Type isn't Bundle) must be able to be part of many bundles which brings me back to a many-to-many relationship between Sales Product and Sales Product.

When reading through the documentation of many-to-many relationships the followint is stated: "You cannot create a many-to-many self relationship, that is, the two master-detail relationships on the junction object cannot have the same master object."

I'm guessing it's exactly that sentence that's preventing me from creating a many-to-many relationship between 2 x Sales Product.

A recursive data structure is fairly common these days. Is there any known workaround for this limitation which would help me overcome my headaches?

Thanks.

/Søren Nødskov Hansen

A manager wants to approve his own approval requests. Seems strange but they are a small team and the manager as well as the sales guys own opportunities and the manager wants to be able demonstrate that his own opportunities have been subjected to the same approval process. 

Alternatively Manager A can approve Manager B requests and Manager B can approve Manager A requests.

Neither seem possible using the Manager field.

Any ideas?

Does anyone know how to override the Export Details and Printable View buttons on the Report tab? I have been told by a colleague that he has seen it done in a previous life but I cannot find any reference to this in either Help or the forums

How can I detect when a custom link has been clicked so that I can update a field? For example if someone clicks on the google maps link on Account. Happy to do some preprocessing before passing the data through to the URL but I cant think of a solution.

Salesforce.com Admin Bootcamp

Is this course for you?

Salesforce.com Admin Bootcamp is designed to get new salesforce.com System Administrators up to speed with the basics of salesforce.com system administration.

It is not designed to replace the salesforce.com Administration Essentials course but we have found that in order to get the most out of that course new adminstrators need to get some hands on experience first, BUT they often need a little jump start t to have the confidence to get started. This course meets that need.

OR if you have been given the job of Assistant Systems Administrator, perhaps taking over when the main Adminstrator is on holiday. This is the course for you.

Cost

The fee for this course including lunch is £350 plus VAT. Payable in advance.

Where

IT Training Room

C/O Progressive Training & Development Ltd
202 Blackfriars Road
Southwark

London
SE1 8NJ

Location Map

When

The next course will be held on the 8th September 2010. The day after Cloudforce London 2010. Call us on 01246 267761 for information on other dates or bookmark our website for updates. There are 4 places left on this course.

Course Agenda

• Course Overview  9.00 - 9.15
• How to use Help and Training 9.15 - 9.30
• Salesforce CRM Overview 9.30 - 9.45
• Custom fields 9.45 - 10.30
  • Different types of Custom fields
  • Set up a Custom field
  • Create and modify a Dependent Picklist
  • Create and modify a Lookup field
  • Create and modify a formula field
• Page Layouts 10.30 - 11.00
  • The elements within a Page Layout
  • Create and modify a Page Layout
  • Customize a related List
  • Create and modify a record type
  • Set up field-Level Security
• Break 11.00 - 11.15
• Data Validation  11.15 - 11.30
  • Create Data Validation rules
• Workflow 11.30 -12.00
  • Differences between immediate and time-dependent Workflow
    actions
  • Set up a Workflow rule and associated actions
• Custom Objects, Applications, & Tabs 12.00 - 12.30
  • Create a Custom object
  • Create a Custom object tab
  • Create a Custom app
• Lunch 12.30 - 13.00
• User Management  13.00 - 13.30
  • Information captured on the User record
  • Create and maintain User records
• Profiles 13.30 - 14.00
  • What a Profile controls
  • Managing profiles
  • When to create a Custom Profile
• Record Sharing 14.00 -  14.45
  • Record owner concept
  • Elements of the Sharing model
  • The use of Roles 
  • Building Sharing rules
• Break 14.45 - 15.00
• Data Management 15.00 - 16.00
  • The function of an external ID
  • The different tools for data migration
  • Data import wizard
  • When to use the Data Loader

I use the following VF code create an editable collection of fields in a section on the page layout of a a custom object. When I first open the record it renders the section  correctly as the first image below but when I press the save button it displays the whole of the screen in the section as in the second page. If I refresh the enclosing record it renders the section correctly. 

apex:page standardController="Compliance__c" showHeader="false" tabstyle="Compliance__c" sidebar="false"> <apex:form > <apex:pageBlock mode=""> <apex:outputLabel value="Policy Holder"/> <apex:inputField value="{!Compliance__c.ZName__c}"/> <apex:outputLabel value="IDD"/> <apex:inputField value="{!Compliance__c.Z1__c}"/> <apex:outputLabel value="Price"/> <apex:inputField value="{!Compliance__c.Z2__c}"/> <apex:outputLabel value="Complete"/> <apex:inputField value="{!Compliance__c.Z3__c}"/> <p/> <apex:outputLabel value="Policy Holder"/> <apex:inputField value="{!Compliance__c.ZName__c}"/> <apex:outputLabel value="IDD"/> <apex:inputField value="{!Compliance__c.Z1__c}"/> <apex:outputLabel value="Price"/> <apex:inputField value="{!Compliance__c.Z2__c}"/> <apex:outputLabel value="Complete"/> <apex:inputField value="{!Compliance__c.Z3__c}"/> <p/> <apex:commandButton value="Save Field Values" action="{!save}"/> </apex:pageBlock> </apex:form> </apex:page>

I need to write a report to identify all the users not logged in the last 7 days  via the browser and I cannot think of any criteria that will give me the result I want because last login includes Outlook sync.

I have 50 dashboards each with 10 components. Each dashboard analyses a particular territory. At the moment I  need to only maintain 10 reports to drive all 50 dashboards because there is a 1 to 1 correspondence between territory and user so I can set each dashboard to the appropriate running user and use the My records filter in the report. In future however it may be that every territory does not have an associated user so I would be faced with maintaining 500 reports. I was just wondering if anyone can think of a way of passing a value from the dashboard to the report so that it can filter on the appropriate territory. Or any other solution that has the same effect.  

A previously working Visualforce page now generates the following error message 

I know I can set the Do not create opportunity checkbox by using a custom convert button

with the following code

"/lead/leadconvert.jsp?retURL=%2F{!Lead.Id}&id={!Lead.Id}&nooppti=1"

but can I prepopulate the subject field on the task with something similar to the following

"/lead/leadconvert.jsp?retURL=%2F{!Lead.Id}&id={!Lead.Id}&nooppti=1&Subject={!Lead.Company}"

In other words can I  find a list of parameters for leadconvert.jsp

I am trying to create VF page to mass edit and save a set of records. There is a pretty good discussion of the issue  here  

http://community.salesforce.com/sforce/board/message?board.id=Visualforce&message.id=8058#M8058

but both my objects (parent and child) are custom objects and I just cannot make it work. For example there does not seem to be a Selected method for custom objects so just using a standard controller will not work but if I use an extension I get the error message Unknown constructor 'EventsList.EventsList(ApexPages.StandardController controller)' if I use the recordsetVar attribute

My apex is

public class EventsList {
    public EventsList(ApexPages.StandardSetController controller) {

    }


   
 public PageReference save() {
     
    return null;
 }





  public Service__c getService() {
    return [select id, name,
             (select id, name, Actual_Fee__c, Actual_days__c, Employee__c from ServiceEvents__r limit 200)
             from Service__c where id =
             :ApexPages.currentPage().getParameters().get('Id') ];
}

public String getName() {
  return 'Events List';
  }
}

My VF is 

<apex:page standardController="Service_Event__c"  recordsetVar ="scheds" extensions="EventsList"  id="updateOwnerPage" tabstyle="Schedules__tab" sidebar="false">
  <apex:pageBlock title="Hello {!$User.FirstName}!">
        You are displaying Schedules.
       
    </apex:pageBlock>
    <apex:form >
        <apex:pageBlock mode="edit">
            <apex:pageMessages />
            <apex:pageBlockButtons >
                <apex:commandButton value="Save" action="{!save}"/>
            </apex:pageBlockButtons>
            <apex:pageBlockTable value="{!Service.ServiceEvents__r}" var="a">
                <apex:column value="{!a.name}"/>                                           
                <apex:column headerValue="Actual Fee">
                    <apex:inputField value="{!a.Actual_Fee__c}"/>
                </apex:column>
                <apex:column headerValue="Actual days">
                    <apex:inputField value="{!a.Actual_days__c}"/>
                </apex:column>
                <apex:column headerValue="Employee">
                   <apex:inputField value="{!a.Employee__c}"/>
                </apex:column>
                </apex:pageBlockTable>
        </apex:pageBlock>
     </apex:form>
</apex:page>

What am I not understanding?

How can I detect when a custom link has been clicked so that I can update a field? For example if someone clicks on the google maps link on Account. Happy to do some preprocessing before passing the data through to the URL but I cant think of a solution.

Salesforce.com Admin Bootcamp

Is this course for you?

Salesforce.com Admin Bootcamp is designed to get new salesforce.com System Administrators up to speed with the basics of salesforce.com system administration.

It is not designed to replace the salesforce.com Administration Essentials course but we have found that in order to get the most out of that course new adminstrators need to get some hands on experience first, BUT they often need a little jump start t to have the confidence to get started. This course meets that need.

OR if you have been given the job of Assistant Systems Administrator, perhaps taking over when the main Adminstrator is on holiday. This is the course for you.

Cost

The fee for this course including lunch is £350 plus VAT. Payable in advance.

Where

IT Training Room

C/O Progressive Training & Development Ltd
202 Blackfriars Road
Southwark

London
SE1 8NJ

Location Map

When

The next course will be held on the 8th September 2010. The day after Cloudforce London 2010. Call us on 01246 267761 for information on other dates or bookmark our website for updates. There are 4 places left on this course.

Course Agenda

• Course Overview  9.00 - 9.15
• How to use Help and Training 9.15 - 9.30
• Salesforce CRM Overview 9.30 - 9.45
• Custom fields 9.45 - 10.30
  • Different types of Custom fields
  • Set up a Custom field
  • Create and modify a Dependent Picklist
  • Create and modify a Lookup field
  • Create and modify a formula field
• Page Layouts 10.30 - 11.00
  • The elements within a Page Layout
  • Create and modify a Page Layout
  • Customize a related List
  • Create and modify a record type
  • Set up field-Level Security
• Break 11.00 - 11.15
• Data Validation  11.15 - 11.30
  • Create Data Validation rules
• Workflow 11.30 -12.00
  • Differences between immediate and time-dependent Workflow
    actions
  • Set up a Workflow rule and associated actions
• Custom Objects, Applications, & Tabs 12.00 - 12.30
  • Create a Custom object
  • Create a Custom object tab
  • Create a Custom app
• Lunch 12.30 - 13.00
• User Management  13.00 - 13.30
  • Information captured on the User record
  • Create and maintain User records
• Profiles 13.30 - 14.00
  • What a Profile controls
  • Managing profiles
  • When to create a Custom Profile
• Record Sharing 14.00 -  14.45
  • Record owner concept
  • Elements of the Sharing model
  • The use of Roles 
  • Building Sharing rules
• Break 14.45 - 15.00
• Data Management 15.00 - 16.00
  • The function of an external ID
  • The different tools for data migration
  • Data import wizard
  • When to use the Data Loader

We are trying to get our products into our environment ready for launch on Tuesday of next week but we have hit a barrier that we don't have the skills or knowledge to cope with.

Is anyone available for paid work to help us between now and then?

Background:

We are a service company based int he UK that offers collection services. We use a network of contractors to carry out those services. The services can be in a combination of forms dependant on three things:

1. Type of container (10 options)
2. Size of container (10 options)
3. Type of container cargo (10 options)

What we are looking to do is:

Build a Custom Object to manage our vendor services. This would be:

• Vendor details (taken from Account)
• Vendor postcodes covered - multi-select
• Vendor containers offered in those Postcode areas
• Vendor sizes offered
• Type of Container Cargo offered
• Price for each combination

Modify the Opportunity Product to add in the ability to select product variables as well as Quantity:

•  Frequency of Collection
•  Size of Container
•  Type of Product

We then need a lookup to check which of our Vendors can match the product combination, which will then return a Price and the Vendor

Hope that makes sense. Would love to hear from anyone interested in this work who can begin immediately.

Philip

I need to write a report to identify all the users not logged in the last 7 days  via the browser and I cannot think of any criteria that will give me the result I want because last login includes Outlook sync.

HI

I am creating a formula field, in that contact name is required. But I am unable to find contact name field. It is displaying error screen "doesn't exist name field". Anybody have any idea why name field is not listed while creating name fiels.

Thanks.

Hi,

I've previously posted regarding recursive data structures. But, as it now turns out, it's still causing me some headache.

What I want to model is a many-to-many relationship between the same custom object.

My scenario is this:

I have a custom object called Sales Product. Any Sales Product has a Type of either Subscription, One-Time Fee or Bundle.

Now, the issue is this. In my data model a Sales Product of Type Bundle holds a list of other Sales Products (where Type isn't Bundle). However, these Sales Products (where Type isn't Bundle) must be able to be part of many bundles which brings me back to a many-to-many relationship between Sales Product and Sales Product.

When reading through the documentation of many-to-many relationships the followint is stated: "You cannot create a many-to-many self relationship, that is, the two master-detail relationships on the junction object cannot have the same master object."

I'm guessing it's exactly that sentence that's preventing me from creating a many-to-many relationship between 2 x Sales Product.

A recursive data structure is fairly common these days. Is there any known workaround for this limitation which would help me overcome my headaches?

Thanks.

/Søren Nødskov Hansen

I have 50 dashboards each with 10 components. Each dashboard analyses a particular territory. At the moment I  need to only maintain 10 reports to drive all 50 dashboards because there is a 1 to 1 correspondence between territory and user so I can set each dashboard to the appropriate running user and use the My records filter in the report. In future however it may be that every territory does not have an associated user so I would be faced with maintaining 500 reports. I was just wondering if anyone can think of a way of passing a value from the dashboard to the report so that it can filter on the appropriate territory. Or any other solution that has the same effect.  

Hi,

I was aking support:

"how can I define a field in account that shows "true" if at least one contact of this account has a certain value in an attribute?"

Answer was:
"This cannot be done due to the master child relationship between accounts and contacts."

In a programming language I would iterate over each child (contact) and set a boolean variable to true if the first contacts boolean variable is true. This is a pretty simple task and I am wondering why this is not possible.

If there qould be e.g. a Rollup Summary for to contacts-leads this would be a solution. It is not.

Does anyone have a comment for me?

Greetings

Sabine

I want to be able to calculate by default, the sales tax for california depending on the city the Account is located in...in the Opportunites page.   I have downloaded the cities and tax rates for california in a spreadsheet and want to incorporate in a formula for the default area in the sales tax field in Opportunities.   Keep in mind the names of the cities in California may be the same as other cities in other states, so we need to identify California as well.  Thanks.

Hi -

I am looking for the fastest way possible to mass delete all records for a given custom object. I developed a very simple Batch Apex class which is described below.  The code works but it performs very slowly. Yesterday it took 40 minutes to delete 34,000 records, although I did not run into any governor limits.  It seems that the execute() call is only receiving a few records at a time.  Is there any way to coax it to process large groups of records?

Any help would be greatly appreciated.

{

  {

  }

   {

   }

  {

  }

}

A previously working Visualforce page now generates the following error message