Ask Search:
Heidi BroseHeidi Brose 
Are there any work arounds to show files on parent records? For example, the files related to a contact should show on the parent record as well.  
Best Answer chosen by Heidi Brose
Magulan DuraipandianMagulan Duraipandian
No. Files will have only one field(ParentId).
Magulan Duraipandian
Natalia KataokaNatalia Kataoka 
I am attempting to create a Flow that clones opportunities with field updates. I need to pass the Account ID from the original opp to the new cloned opp, but it was pulling the original Opp ID, not the Account. I made some modifications but am now getting the error:
There was a problem running this flow. Contact your system administrator with this error message: The input variable Account_Name doesn't exist in the active version of the flow Create_SW_Renewal_Opp

Here are some screenshots of what I have:
User-added image

User-added imageUser-added image

User-added image
Any ideas?
Best Answer chosen by Natalia Kataoka
Deepak AnandDeepak Anand
You need to do this = 
  • Create a variable of type - String
  • Name it as - recordId
  • Set the Input/Output Type to - Input and Output
Now after you drag and drop the the Flow, you will see a checkbox saying if you want to assign the Opportunity Id to the Public Variable inside the Flow called recordId. Please do check it.

Now back in the Flow, you have to query the Opportunity using a Fast Loop and have a criteria that says =
Id equals {!recordId}
Don't forget to query the AccountId field too.

Then I suppose you get the idea. Right ?
Kevin PerryKevin Perry 
I'm adding a new contact under opportunity contact roles because the desired contact is not in Salesforce yet.  While i'm adding the contact, i realized that the account doesn't exist either.  Is there a way to add an account from the screen below?
User-added image
User-added image
Best Answer chosen by Kevin Perry
Narender SinghNarender Singh
Hi Kevin,
Unfortunately, we cannot. This is a standard functionality of a standard Lightning component.
We can only associate the contact to an existing Account. If the account doesn't then we will have to first create an Account and then associate the new contact at the time of creation.
M RothM Roth 
I'm trying to understand this question and it's answer.    

A system administrator needs to mass update the lead source of opportunity records.  How can this be accomplished?
1.  Create a list view for opportunities and update via inline editing.
2.  Export opportunities and update using Import Wizard.

From my study, isnt #2 incorrect?  This should be export oppty and update using Data Loader?  What am I missing here?  
Best Answer chosen by M Roth
Prabhat SharmaPrabhat Sharma
You're absolutely correct. Data import wizard allows only few Standard Object to be imported in Salesforce. You'll have to use Data Loader, tools to update Opportunities.  
Best Answer chosen by vijith .
Prashant PandeyPrashant Pandey
Hi Vijith, can do this in After the Summer 2018 release. You may also need to check your critical update setting.

Dan FDan F 
Is it possible to automatically populate a Text Area field based on the selection of a different picklist?

For example:

Picklist 1 = "Yes"
Text Area = "Client Accepts"

Picklist 1= "No"
Text Area = "Client Declines"

Picklist 1 = "Other"
Text Area = BLANK so that the user can type into
Best Answer chosen by Dan F
Amnon KruviAmnon Kruvi
Hi Dan,

You can achieve this with a simple process. Open Process Builder and create a new process for your object. In the step conditions, select <Picklist> Is Changed = True. Then, add an Immediate Action with a type of Update Record, and use the following formula:
IF (ISPICKVAL(Picklist__c, "Yes"), "Client Accepts", IF (ISPICKVAL(Picklist__c, "No", "Client Declines"), "Other"))

Giancarlo SilvestriGiancarlo Silvestri 
Hi all!

We have a process that posts to chatter when certain chriteria are met on a custom object. We would like to know if there is a log, or if we can run a report on when the process has fired, and which record triggered it.

Thanks in advance for your help!
Best Answer chosen by Giancarlo Silvestri
Mayank shahMayank shah
This article will help you:
Jardell EugeneJardell Eugene 
I'm trying to write a trigger that creates a new car record when Case is created. I know I can use process builder for this, but this is only a piece of my code. I will eventually work my way up to creating multiple records, based on other criterias given. Could someone take a look at my code, and let me know if they see anything out of the norm. 

Thank You !

User-added image
Best Answer chosen by Jardell Eugene
Mayank shahMayank shah
Developer forum is the better place for development related question. You can try asking on 

Refer the correct API name for the object in the code.
If you want to write a field in the Car object then it will be a.field API Name = some value ;
Jeffrey Jonathan JeyarajJeffrey Jonathan Jeyaraj 
I'm trying to create a formula field that will display the week of the month of a date field.

Thanks in advance!
Best Answer chosen by Jeffrey Jonathan Jeyaraj
Steve DoddSteve Dodd

See if something like this will work for you:

