Hey guys,

I have two custom objects: A and B. I want to relate these two objects via tags. So for example I show object A on my Visualforce page. Now every object B that has the same tags as object A should show up under object A:

VF Page:

A (tags: x,y,z)

-B (tags: x,y)

-B (tags: y)

-B (tags: x,z)

How can I realize that? How would the SOQL query look like?

Thank you very much for your effort,

Josh :-)

Hi guys,

I imagine a visulaforce site with a daily switching content (i.e. tip of the day). What would be the best solution to implement this requirement?

Thank you,

Josh

Hi guys,

I know that it is possible to make a full Salesforce data export.

But is it possible to import the whole created *.zip file to a new Salesforce org at once, too?

Hello guys,

I'd like to know more about a Salesforce data export to Sharepoint. What would be a convenient solution?

Thank you for any help,

Josh :-)

Hey guys,

how can I remove the "Save & New Buttons"?

Thank you

Josh :-)

Hi guys,

I have a fieldset called "States" with all 51 us states: AL__c, AR__c, AZ__c, CA__c, etc...

Now I want to add all field values and labels to an item list like this (this is pseudo-code):

for( <fieldset-element> : <all fieldset-elements>)

{

items.add(<fieldset-element>.value, <fieldset-element>.label);

}

How can I do that in Apex?

Thanks

Josh :-)

Hi guys,

I was wondering what would be the best solution to provide stock quotes and charts for an account on its detail page...

Do you already have solutions for that?

Hey guys,

I have two questions:

1. How can I enlarge the msgbox?

2. How can I change the sequences of the fields?

Thank you very much for your help!

Josh :-)

Hey guys,

I want to track how many opportunities each sales user has lost/won. My end result looks like this:

Name   |    Won   |    Lost

ABC             23           67

XYZ              12           35

...

My own idea is to create two custom number fields Opps_Won__c, Opps_Lost__c for the object user.

Everytime an opportunity's stage is changed to Won/Lost a trigger fires and increases the number in the corresponding custom field of the opportunity's owner.

I could also get the won/lost counts with a SOQL query for each sales user, but then I would get in conflict with the Salesforce.com query limit, because I want to have an overview over all sales users and I have a lot of sales users....

Any other ideas how I could realize this?

Hey guys,

I want to get data for a table like this:

Owner Name   |   # Converted Leads   |   # Leads

ABC                                      13                            35

DEF                                      33                          101

Can I get the required Information in 1 SOQL statement?

Thanks,

Josh

The custom field type "Picklist" saves its values as Strings. How can I save number values into the database, but having String captions for the picklist?

For example:

The picklist has the following captions:

"Worse"

"Bad"

"Good"

"Better"

When the user picks "Worse" I want the custom field to be saved as 1 into the database, when he picks "Bad" it should be saved as 2, and so on...

Hey guys,

I already know that one can set access rights for vf pages based on user profiles. But what is the best and quickest way to set access rights based on user roles/groups?

Thank you

Josh

HOW am I able to control the visibility of pictures uploaded with the App "Picture Uploader"?

The pictures are saved as attachments. Some users are not able to see my uploaded contact pictures! How can I make them visible to them?

<apex:repeat value="{!params}" var="param">
<apex:dataTable value="{!map[param]}" var="opp" width="100%" align="left">
<apex:column >
 <apex:outputText value="{0, number, $#,###.00}"> <apex:param value="{!opp.Amount}" /> </apex:outputText>
</apex:column>
</apex:dataTable>
</apex:repeat>

Error: The value attribute on <apex:outputText> is not in a valid format. It must be a positive number, and of type Number, Date, Time, or Choice.

Does anybody know why the amount cannot be displayed formatted? {!map} is a Map<String, List<Opportunity>>

It doesn't work for a date, too.

Maybe it's because a map cannot remember datatypes so every field of the opportunity is a String if you access it in Visualforce?!?

Heu guys,

I was wondering whether there's a possibility to have a function with a parameter as a value for an apex:datatable...

My attempt would be something like the following code, but functions don't seem to be accepted as a value...

<apex:repeat value="{!paramters}" var="parameter">
<apex:dataTable value="function({!parameter})" var="item">
...
</apex:dataTable>
</apex:repeat>

 My goal is to have 4 tables with opportunities for each quarter of a year and I want to avoid writing redundant code. The function would return the opportunities and the parameter would be the number of the quarter (1,2,3,4)

Hello guys,

I have a public SFDC site. I want to restrict the access of this site to my corporate's ip range. The site should be visible to guests (no SFDC users). Therefore no login is required to view the site.

