This tag works: {!relatedTo.Owner.Name}
This tag does NOT work: {!relatedTo.Owner.Title}

I've also tried using {!User.Title} and {$User.Title}

Any suggestions on how to get to the rest of the Owner fields?
Thanks!
Barry

When attempting to use Salesforce dataloader 52.0.0/Mac to log into a production org I get the following error:
 

I'm kind of a newbie, so please excuse if this is simplistic - but I can't find anything on it. Here goes:

 

WIthin Visualforce, is it possible to look at a cell in ANOTHER row and format the current cell based on it what it finds?

 

In Excel's conditional formatting it would be something like =IF(A2 <> A1, black, grey)

 

All I want is to change the style of  a cell if the one above it is the same, giving me:

 

Type SKU

Switch	17982
Switch	17983
Switch	17985
Button	17988
Button	17989
Knob	19827
Knob	19829

 

 

While something like this could be achieved within the controller, I'm trying to make it work on a Visualforce page so that if dynamic filters within the page are applied, the page formatting adjusts without having to do another query.

 

I did find another post which does something similar within the same row, (Re: conditional styling in table), but there's no mention of how this type of referential access might be achieved within a table.

 

Has anyone done something similar? If so, how did you manage? Any help is most appreciated.

 

 

I could  really use some perspective and advice. I have an application where fields on a custom object need to be populated by combining choices from various select lists on parent and grandparent objects.

 

My issue comes up when the parent/grandparent select lists are changed - what's the best way to handle it?

 

1. Should I use (somewhat complex) formula fields on the children that point up to the parents and combine the choices based on rules? ; or,
2. Should I build a trigger with these rules which updates a static text field on all of the children whenever a parent is changed?

The benefits of a formula are that I don't have to touch what could be thousands of children everytime a select list is changed, however I am starting to have to dance around formula compiled character limits.

 

The benefits of using a trigger is that it's more flexible, the code is in one place and the formula compiled character limits don't apply.

 

I guess I don't know if I'm going to take a performance hit of some kind by using the trigger option and updating thousands of records - potentially many times if I have a user who keeps changing his mind on some naming scheme thereby continuing to update all of the children. A formula is just a live reflection of the parent so no update is neccesary. If I properly bulkify the trigger is that all I need to worry about?

 

Am I missing anything else? Is there best practice when it comes to this?

 

Thanks much for any persepctive.

 

Alex

 

 

Can you build a custom object with some Apex code?

 

 

 

 

Hi all,

 

I am trying to make a field which displays this:

 

48 x 180 (8,640)

 

But I'm getting this (no separators):

 

48 x 180 (8640)

 

Here's the code I'm using:

 

TEXT(Lot__r.Unit_Count__c) & " x " & TEXT(Lot__r.kg_unit__c) &" (" & TEXT((Lot__r.Unit_Count__c * Lot__r.kg_unit__c)) & ")"

 

Is there a simple way to insert comma separators in TEXT numbers - or perhaps a better way to do this? I am stumped and think the only way must be to write some combination of RIGHT and TRIM statements - or something else? This must have come up before, right?

 

It's easy in APEX:

 

<apex:outputText value="{0, number, ###,###,###,###}"><apex:param value="{!Quote.Total_Price__c}"/></apex:outputText>

 

...but does not work in formula fields.

 

What am I missing? Thanks much for any help.

 

Alex

 

 

 

Hi All -

 

I am new, so please forgive my green - but I am having a perplexing problem in generating a Visual Force email template showing related lists for a custom object.

 

I CAN get a list of Cases related to an Account with no problem, but when I put in a custom object  (Child Relationship Name "Suppliers") which is also (Master-Detail) related to Account I get the following error: Error: Invalid field Suppliers for SObject Account

 

I have tried everything I can think of - using API name instead, appending "__c" to the end, but it seems that i can't make any lists at all with custom objects in this code.

 

Is there a restriction within this type of code that allows only lists with standard objects or is there something I'm missing?

 

Any help would be greatly appreciated. I am not good enough to make a custom Apex controller yet and a little under the gun to kluge something together.

 

Thanks much,

 

Lex

 

Below is relevant code:

 

 

<messaging:emailTemplate recipientType="Contact"
    relatedToType="Account"
    subject="Supplier report for Account: {!relatedTo.name}"
    replyTo="support@acme.com" >