Formula Return Type = Number
IF(DAY(DateField) / 7 < 1 , 1 , 
IF(DAY(DateField) / 7 < 2 , 2 , 
IF(DAY(DateField) / 7 < 3 , 3 , 
IF(DAY(DateField) / 7 < 4 , 4 , 
IF(DAY(DateField) / 7 < 5 , 5 , 

* Use the Insert Field button in the formula editor to select your date field.
Emma SnowdenEmma Snowden 
I have spent hours looking through solutions on displaying Case Age in business days i.e excluding weekends. I finally thought i had got one to work but upon reviewing some cases it is not showing the correct amount of days. i have a case raised on the 14/06/2018 10:47 and as of now 19/06/2018 15:35 it is calculating that it has only been open 1 day. Here is my formula - i am self taught on SF so appreciate this may be super obvious to some people! If you can make any tips as clear and simpe as possible that would be great! 
i will point out that i barely understand the below and it has only been though helpful community posts i have got this far! 

CASE(MOD( DATEVALUE(CreatedDate) - DATE(1900,1,08),7), 

0 , CASE( MOD( CreatedDate - ClosedDate ,7),1,2,2,3,3,4,4,5,5,5,6,5,1), 
1 , CASE( MOD( CreatedDate - ClosedDate ,7),1,2,2,3,3,4,4,4,5,4,6,5,1), 
2 , CASE( MOD( CreatedDate - ClosedDate ,7),1,2,2,3,3,3,4,3,5,4,6,5,1), 
3 , CASE( MOD( CreatedDate - ClosedDate ,7),1,2,2,2,3,2,4,3,5,4,6,5,1), 
4 , CASE( MOD( CreatedDate - ClosedDate ,7),1,1,2,1,3,2,4,3,5,4,6,5,1), 
5 , CASE( MOD( CreatedDate - ClosedDate ,7),1,0,2,1,3,2,4,3,5,4,6,5,0), 
6 , CASE( MOD( CreatedDate - ClosedDate ,7),1,1,2,2,3,3,4,4,5,5,6,5,0), 

(FLOOR(( CreatedDate - ClosedDate)/7)*5), 
CASE(MOD( DATEVALUE(CreatedDate) - DATE(1900,1,08),7), 

0 , CASE( MOD( CreatedDate - NOW(),7),1,2,2,3,3,4,4,5,5,5,6,5,1), 
1 , CASE( MOD( CreatedDate - NOW(),7),1,2,2,3,3,4,4,4,5,4,6,5,1), 
2 , CASE( MOD( CreatedDate - NOW(),7),1,2,2,3,3,3,4,3,5,4,6,5,1), 
3 , CASE( MOD( CreatedDate - NOW(),7),1,2,2,2,3,2,4,3,5,4,6,5,1), 
4 , CASE( MOD( CreatedDate - NOW(),7),1,1,2,1,3,2,4,3,5,4,6,5,1), 
5 , CASE( MOD( CreatedDate - NOW(),7),1,0,2,1,3,2,4,3,5,4,6,5,0), 
6 , CASE( MOD( CreatedDate - NOW(),7),1,1,2,2,3,3,4,4,5,5,6,5,0), 

(FLOOR(( CreatedDate - NOW())/7)*5))
Best Answer chosen by Emma Snowden
Briana LametBriana Lamet
CASE(MOD( DateValue(CreatedDate)  - DATE(1985,6,24),7),  0 , 
CASE( MOD( Today() - DateValue(CreatedDate)  ,7),1,2,2,3,3,4,4,5,5,5,6,5,1), 1 , 
CASE( MOD( Today() - DateValue(CreatedDate)  ,7),1,2,2,3,3,4,4,4,5,4,6,5,1), 2 , 
CASE( MOD( Today() - DateValue(CreatedDate)  ,7),1,2,2,3,3,3,4,3,5,4,6,5,1), 3 , 
CASE( MOD( Today() - DateValue(CreatedDate)  ,7),1,2,2,2,3,2,4,3,5,4,6,5,1), 4 , 
CASE( MOD( Today() - DateValue(CreatedDate)  ,7),1,1,2,1,3,2,4,3,5,4,6,5,1), 5 , 
CASE( MOD( Today() - DateValue(CreatedDate)  ,7),1,0,2,1,3,2,4,3,5,4,6,5,0), 6 , 
CASE( MOD( Today() - DateValue(CreatedDate)  ,7),1,1,2,2,3,3,4,4,5,5,6,5,0),   999)   
+ (FLOOR(( Today() - DateValue(CreatedDate)  )/7)*5-1),
CASE(MOD( DateValue(CreatedDate) - DATE(1985,6,24),7),  0 , 
CASE( MOD( DateValue(ClosedDate) - DateValue(CreatedDate) ,7),1,2,2,3,3,4,4,5,5,5,6,5,1), 1 , 
CASE( MOD( DateValue(ClosedDate) - DateValue(CreatedDate) ,7),1,2,2,3,3,4,4,4,5,4,6,5,1), 2 , 
CASE( MOD( DateValue(ClosedDate) - DateValue(CreatedDate) ,7),1,2,2,3,3,3,4,3,5,4,6,5,1), 3 , 
CASE( MOD( DateValue(ClosedDate) - DateValue(CreatedDate) ,7),1,2,2,2,3,2,4,3,5,4,6,5,1), 4 , 
CASE( MOD( DateValue(ClosedDate) - DateValue(CreatedDate) ,7),1,1,2,1,3,2,4,3,5,4,6,5,1), 5 , 
CASE( MOD( DateValue(ClosedDate) - DateValue(CreatedDate) ,7),1,0,2,1,3,2,4,3,5,4,6,5,0), 6 , 
CASE( MOD( DateValue(ClosedDate) - DateValue(CreatedDate) ,7),1,1,2,2,3,3,4,4,5,5,6,5,0),   999)   
+  (FLOOR(( DateValue(ClosedDate) - DateValue(CreatedDate) )/7)*5-1))