But everytime I add an IP Range to the Public Access Settings of the site, it shows the "Authorization Required" site as soon as I access the site :-(

How can I get rid of this "Authorization Required" site?

Thank you

Aljoscha

Hey guys,

the following code gives me headaches:

<apex:pageBlockTable value="{!tasks}" var="task" id="table" style="width:100%;">
        <apex:column >
            <apex:facet name="header">Related Object</apex:facet>
            <apex:outputLink value="https://na4.salesforce.com/{!task.What.Id}">{!task.What.Name}</apex:outputLink>
        </apex:column>
...

 The link in the table column should lead directly to the detail page of the "WhatId" object of the task.

The funny thing is that the links show up correctly in a normal visualforce page within SFDC. But as soon as I use the page in a public site, the links won't show up... What's the problem here?

Thank you in advance

Aljoscha

Hey guys,

I added these sliders to my vf page:

http://developer.expressionz.in/downloads/mootools_double_pinned_slider_with_clipped_gutter_image_v2.2/slider_using_mootols_1.2.html

As soon as I submit the apex:form I want to save the slider values.

How can I do that (The sliders are implemented with JavaScript) ?

Hey guys,

I'm working on a solution how to transfer created Salesforce tasks to Sharepoint.

Does anybody have already experience with the transfer of data from Salesforce to Sharepoint? Any suggestions how to make a real time transfer possible? The first part of my solution would be writing a task trigger after insert in Salesforce. But which code would the trigger contain?

Thank you very much for your help in advance!

Hello guys,

I'd like to know more about a Salesforce data export to Sharepoint. What would be a convenient solution?

Thank you for any help,

Josh :-)

Hi guys,

I know that it is possible to make a full Salesforce data export.

But is it possible to import the whole created *.zip file to a new Salesforce org at once, too?

Hey guys,

how can I remove the "Save & New Buttons"?

Thank you

Josh :-)

Hi guys,

I have a fieldset called "States" with all 51 us states: AL__c, AR__c, AZ__c, CA__c, etc...

Now I want to add all field values and labels to an item list like this (this is pseudo-code):

for( <fieldset-element> : <all fieldset-elements>)

{

items.add(<fieldset-element>.value, <fieldset-element>.label);

}

How can I do that in Apex?

Thanks

Josh :-)

Hi guys,

I was wondering what would be the best solution to provide stock quotes and charts for an account on its detail page...

Do you already have solutions for that?

Hey guys,

I want to track how many opportunities each sales user has lost/won. My end result looks like this:

Name   |    Won   |    Lost

ABC             23           67

XYZ              12           35

...

My own idea is to create two custom number fields Opps_Won__c, Opps_Lost__c for the object user.

Everytime an opportunity's stage is changed to Won/Lost a trigger fires and increases the number in the corresponding custom field of the opportunity's owner.

I could also get the won/lost counts with a SOQL query for each sales user, but then I would get in conflict with the Salesforce.com query limit, because I want to have an overview over all sales users and I have a lot of sales users....

Any other ideas how I could realize this?

The custom field type "Picklist" saves its values as Strings. How can I save number values into the database, but having String captions for the picklist?

For example:

The picklist has the following captions:

"Worse"

"Bad"

"Good"

"Better"

When the user picks "Worse" I want the custom field to be saved as 1 into the database, when he picks "Bad" it should be saved as 2, and so on...

Hey guys,

I already know that one can set access rights for vf pages based on user profiles. But what is the best and quickest way to set access rights based on user roles/groups?

Thank you

Josh

HOW am I able to control the visibility of pictures uploaded with the App "Picture Uploader"?

The pictures are saved as attachments. Some users are not able to see my uploaded contact pictures! How can I make them visible to them?

<apex:repeat value="{!params}" var="param">
<apex:dataTable value="{!map[param]}" var="opp" width="100%" align="left">
<apex:column >
 <apex:outputText value="{0, number, $#,###.00}"> <apex:param value="{!opp.Amount}" /> </apex:outputText>
</apex:column>
</apex:dataTable>
</apex:repeat>

Error: The value attribute on <apex:outputText> is not in a valid format. It must be a positive number, and of type Number, Date, Time, or Choice.

Does anybody know why the amount cannot be displayed formatted? {!map} is a Map<String, List<Opportunity>>

It doesn't work for a date, too.

Maybe it's because a map cannot remember datatypes so every field of the opportunity is a String if you access it in Visualforce?!?

hai friends,

i am trying to pull the stock data from webservicex.net to the salesforce.but when am trying to convert wsdl to apex it will show an error.

i can't predict that error. plz help me to fixed the error.

