9
votes
How to trigger an automation from another automation
You can certainly check the start and status of an Automation using a SSJS Script Activity. If you don't see it in your list of Activity types, SFMC Support can enable it for you.
Here's an example ...
- 31.1k
9
votes
Workflow versus Process Builder. How to choose which to use?
Last I checked, Workflow performs significantly better on CPU Time. That on its own is a compelling argument to reverse your assumption. Instead ask yourself why you would use Process Builder when you ...
- 151k
7
votes
How to automate data import on full sandbox refresh
If you're willing to take the time, the SandboxPostCopy interface lets you write code that's called once upon refresh. You could write a bunch of code to populate records. If you're planning on moving ...
- 502k
7
votes
Accepted
can i run an automation only when a data extension have data or records?
There is a new Verification Activity in Automation Studio. You can set this to verify if there are no subscribers in DE then stop the automation. This will prevent the error.
New Verification ...
- 30.8k
7
votes
Workflow versus Process Builder. How to choose which to use?
I'll add:
When working with e-mail alerts, the setup UI knows which workflow rules use any given alert and will show you this in a very simple way. The setup UI has no idea which Process Builders use ...
- 11.1k
7
votes
Accepted
How to pre-populate fields when creating a new record?
In lightning: you can do that using Set Predefined Field Values for Quick Action Fields. Here you predefine values for the new record created in quick action attributes and thus they gets ...
- 36.4k
7
votes
Update Salesforce object with a Script Activity
You can't execute AMPscript directly from a Script Activity, since they're only for server-side JavaScript code. There are also no SSJS functions for updating SF objects.
You can, however, force ...
- 31.1k
6
votes
Accepted
Automation studio SFTP file drop trigger to Import Activity
So the way I solve file conflict scenarios if I have no control over the file naming patterns is:
Create 2 File Locations pointing to 2 seperate folders in
your FTP:
File Locations:
import/...
- 1,569
6
votes
Accepted
Automation Query Error in Marketing Cloud
The issue is with SMTPBounceReason. This field can return an excess of 4000 characters. To bypass this, remove leave the length field blank. This will force it to VARCHAR(MAX) (Over 4000 characters).
...
- 6,613
6
votes
Accepted
Create or update Automation with Marketing Cloud REST API new endpoint
I made some investigation and think that to create/update Automation using REST, it is needed to use .json payload in this format:
{
"id": "e906af34-4a19-42e9-9ce2-ac6413a77a09",
"legacyId": "...
- 193
6
votes
Accepted
SSJS Error retrieving the automation activities of an automation
The issue is that the column AutomationTasks is not a retrievable property in the Automation object.
From Describe call on the object:
<Properties>
<PartnerKey xsi:nil="...
- 30.8k
5
votes
Journey Builder: "Process all records" vs "New Records"
The location of this configuration has changed some in the last couple of years. It is still an option when using a Data Extension entry source connected to an Automation Studio automation.
After ...
- 903
5
votes
Accepted
Automation skipped
Usually what I do in these types of automations is include a second 'failsafe' script activity after the one used to initialize the next automation. I have found that depending on the activity in the ...
- 30.8k
5
votes
Accepted
Salesforce Flow Fast Field Update (before triggered) and same record updates assignment vs update element
Before Save Flows operate the same as before insert/update Apex triggers. They modify the record after standard validations but before the first save noted in Triggers and Order of Execution. Unlike ...
- 502k
5
votes
Accepted
Does Salesforce Pro Suite allows you to do apex?
The answer is probably "No, you can't create apex classes/triggers"
tl;dr: Salesforce continues to make a mess of their offerings. You may want to reach out to the Salesforce Sales Team to ...
- 64k
4
votes
Process builder not activating in production
That gack is mentioned in this post, in which we're told is related to this known issue. You're encouraged to contact Tier 3 support if you get this error. They have a fix. They don't say what causes ...
- 502k
4
votes
Accepted
Export Data Extension data to Email, not FTP?
Short Answer:
No
Explanation:
The two methods of exporting data from a data extension are :
If the file is less than 20 MB it can be downloaded to your pc.
Files larger than this will have to be ...
- 6,613
4
votes
Accepted
Using Automation Studio to Export a Data Extension
This is easily done with an Automation containing a Data Extract Activity. Go to Automation Studio and create a new automation. Add a new Data Extract Activity, choose a name, a file naming pattern ...
4
votes
How to suppress contacts from marketing cloud email sends if they already got an email
One possibility would be including an Exclusion Script in the email that filters out subscribers present in the sent data view with a date of the current day or in your second case the last 7 days.
...
4
votes
Workflow versus Process Builder. How to choose which to use?
Once a process in Process Builder has been activated, it cannot be modified, only cloned. Conversely, a workflow can mostly be modified while it is active. For orgs that might need to update their ...
- 4,336
4
votes
Workflow versus Process Builder. How to choose which to use?
I'm not sure I prefer one over the other, but one thing that keeps pulling me back to workflow rules is that I can easily see all the field updates and where they are used. Process builder hides the ...
- 25.2k
4
votes
Accepted
Inserting an iframe in a Visual Flow
iframes have been disabled in Salesforce since 2015 to prevent clickjack.
Please see resource here:
https://help.salesforce.com/articleView?id=IFRAME-or-Web-Tab-Content-Displays-Blank-Page-...
- 372
4
votes
Accepted
Restrict tab access via search
It's not enough to remove access to the tab, or, strictly speaking, field level security. You need to remove access to the object itself (turn off "Read Object", e.g. "Read Accounts"). Triggers are ...
- 502k
4
votes
Use measure in SQL
Technically you could use a measure in SQL if you wanted to. This would come with the stipulation that you would need to join data from your sendable data extension to the subscriberid/list related ...
- 350
4
votes
Automating File Move from Marketing Cloud SFTP Import to Export Folder
Salesforce Support are able to provision few custom Data Extracts having different functionalities, e.g. for deleting files. I seem to remember there is also an option of one specific type being able ...
- 22.2k
4
votes
Accepted
PGP Encryption Marketing Cloud File Transfer
You need to upload your PGP key under Key Management in Setup.
Select Asymmetric, fill out Name and External Key fields, and upload the file containing your public PGP key:
Find more information on ...
- 22.2k
4
votes
Accepted
How do you invoke an external service in a flow triggered by a new Contact Creation?
The reason you're seeing the message "You have uncommitted work pending. Please commit or rollback before calling out" is because Salesforce does not allow HTTP callouts during a record ...
- 186
4
votes
Accepted
Automate Lead Conversion in Salesforce
So, yes you can do this in Flow (or Process Builder) but you will need to invoke an Apex invocable class to do the actual lead conversion using the Database.convertLead method
The Salesforce ...
- 73.2k
4
votes
Is there an API Name for the field "User Password expires in" under Password Policies?
It's passwordExpiration under ProfilePasswordPolicy and only accessible through the Metadata API.
You see an example of what gets returned in the Metadata API taken from the documentation
<?xml ...
- 22.8k
4
votes
Accepted
Access Synchronized DE with SSJS
You can definitely access data from Synchronized Data Extensions using SSJS. Lookups and other functions work in SSJS just like they do in AMPscript. Here's an example of a lookup to the ...
- 14.5k
Only top scored, non community-wiki answers of a minimum length are eligible