Questions tagged [automation]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
33 views

SQL Query help in Automation Studio [closed]

Trying to use automation studio SQL query to pull out unique values to different DE. What would be the simple script for this? Would Distinct work in this situation? E.g. SELECT Email,FirstName,...
0
votes
0answers
15 views

Campaign CTI Automation

I wanted to know if there is any support for automation of calls in salesforce. Basically, I want to automate campaigns such that we can dial calls to leads/contacts one by one (in order for all ...
0
votes
1answer
25 views

Duplicate automations from one Business Unit to others [closed]

After creating an automation (Data extract + File transfer) in Business Unit A, I would like to duplicate it to other Business Units. Is this possible ? If yes can you explain me how please ? Thank ...
0
votes
1answer
19 views

After last item won't execute in loop salesforce flow

Flow won't move forward the 'After last item'
0
votes
2answers
39 views

Hyperlink field leading to Opportunity Record (Flow and Process Builder)

Thank you for responding. I have taken your advice as best as possible. As of now, I am not receiving any errors, but the fields are not populating when I create a new task that fits the criteria ...
-3
votes
2answers
38 views

Trigger to create a campaign when an account is created [closed]

I am trying to write a trigger that will automatically create a campaign record when a new account is created. Below is my code: trigger AddCampaign on Account(after insert) { List<...
0
votes
1answer
45 views

Automation SQL - get random value for each record [closed]

I need to populate some Data Extension using another Data Extension that contains all the accounts data. I want to attach a new column and the value for that column should be randomized from another ...
2
votes
2answers
41 views

Is there an API Name for the field “User Password expires in” under Password Policies?

I am doing a flow that will notify users when their passwords are about to expire in SF. I have to subtract 7 from the number I set in "User Password expires in" as apart of that automation. ...
1
vote
0answers
21 views

Calling Dynamic Screen Flows

I have a screen flow that displays an agent script dynamically on a lead based its association to a campaign. This uses a parent flow with a decision element that routes to various subflows elements ...
0
votes
1answer
66 views

Copado vs Flosum [closed]

Are there any good comparison between Copado Vs Flosum ? I understand that there are individual choices around these tools but I am looking for a platform which maximizes the developer productivity. ...
0
votes
0answers
70 views

Community - Flow Lookup Component Not Working

I am currently setting up a Salesforce Community page, and I need to allow the users to edit details for their Account record or any Account record linked to their Account. Due to the limited nature ...
1
vote
1answer
41 views

How to delete a report with Code or process?

I want to automate a process where old neglected reports are automatically deleted if they were not run for X amount of days (if I can't do it in a variable/labal, I will do a source report. I am not ...
0
votes
1answer
44 views

SQL query to get Open rate by domain

I'm trying to build an SQL query to get the Open Rate Percentage by domain for an email send through Journey build or scheduled send. Below is the query I have trying to figure out, but it's giving me ...
0
votes
0answers
15 views

SSH Private Key is not accessible file Transfer Activity

I have a pair of SSH keys from my customer and I want to update them into Salesforce to use for Encryption and Decryption. I have no problems with an encryption key, it works just fine. But when I am ...
0
votes
0answers
16 views

Is there any method in Salesforce (or 3rd party apps) to auto-check if User Roles are used in any automations or code?

Is there any method in Salesforce to check for automation or code dependencies on User Roles? Or perhaps there's a 3rd party app that can do this? I want to migrate updates to the role hierarchy ...
0
votes
0answers
32 views

Select statement inside case statement to add rows to DE based on count

I am building an automated productselection. I want to add rows to a DE based on record count. So far Ive come up with underneath solution, but the syntax is not right: An error occurred while ...
0
votes
1answer
262 views

Automate Lead Conversion in Salesforce

In salesforce, lead is converted into Account, Contact, and Opportunity. Opportunity is optional to create upon conversion. The convert button on Lead does the conversion. Is it possible to convert ...
0
votes
2answers
38 views

Divide a Data Extension into 5 segments [duplicate]

I would like to take my data extension, divide it into 5 segments, each segment will have 6000 data, how to do that with SQL? Thank you
0
votes
1answer
20 views

How to prevent redirecting to another page while assigning a flow to custom button

I had created a flow for automating my things. I created a custom button and assigned a flow to it. When I try to press the button it takes me to another page. Can someone tell how can i prevent it ...
0
votes
0answers
21 views

Flow to create a new content note when custom opp field is populated & update same custom field when new content note is created

I have a client who has an active flow (not my dev) that is expected to perform two actions: Create new ContentNote when Opportunity.Last_Note__c is changed Update Opportunity.Last_Note__c with ...
0
votes
0answers
18 views

More users logged than emails sent

Recently I created a Journey powered by an automation. One of the automation steps logs every SubscriberKey that enters the Journey onto a logging data extension. After reviewing performance I noted ...
0
votes
0answers
12 views

Batch sequencing of data load tasks

Is there a way (easy?) to sequence the upsert of data across multiple objects using DataLoader or some other data load tool? As an illustration: I have to update the country field value for the ...
0
votes
0answers
44 views

What is the best way to do Automation?

I'm running into issues with Cypressio and Selenium, and I'm pretty new to automation testing within Salesforce. What is the best thing to do? How to do it? & what are the tools that you recommend ...
0
votes
1answer
15 views

How to add more fields in flow without errors?

I used this link(https://trailhead.salesforce.com/content/learn/projects/build-a-simple-flow/create-or-update-a-contact) to create or update contacts. I finished everything and it does create contacts....
0
votes
1answer
26 views

Launch JavaScript script from auto Process

The requirement is to build PDF in an automate process on records. My solution is to build kind of API on Heroku that will render PDF using a external Framework. I am wondering if there is any way I ...
0
votes
0answers
35 views

Automate Mail Merge Process

Is there a way to set a trigger to generate a mail merge once a field has been checked? I want to generate a donor thank you letter (mail merge document already created and successfully tested) ...
0
votes
0answers
36 views

SFMC Automation using API - I am not aiming to start the automation which contains a query activity and journey entry event

I am setting up an automation which needs to start when an API call is made. This automation will have to run a query that populates a DE. This DE is then used in a journey Background: We are ...
0
votes
1answer
163 views

Using a formula field checkbox in a decision component of a Lightning Flow

I have a lightning flow where a an outcome in a decision component is defined on a custom formula field checkbox set to true. But the flow still moves on the default outcome even when the field is set ...
0
votes
0answers
46 views

PB formula to compare an ID field to a text field?

I have a Relationship Process Builder that populates a Contact text field based on Status=Current and clears the field if someone changes the Status=Former. So far so good. Now how to get the ...
0
votes
1answer
62 views

How to created automated Journey for Google Analytics 360 contacts?

I have integrated Google Analytics 360 with my marketing cloud account. I see it as a Synchronized Data Source in Contact Builder and I can pull it into my Journey in Journey Builder. But, I want this ...
0
votes
1answer
59 views

Retrieve status of automations of all child BUs from enterprise BU

Below is the code which I tried, but when the automation is erroring out the status is populating as paused, scheduled, stopped. The error status is not population. Code: <style> body, a, ...
0
votes
0answers
27 views

Issue with a script running to lookuprows and loop through the lookup until all rows with the same ContactId have been combined into one row

I am running the following script to lookuprows in a data extension and combine multiple rows with the same contactID into one row - but at the same time taking one column (PH_Name) from the separate ...
0
votes
1answer
104 views

Automation of Power Query data extract (bypass login or store password) [closed]

I have a report built in Excel that links into other data sets that I can't upload to Salesforce, so I need to join the data with other sources using power query. Unfortunately I'm unable to automate ...
0
votes
1answer
53 views

Violation of Primary Key while using DISTINCT

Im trying to update a Data Extension with data from another Data Extension, very simple, you'd think. The target Data Extension has SubscriberKey as Primary Key and the source Data Extension doesn't ...
1
vote
1answer
473 views

Automated Process User - Create Event - Insufficient Acess

I'm trying to create an Event via automation, but I keep getting the following error: "INSUFFICIENT_ACCESS_ON_CROSS_REFERENCE_ENTITY." Our process is below A scheduled flow triggers a ...
0
votes
1answer
132 views

Import Activity not Updating all Subscriber List

I have an import activity which fetches the file from MArketing cloud FTP and updates the All Subscriber List(also tried to update/add/overwrite All Subscribers List and a test Data Extention as well)....
0
votes
0answers
74 views

Using SSJS to delete rows from DE's with more than 25 million rows

I have scrolled through these pages but can't seem to find a solution. Here's hoping someone can help me out :) I am using the below SSJS in an Automation to remove rows with IsDeleted = 'True' from a ...
1
vote
1answer
43 views

Journey: Send Email to Sales Team using Filtered Data Extension

I have a form submission Data Extension in Marketing Cloud that creates a Filtered Data Extension to pull in a list of leads that need to alert my sales team. The filtered data extension pulls in a ...
2
votes
1answer
403 views

How do you invoke an external service in a flow triggered by a new Contact Creation?

I am using Salesforce Lightning mode and looking to use the configure not code approach. I have an external service defined. The scenario I am trying to implment is as follows: User Creates Contact ...
0
votes
0answers
144 views

Document CheckList and Einstein Form Reader Permission Sets not available on Winter'21 Preview Instance

I am trying out the 'Intelligent Document Automation' feature that has come in Preview Instances of Winter'21 Release. For using this feature, there are certain Permission Sets, Settings that need to ...
2
votes
0answers
50 views

Issue deploying flow templates as Inactive in Package when there is a Subflow

I have a Managed Package with two Flow Templates. FTParent is a parent flow template, and the other (we will call it FTsub) is also a flow template. Initially, they were both packaged as Active, and ...
1
vote
0answers
985 views

TypeError: Cannot read property 'click' of undefined in puppeteer

I have checked manually the x path of this particular link but still it gives me the error. here is the portion of my code i am getting error in. element = await page2.$x(`//a[contains(text(),'...
0
votes
0answers
738 views

Unable to find a particular selector although it is present in dom using puppeteer for automation

I am having a problem in finding a selector in "//for clicking certain items". I have tried document.querySelector() in console and it still is not finding the selector. const puppeteer = ...
0
votes
1answer
49 views

enable Forecasts and other settings via CLI

In order to prepare new scratch org I need to enable a few settings. Those settings are: enable Forecsts, enable Scheduling, enable Field Service, and few more... This is doable by clicking in ...
0
votes
2answers
108 views

Marketing Cloud FTP --> Automatic Delete Functionality

Is there a way to setup a rule so that your Marketing Cloud FTP will delete a file older than a certain date?
0
votes
3answers
60 views

How to A/B split a table as part of a query [closed]

Hey guys have a simple use case; I want to take a table and assign 80% of the records a variable of 'A' and the remaining 20% of records a variable of 'B' I know I could easily accomplish this in 2 ...
0
votes
0answers
94 views

Creating a Default Value for a Primary Key Cell in Marketing Cloud

Is there a way to create a data extension that has a primary key with a blank value, and when a new row is added, to autopopulate that primary key field with a unique number in a sequence? E.g. Rows ...
3
votes
2answers
2k views

Process builder not working properly when updating multiple records at the same time

I have a process builder that executes just fine when there's a single record update. But not updating all records when there are multiple updates at the same time. PB calls a flow, flow makes the ...
0
votes
1answer
146 views

Automated Report from Salesforce to Journey Builder

I am needing to automate a report in Salesforce to go to Journey Builder as a data extension but can't find a good way to do so. I need Journey Builder to receive the updated report daily and then ...
0
votes
2answers
275 views

Running Automations in 15minute intervals

I'm aware of the 2 methods of running the automation so that you can run it more frequently (less than 1 hour) Adding wait periods between SQL activities within 1 automation Cloning the automation ...

1
2 3 4 5
7