Error: Unable to find element for {http://www.webservicex.net/}string

this my wsdl file

<?xml version="1.0" encoding="utf-8" ?>
<wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:tns="http://www.webservicex.net/" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" targetNamespace="http://www.webservicex.net/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
<wsdl:types>
<s:schema elementFormDefault="qualified"  targetNamespace="http://www.webservicex.net/">
<s:element name="GetQuote">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="symbol" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
<s:element name="GetQuoteResponse">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="GetQuoteResult" type="s:string" />
  </s:sequence>
  </s:complexType>
  </s:element>

  <s:element name="string" nillable="true" type="s:string" />

 
  </s:schema>
  </wsdl:types>

 <wsdl:message name="GetQuoteSoapIn">
 <wsdl:part name="parameters" element="tns:GetQuote" />
  </wsdl:message>
 <wsdl:message name="GetQuoteSoapOut">
  <wsdl:part name="parameters" element="tns:GetQuoteResponse" />
  </wsdl:message>
 <wsdl:message name="GetQuoteHttpGetIn">
  <wsdl:part name="symbol" type="s:string" />
  </wsdl:message>
 <wsdl:message name="GetQuoteHttpGetOut">
  <wsdl:part name="Body" element="tns:string" />
  </wsdl:message>
 <wsdl:message name="GetQuoteHttpPostIn">
  <wsdl:part name="symbol" type="s:string" />
  </wsdl:message>
 <wsdl:message name="GetQuoteHttpPostOut">
  <wsdl:part name="Body" element="tns:string" />
  </wsdl:message>
 <wsdl:portType name="StockQuoteSoap">
 <wsdl:operation name="GetQuote">
  <wsdl:documentation xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">Get Stock quote for a company Symbol</wsdl:documentation>
  <wsdl:input message="tns:GetQuoteSoapIn" />
  <wsdl:output message="tns:GetQuoteSoapOut" />
  </wsdl:operation>
 
 <wsdl:operation name="GetQuote">
  <wsdl:documentation xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">Get Stock quote for a company Symbol</wsdl:documentation>
  <wsdl:input message="tns:GetQuoteHttpGetIn" />
  <wsdl:output message="tns:GetQuoteHttpGetOut" />
  </wsdl:operation>
 
 
 <wsdl:operation name="GetQuote">
  <wsdl:documentation xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">Get Stock quote for a company Symbol</wsdl:documentation>
  <wsdl:input message="tns:GetQuoteHttpPostIn" />
  <wsdl:output message="tns:GetQuoteHttpPostOut" />
  </wsdl:operation>
  </wsdl:portType>

 <wsdl:binding name="StockQuoteSoap" type="tns:StockQuoteSoap">
  <soap:binding transport="http://schemas.xmlsoap.org/soap/http" />
 <wsdl:operation name="GetQuote">
  <soap:operation soapAction="http://www.webservicex.net/GetQuote" style="document" />
 <wsdl:input>
  <soap:body use="literal" />
  </wsdl:input>
 <wsdl:output>
  <soap:body use="literal" />
  </wsdl:output>
  </wsdl:operation>
 
 
  <soap12:binding transport="http://schemas.xmlsoap.org/soap/http" />
 <wsdl:operation name="GetQuote">
  <soap12:operation soapAction="http://www.webservicex.net/GetQuote" style="document" />
 <wsdl:input>
  <soap12:body use="literal" />
  </wsdl:input>
 <wsdl:output>
  <soap12:body use="literal" />
  </wsdl:output>
  </wsdl:operation>
 
   <http:binding verb="GET" />
 <wsdl:operation name="GetQuote">
  <http:operation location="/GetQuote" />
 <wsdl:input>
  <http:urlEncoded />
  </wsdl:input>
 <wsdl:output>
  <mime:mimeXml part="Body" />
  </wsdl:output>
  </wsdl:operation>
 
   <http:binding verb="POST" />
 <wsdl:operation name="GetQuote">
  <http:operation location="/GetQuote" />
 <wsdl:input>
  <mime:content type="application/x-www-form-urlencoded" />
  </wsdl:input>
 <wsdl:output>
  <mime:mimeXml part="Body" />
  </wsdl:output>
  </wsdl:operation>
  </wsdl:binding>
 <wsdl:service name="StockQuote">
 <wsdl:port name="StockQuoteSoap" binding="tns:StockQuoteSoap">
  <soap:address location="http://www.webservicex.net/stockquote.asmx" />
 
  </wsdl:port>
  </wsdl:service>
  </wsdl:definitions>

thanks in advance

siva

I'm trying to create  visual force page that downloads as Excel or CSV . This works fine for English but for UTF 8 characters like Polish etc. some of the characters get replaced with "?" etc. I'm not sure there's a way to specify encoding when using contentTypes.

The free Inline Account Hierarchy App is very nice, and a good example of how to do clever stuff without nasty code, but when you collapse part of the hierarchy, it doesn't show with a + sign that their are hidden children.

Has anyone been able to add this functionality?