<messaging:htmlEmailBody >   
<html>
    <body>
     <STYLE type="text/css">
           TH {font-size: 11px; font-face: arial;background: #CCCCCC; border-width: 1;  text-align: center } 
           TD  {font-size: 11px; font-face: verdana } 
           TABLE {border: solid #CCCCCC; border-width: 1}
           TR {border: solid #CCCCCC; border-width: 1}
     </STYLE>
         <font face="arial" size="2">
      <p>Dear {!recipient.name},</p>
      <p>Below is a list of supplier records related to the account: {!relatedTo.name}.</p>
<table border="0" >
        <tr > 
            <th>Action</th><th>Product</th><th>Status</th><th>Creator Email</th><th>BL date</th>
         </tr>
<apex:repeat var="cx" value="{!relatedTo.Suppliers}">
   <tr>
       <td><a href="https://na1.salesforce.com/{!cx.id}">View</a> |  
       <a href="https://na1.salesforce.com/{!cx.id}/e">Edit</a></td>
(...snip...)

 

 

This is driving me crazy, looks right to me but I'm missing something!

I need to validate a flow input. There are 2 fields, a date and a number. One of the fields must be populated. The date field validation is
 

AND (
    AND (
         NOT(ISBLANK({!End_Date})),
         NOT(ISNULL({!End_Date}))
    ),
    OR (
        ISNULL({!Number_of_Occurrances}),
        ISBLANK({!Number_of_Occurrances}),
        {!Number_of_Occurrances} = 0 
    )
)

and I have the opposite validation on the number field

When attempting to use Salesforce dataloader 52.0.0/Mac to log into a production org I get the following error:
 

Good morning all,

I just integrated the display of steps by adding a progress indicator to a Flow Screen.

My flow display now the steps correctly but since the integration of the component on the screens, validation checks that must display an error and click on "previous" button crash the flow is displayed the following message: The delimiter of "Company / Representative "stage is missing.

I used the same code provided on this page:

https://developer.salesforce.com/docs/atlas.en-us.216.0.lightning.meta/lightning/components_config_for_flow_screens_stages.htm

Can you help me please ?

I want in a formula field the linefeed being replace with a comma. Although I used the chr(10) equivalent thru my numpad, it doesn't replace it. How can I do it ?

I am trying to create a Chatter post from a visual workflow.  When an Oppty is won, I want to create a Chatter post congratulating the Oppty owner and have it come from their Manager.  So far I can I can do all that using the Create Record Action


The issue I am running into, I want to @mention the Manager (so they know they "sent" a chatter post) so I created a text body formula:
 
but the Chatter post is listing the id, and not doing a true @mention


Any ideas on how to do a proper @mention via a formula?

Thanks, 

Todd B. 
 

Any idea how to move old notes to the new enhanced notes and maintain the original owner/creator and date/time?

Hello All,
     I'm stuck in the middle of this problem I don't know how check from which source user page extrated. If I open user page first in salesforce classic and after I switch it to Lightning.
Thanks to all of you in advance

Regards'
Taresh Pandey

I'd like to get our business users to more completely fillin in the Description text and Inline Help for many custom fields.  Visiting each via the web interface to definitions would be tedius.  What I'd like is a way to import/export/report metadata for custom field definitions are flat fields.  (Editing XML is a bit too techie.)  Unfortunately, unlike most RDMSs, SF doesn't represent Metadata as data so you can't use SOQL on metadata or update it with Apex.  I know there is a Metadata API but I don't have time to write an application using it to build an editor.

Does anyone know of any existing utility that will allow exporting, reporting, and importing of some attributes of custom fields? 

I'd want to export/report the type, name, api name, description, and inline help.  I'd like import description and maybe inline help.

Any ideas?

I am trying to create a field that shows consolidated address information based on which field has information in it. Show the Shipping Address unless it is blank, then show the Billing Address. I want to make several separate fields - Address, City, State, ZIP, Country. I am getting the error: "Formula result is data type (Location), incompatible with expected data type (Text)".

My formula is: IF(  ISBLANK( ShippingAddress ) ,  BillingAddress , ShippingAddress)

There is no option in Formula to make the type "Location" only "Text".

Any help on how to make the formula would be appreciated.

Hi Guys,

 

I understand it's native functionality within the quoting/quote sync functionality for when you have existing quote line items synced, if you create a new quote agains that opportunity, it copies the line items from the previous quote.

 

There's got to be a way around this, even if it involves code, right? Does anyone have experience with this type of business requirement or know how it could be accomplished? Thanks for the help!!!

Hi,

 

My knowledge on coding is very basic so I am not sure it is possble to do what I'd like or if I have to find an alternate solution.   Basically I am rendering a pdf which lists of of the delegates who have attended a training course and stating if they have passed or failed. 

 

I am doing this in a pdf attachment to an email.  I had it working fine until I found a course with 30+ delegates as the table just continues to render over the page footer and beyond.  Is there anyway to easily split this table after 30 entries (I would like to avoid anything creating controllers etc as they are over my head)?

 

This is my code (the red section is the data table):

 

<messaging:attachment renderAs="pdf"  filename="Exam results notification">
<html>
<head><style type="text/css" media="print">
body {color:#666666; font-family:"Arial Unicode MS"; font-size:11pt; font-style:normal; }

@page{
    @bottom-left {                  
    content: element(footer);      
    }   
    size: A4 portrait;
    margin-top:0cm;
    margin-left:0cm;
    margin-right:0cm;
    margin-bottom:0cm;  
}

div.footer {
   display: block;
   position: running(footer);
   line-height: 10pt;
   font-size: 7.5pt;
   color: #A9A9A9;
   z-index:2;                
}
   
</style>
</head>

<body>


<img src="{!URLFOR($Resource.Template)}" style="position: fixed; left: 0cm; top: 0cm;  z-index:-2;" width="21cm" height="29.7"/>

 <apex:dataTable cellpadding="2" width="15.92cm" border="0.2" style=" text-align:center; position: fixed; left: 2.54cm; top: 8cm; line-height: 12pt; font-size:11pt; z-index:+2;" columns="5" value="{!relatedTo.Enrollments__r}" var="cx" >

               <apex:column width="3cm"  >  
                   <apex:facet name="header">Number</apex:facet>
                       {!cx.name}       
               </apex:column>
               <apex:column >
                      <apex:facet name="header">姓名</apex:facet>
                             {!cx.delegate_name__r.LastNameLocal}{!cx.delegate_name__r.FirstNameLocal}
               </apex:column>
               <apex:column >
                      <apex:facet name="header">單位</apex:facet>
                          {!cx.delegate_name__r.department}     
               </apex:column>
               <apex:column >
                     <apex:facet name="header">英文姓名</apex:facet>
                         {!cx.delegate_name__r.LastName}{!cx.delegate_name__r.FirstName}
               </apex:column>
               <apex:column width="2cm" >
                   <apex:facet name="header">Pass/Fail</apex:facet>
                       {!IF(OR(CONTAINS(cx.Exam_results__c,'Fail'),CONTAINS(cx.Exam_results__c,'fail')),'F','P')}
               </apex:column>
               
        </apex:dataTable>



<table width="15.92cm" valign="top" style="position: fixed; left: 2.54cm; top: 27.1cm; line-height: 10pt; font-size:7.5pt; color: #A9A9A9;" >
  <colgroup>
    <col span="4" width="3.98cm" />
  </colgroup>
<tr valign="top">
<td>
address
</td>
<td>address</td>
<td></td>
<td></td>
</tr>
</table>
</body></html>
</messaging:attachment>

 

Many Thanks for any help you can offer.

 

Hi all,

 

I am trying to make a field which displays this:

 

48 x 180 (8,640)

 

But I'm getting this (no separators):

 

48 x 180 (8640)

 

Here's the code I'm using:

 

TEXT(Lot__r.Unit_Count__c) & " x " & TEXT(Lot__r.kg_unit__c) &" (" & TEXT((Lot__r.Unit_Count__c * Lot__r.kg_unit__c)) & ")"

 

Is there a simple way to insert comma separators in TEXT numbers - or perhaps a better way to do this? I am stumped and think the only way must be to write some combination of RIGHT and TRIM statements - or something else? This must have come up before, right?

 

It's easy in APEX:

 

<apex:outputText value="{0, number, ###,###,###,###}"><apex:param value="{!Quote.Total_Price__c}"/></apex:outputText>

 

...but does not work in formula fields.

 

What am I missing? Thanks much for any help.

 

Alex

 

 

 

Hi All,

 

Does anyone know how to output the day text part? ie for 1st, it would be 'st', 2nd 'nd', etc. It doesnt seem possible with Java date formatting: http://java.sun.com/j2se/1.4.2/docs/api/java/text/SimpleDateFormat.html

 

Thanks in advance.