We are migrating from SFMC to marketo and have synced all the objects & fields from SFDC to marketo. We have a field "StartDateTime" (Data Type - DateTime) which is a constraint under a activity object which we need as a separate field and not as a constraint so that we can use it as an attribute under 'Remove from flow' as the value of the field "StartDateTime" keeps changing, so here we are trying to achieve it like if the "StartDateTime" of a prospect changes don't send the email. We tried creating another Marketo custom filed "StartDateTimeMeeting" with same date type which we can use in the 'Remove from flow' . But How can we sync the constraint "StartDateTime" value with Marketo only custom field "StartDateTimeMeeting"? Or any other workaround from which we can manage multiple "StartDateTime" changes and add or remove records from the Flow. ... View more

When we add a trigger "Opportunity is updated" having trigger attribute Type is 'Prospect', how does it works? Case 1: Will it fire the campaign whenever the trigger attribute is updated to 'Prospect'. Case 2: If the Type is 'Prospect' already and any other opportunity field is updated will the trigger qualify those records again?   Here I want to qualify records whose opportunity is updated to Type is 'Prospect' only and don't want the records having other opportunity fields updated. ... View more

Hey, I want to trim the Date, time and timezone from single Attribute of the Marketo. When I used static value it approves the email without error but when I am using Marketo Attribute for the same one it shows the correct value in Preview but shows error while approving the email. The value of the ${lead.appointmentStartDateTimeText} is 03/04/2020 01:30:00 PM MST I wan to fetch the Time 01:30:00 PM from the above value. =========== Below is the script: #set ($string = "${lead.appointmentStartDateTimeText}") #set ($s= $string.split(" ")) $s.get(1) ========== Below is the error: Validation Error approving Test_program_shweta.EFE_Test_Email — <div>An error occurred when procesing the email Rendered_Email_Velocity_Error_Area_?! </div> <p>Invocation of method 'get' in class [Ljava.lang.String; threw exception java.lang.ArrayIndexOutOfBoundsException near</p> <div><pre >?</pre></div>   ==== Would anyone be able to help me here? We would need to Approve the email in order to use it in smart campaign. Attached the screenshots of the script and errors.        ... View more

Hey, I want to Encode the Email address which is passes through URL to Non-Marketo Landing page.   I added below Email script in the my Tokens and used this token in the Email Template within the same program. #set ($string = ${lead.Lead_Owner_Email_Address}) #userlandBase64_v3("$string") While adding this My token in the Email is shows the correct preview with encoded value as per my expectation. But when I am trying to approve the Email it shows the below Validation Error Message: ---- Validation Error approving DF_Welcome_Email_For_Retail_Clients.062420_Client_Form_CRS — <div>An error occurred when procesing the email Rendered_Email_Velocity_Error_Area_?! </div> <p>Invocation of method 'subList' in class java.util.ArrayList threw exception java.lang.IndexOutOfBoundsException: toIndex = 3 near</p> <div><pre >?</pre></div> ----- If I replace the Attribute ${lead.Lead_Owner_Email_Address} with static Email address like abc@gmail.com, it approves the email without error.   Would anyone be able to help me here? We would need to Approve the email in order to use it in smart campaign. I added this script from this link: https://nation.marketo.com/t5/Product-Blogs/Base64-ing-a-String-in-Velocity-without-using-Reflection/ba-p/242251 Attached the screenshots of the script and errors.   ... View more