VKailash

I checked that, and map filed is not accurate. Here is what I am seeing- WEBSITE which is above the "Unmapped Customer Fields" is a field that per the spreadsheet is mapped, but when i check in marketo the "CRM field map" section is EMPTY.     ... View more

Thanks Darshil.  I am aware of this option, but was more looking into how i can get a list of JUST the mapped fields. When I download the report from Marketo it give me more the 400+ fields, but necessary not all of them are mapped & to check which fields ae mapped, it becomes a manual exercise across - leads, accounts, users etc.    Thanks ... View more

Hi Phillip. I have created a case with support & below is their response.     " there isn't a way to change what field the integration is using to look for updates. Lastmodifieddate is only looking at changes made by a user whereas systemmodstamp is updates from users as well as automated workflows and background processes: https://help.salesforce.com/s/articleView?id=000336532&type=1 - Some Salesforce internal backend processes will also update 'SystemModstamp,' as 'SystemModstamp' is used internally to signal that a record, or related data, may have changed - and that internal processes may need to synchronize themselves to the new record data. Marketo is using the Systemmodstamp field because its the exact use case needed when it comes to keeping changes up to date." ... View more

#set($x = $date.calendar) ##$x ##$x.time<br /><br /> ##$Activity_Marketo__cList.size() ##$Activity_Marketo__cList <br /><br /> #set($isMeetingMatchFound = 0) #foreach($Meeting in $sorter.sort($Activity_Marketo__cList, "StartDateTime__c:desc")) ##$Meeting.StartDateTime__c <br /> ##Assign Variables #set($Appointment_Start = $date.toDate("MM/dd/yyyy hh:mm:ss a", $Meeting.Appointment_Start_DateTime_Text__c)) #set($Appointment_StartDateTime = $date.toDate('MMM dd, yyyy hh:mm aa', ${convert.parseDate(${Meeting.StartDateTime__c}, 'yyyy-MM-dd HH:mm:ss')})) ##StarDateTime: $Appointment_StartDateTime <br /><br /> #set($is_upcoming = $date.difference($x.time,$Appointment_StartDateTime).hours) #set($formattedDate = $date.toDate("hh:mm:ss", $x.time)) ##$is_upcoming <br /> ##set($splitData = $Meeting.Appointment_Start_DateTime_Text__c.split(" ")) #set($leadHeader = $display.list($Meeting.Appointment_Start_DateTime_Text__c.split(" "),"<br>")) ## +5 hours and -5 hours to increase the difference range due to daylight saving or any difference between time or TimeZone. #if($is_upcoming <= 77 && $is_upcoming >= 43 && !$Meeting.StartDateTime__c.isEmpty() && $Meeting.Meeting_Sub_Type__c == "Initial" && $display.alt($Meeting.Meeting_Status__c,"").isEmpty() && !$Meeting.Meeting_Origin__c.isEmpty() && $Meeting.Event_Type__c == "Prospect Meeting" && $Meeting.IsChild__c == 0) #set($dateFormatted = $date.format("EEEE, MMM. dd", $Appointment_Start)) #set($dateFormattedHours = $date.format("hh:mm a", $Appointment_Start)) ##Removing 0 from date less than 10 start #set($splitTime = $dateFormattedHours.split(":")) #set($intString = $splitTime[0]) #set($Integer = 0) #if($Integer.parseInt($splitTime[0]) < 10) #set($dateHours1 = $splitTime[0].split('')[2]) #else #set($dateHours1 = $splitTime[0]) #end #set($splitDate = $dateFormatted.split(" ")) #set($intString2 = $splitDate[2]) #if($Integer.parseInt($splitDate[2]) < 10) $splitDate[0] $splitDate[1] $splitDate[2].split('')[2] at $dateHours1:$splitTime[1]## #else $splitDate[0] $splitDate[1] $splitDate[2] at $dateHours1:$splitTime[1]## #end ##Removing 0 from date less than 10 end ##$dateFormatted at $dateFormattedHours ##$Meeting <br> ##$Meeting.Name ##$Appointment_Start<br /> ##Meeting SubType: $Meeting.Meeting_Sub_Type__c ##Differences: $is_upcoming <br /> #set($isMeetingMatchFound = 1) #break #end #end ## Logic below is to default to upcoming Meeting #if($isMeetingMatchFound == 0) #foreach($Meeting in $sorter.sort($Activity_Marketo__cList, "StartDateTime__c:asc")) ##Assign Variables #set($Appointment_Start = $date.toDate("MM/dd/yyyy hh:mm:ss a", $Meeting.Appointment_Start_DateTime_Text__c)) #set($Appointment_StartDateTime = $date.toDate('MMM dd, yyyy hh:mm aa', ${convert.parseDate(${Meeting.StartDateTime__c}, 'yyyy-MM-dd HH:mm:ss')})) ##StarDateTime: $Appointment_StartDateTime <br /><br /> #set($is_upcoming = $date.difference($x.time,$Appointment_StartDateTime).hours) #set($formattedDate = $date.toDate("hh:mm:ss", $x.time)) ##$is_upcoming <br /> #set($dateFormatted = $date.format("EEEE, MMM. dd", $Appointment_Start)) #set($dateFormattedHours = $date.format("hh:mm a", $Appointment_Start)) #if($is_upcoming > 0 && !$Meeting.StartDateTime__c.isEmpty() && $display.alt($Meeting.Meeting_Status__c,"").isEmpty() && !$Meeting.Meeting_Origin__c.isEmpty() && $Meeting.Event_Type__c == "Prospect Meeting" && $Meeting.IsChild__c == 0) ##Removing 0 from date less than 10 start #set($splitTime = $dateFormattedHours.split(":")) #set($intString = $splitTime[0]) #set($Integer = 0) #if($Integer.parseInt($splitTime[0]) < 10) #set($dateHours1 = $splitTime[0].split('')[2]) #else #set($dateHours1 = $splitTime[0]) #end #set($splitDate = $dateFormatted.split(" ")) #set($intString2 = $splitDate[2]) #if($Integer.parseInt($splitDate[2]) < 10) $splitDate[0] $splitDate[1] $splitDate[2].split('')[2] at $dateHours1:$splitTime[1]## #else $splitDate[0] $splitDate[1] $splitDate[2] at $dateHours1:$splitTime[1]## #end #break #end #end #end ... View more

. ... View more