Questions tagged [automation]
The automation tag has no usage guidance.
329
questions
-1
votes
0answers
13 views
How to create an account from a user input?
In this picture there is account name and account. How can I delete account and use the entry in the account name to create a new account. This flow creates a contact automatically from entries and ...
0
votes
1answer
27 views
How to both opportunity and contact in the same flow? [closed]
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
11 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
19 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
13 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
28 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
22 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
25 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
24 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
32 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
23 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
36 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
41 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
129 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
69 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
47 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
38 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
82 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
85 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
27 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
396 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
268 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
33 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
63 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
46 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
51 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
1k 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
55 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
0answers
9 views
How to update a field automatically on a looup field change before pressing save button?
I have a custom object 'Shop' which has a relation to another object named 'Shop Location'. Now what I want whenever user creates or updates a record for Shop object if the user changes the lookup ...
0
votes
2answers
130 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 ...
0
votes
0answers
22 views
How to adjust this PB so a picklist field updates every year on the same date?
We have a Current Grade field on our student Contact record. We would like it to update the Current Grade picklist value every year on July 1. I'm still new to Process Builder and formulas, and am not ...
1
vote
1answer
188 views
How do we set up Flow to automatically email a subset of contacts when an Opportunity changes stages?
We are trying to do something that seems pretty simple - when an opportunity changes stages we want to automatically send an email to a subset of related contacts. That subset is any related contact ...
0
votes
1answer
174 views
Deleted/updated contacts are re-added/re-updated with original value in Marketing Cloud
I encounter an issue with Marketing Cloud when I delete/update contacts, the contacts are always uploaded back to Marketing Cloud (or the original value updated back).
Currently our contacts are ...
1
vote
1answer
52 views
It is possible to automatically Create Chatter Polls
I am trying to figure out how I can automate the creation of a Chatter Poll on a Group Feed.
We would like the Poll to post when a custom Request Record is in a certain stage. I managed to use Flow ...
0
votes
1answer
27 views
Is it possible to automate deploying SEPA Toolkit to scratch orgs?
Our org is heavily dependent on Opportunity.
Our Opportunity trigger logic has dependencies on the SEPA Toolkit (listing Id a0N3000000B4bYzEAJ), so we need a way to install this package either before ...
0
votes
1answer
368 views
Pass more records from process builder to autolaunched flow
Is is possible to pass multiple records at once to a flow?
I am having a transaction which inserts more records at once. I want to do some processing using Process Builder + Flow (searching for ...
0
votes
1answer
39 views
Is there a way to create a Workflow Rule to send administrator an email only when a new opportunity is created by a Partner Community?
In our Org, we allow Partner Community members to create and own Opportunities. As the administrator, I would like to receive an email alert only when Partner Community members create an Opportunity, ...
0
votes
1answer
59 views
Create an Automation that imports data to a Data Extension depending on the file name on a sftp
I am trying to upload data into a Data Extension by uploading a CSV file to the sftp. An Automation should then compare the csv name with the Data Extension name and then upload it into that Data ...
0
votes
2answers
441 views
How do I autopopulate lookup fields on a custom object?
I have a new custom object, "Car," with lookup fields to the Order, Opportunity, and several other objects.
When an Order is created, I would like a Car record to be created with the Order lookup ...
0
votes
2answers
52 views
Duplicate data from a synchronized data extension- Can't see the Syn DE in Automation studio
i'm working in Automation Studio in order to duplicate the data of synchronized DE into a new sendable DE. The problem I have is that I see the synchronized DE in Contact Builder but I can't find it ...
0
votes
2answers
43 views
Automate looking up data based on subscriberkey and populating a data extension with extended info
Based on the subscribers website interaction, my guy handling our website can send me two types of data:
SubscriberKey
RoomOfPreference.
I can have him add this data to a pick-up data extension via ...
0
votes
2answers
107 views
Checking for a non ascii character in SQL Query activity
I have certain records in my DE, where the first name contains '�'. I wish to extract such records. Obviously a like wouldn't work. Is there a way to do this in SQL Query Activity.
0
votes
0answers
51 views
SFMC API add Script Activity and Data Extract Activity to Automation
I am creating an automation via API and understand you cannot create Script activities or Data Extract activities.
I have created the script and data extract separately using the API and have the ...
0
votes
1answer
11 views
Approval Process: Only Commit Users Selection on Approval
Here is the use case I am having trouble with:
A user needs to transfer a case to another office, office is a picklist. When the Picklist Value is updated, seek approval from a manager. If approved, ...
0
votes
0answers
18 views
Automation - file drop - doesn't run after the file is dropped
My automation is not running (file drop/file transfer/import activity).
I have used the new SF MC URL ...ftp.marketingcloudops.com (SFTP) and dropped the file in the import directory.
However, my ...
0
votes
1answer
41 views
Create an automation to update Test accounts Status from “Unsubscribed” to “Active” [closed]
I am sure this is a thing, but we have a group of "test" email accounts that our QA group regularly tests. Of course the unsubscribe is one of those things they test, and often we have to reset the ...
0
votes
2answers
499 views
PGP Encryption Marketing Cloud File Transfer
I'm attempting to setup a file transfer activity from the Marketing Cloud Safehouse to our FTP Export Folder, encrypted. However, to do this, I have to enable a 'Customer Public Key'. On the activity ...
0
votes
3answers
697 views
Automating File Move from Marketing Cloud SFTP Import to Export Folder
Attempting to automate moving a report from Marketing Cloud's Import Folder to the Export folder, or from the Reports folder to the Export folder, and encrypt it. However, I don't show that the file ...
0
votes
1answer
278 views
Process builder create task
I am trying to build an automated task using process builder when opportunity is on the specific stage. However, I have a problem with field picker. I want to assign this task to opportunity owner / ...
1
vote
0answers
68 views
External FTP File Transfer Activity Error in Automation Studio - Can't Change
I'm trying to gather the errored emails in a triggered send. My question is the same as this one: Triggered Send Errors - access subscribers for failed send?
However, when I attempt pull the errors, ...
