• Eddie Prignano
  • NEWBIE
  • 0 Points
  • Member since 2019

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 4
    Replies
We're trying to link call recordings stored on an SFTP server to Salesforce.  We don't want to store the call recordings in Salesforce, just provide a link.  However, SFTP (in Chrome) prompts the end user to open a 3rd Party App.  Also, Salesforce doesn't allow the URL link to start with 'SFTP' only 'FTP'.  I'm using a merge field on the Task to lookup the right call recording file.  Ideally I'd want to listen to the call recordings directly in Salesforce. Any suggestions?
My end goal is that when an Account charges back (Account.Funding_Status__c = "Requires Review") that Process Builder triggers a Flow.  The Flow then gets all of the associated Payables (custom object) records, and then creates new Payables with the negative value of the Payable.Amount_Paid__c.  I managed to get it to create a Payable, and it's setting the Account__c (lookup field) on the Payable correctly, but it's not setting the Amount__c on the Payable.  I really want to learn how to do this! I'm attaching a bunch of screenshots of the Flow.  Thanks!

User-added imageUser-added imageUser-added imageUser-added imageUser-added image
Hi.
I have a scheduled flow that loops through specific tasks created in the last 24 hours and checks if the contact exists, and if the campaign member exists and if it doesn't, it adds a new campaign member. When I run it in debug mode it works fine.  However, when it runs on schedule it is failing as it is trying to create the campaign members multiple times (around 11,000 times !).  When I look through the log (which is too long to post), it is only running through each task once and working perfectly. In this example just 21 tasks to loop through. So when running in debug mode, it is identical except it only tries to create one of each record and doesn't fail.

Has anyone come across something like this before? Are there any specific differences between running in debug mode and running in schedule mode?

This is the flow, it is fairly basic:
User-added image
Not sure what else I can provide to help, This is an excerpt from the log on a record that is trying to create multiple times:

Loop Through: [00T0600004WVxFyEAL,00T0600004WVxR1EAL,00T0600004WVxUPEA1,00T0600004WVxUWEA1,00T0600004WVxuwEAD,00T0600004WVy5aEAD,00T0600004WVyO8EAL,00T0600004WVzOzEAL,00T0600004WVzwFEAT,00T0600004WW0G8EAL,00T0600004WW0QgEAL,00T0600004WW0pgEAD,00T0600004WW0wtEAD,00T0600004WW1MpEAL,00T0600004WW38bEAD,00T0600004WW3OOEA1,00T0600004WW3hqEAD,00T0600004WW5UYEA1,00T0600004WW5XtEAL,00T0600004WW5hDEAT,00T0600004WW7ODEA1,00T0600004WW9mOEAT]
Iteration: 2
Current iteration item: 00T0600004WVxUPEA1
GET RECORDS: Get_Contact
Find one Contact record where:
Phone_No_Spaces__c Contains {!LoopThrough.NVMContactWorld__Customer_Number__c} (+44numberremoved)
Result
Successfully found record.
{!ContactID} = 0031o00001vT9pZAAS
DECISION: Contactisnotnull
Outcome executed: ContIsNotNull
Outcome conditions:
{!ContactID} (0031o00001vT9pZAAS) Is null false
GET RECORDS: CampMemberExists
Find one CampaignMember record where:
CampaignId Equals {!LoopThrough.CampaignID__c} (7011o0000016RfmAAE)
AND ContactId Equals {!ContactID} (0031o00001vT9pZAAS)
Result
Failed to find record.
DECISION: DoesMemberAlreadyExist
Outcome executed: CampMembdoesnotExist
Outcome conditions:
{!CampaignMemberID} (null) Is null true
ASSIGNMENT: AssignIndividual
{!CampaignMemberSingle.CampaignId} Equals {!LoopThrough.CampaignID__c}
{!CampaignMemberSingle.ContactId} Equals {!ContactID}
{!CampaignMemberSingle.How_Member_Added__c} Equals {!AddedBy}
Result
{!CampaignMemberSingle.CampaignId} = "7011o0000016RfmAAE"

Many thanks in advance for any help.
My end goal is that when an Account charges back (Account.Funding_Status__c = "Requires Review") that Process Builder triggers a Flow.  The Flow then gets all of the associated Payables (custom object) records, and then creates new Payables with the negative value of the Payable.Amount_Paid__c.  I managed to get it to create a Payable, and it's setting the Account__c (lookup field) on the Payable correctly, but it's not setting the Amount__c on the Payable.  I really want to learn how to do this! I'm attaching a bunch of screenshots of the Flow.  Thanks!

User-added imageUser-added imageUser-added imageUser-added imageUser-added image

Hello,

 

Not sure this is the right forum for this topic, if not please kindly suggest alternative forum.

 

Looking for information on how to setup the mechanism to pull/decrypt and load in Salesforce objects encrypted CSV files containing customers information and hosted on SFTP server. 

 

Would be glad to receive suggections on recommended procedures, tools and best practices.

 

Thanks,

S