Updates from mondialt Toggle Comment Threads | Keyboard Shortcuts

  • mondialt 10:51 pm on August 3, 2017 Permalink | Reply  

    //Select Distinct Subscriber by signup date

    SELECT DISTINCT a.EmailAddress as email, b.signup_date
    FROM _Subscribers a
    JOIN (SELECT DISTINCT c.EmailAddress as email, MIN(c.DateJoined) as signup_date
    FROM _Subscribers c GROUP BY c.EmailAddress, c.DateJoined) AS b
    ON a.EmailAddress = b.email

     
  • mondialt 10:45 pm on August 2, 2017 Permalink | Reply  

    //Code to retrive object via Ampscript

    %%[
    var @Contact, @ContactRow, @Name, @Email, @Marketing, @Reminder
    Set @Contact = RetrieveSalesforceObjects(‘Contact’, ‘Name,Email,Marketing_Opt_Out__c’, ‘Email’, ‘=’, ‘paulgchua@gmail.com’)
    Set @ContactRow = ROW(@Contact,1)
    Set @Email = FIELD(@ContactRow,”Email”)
    Set @Name = FIELD(@ContactRow,”Name”)
    Set @Marketing = FIELD(@ContactRow,”Marketing_Opt_Out__c”)

    UpdateSingleSalesforceObject
    ]%%

    %%=v(@Name)=%%
    %%=v(@Email)=%%
    %%=v(@Marketing)=%%

    //Code to Update Salesforce Object via Ampscript

    %%[
    var @result
    set @result = UpdateSingleSalesforceObject(‘Contact’,’00336000010ODV2′,’Marketing_Opt_Out__c’,’true’)
    ]%%

    %%=v(@result)=%%

     
  • mondialt 7:55 pm on June 16, 2017 Permalink | Reply  

    Code Start 

    Hello World!

     
c
Compose new post
j
Next post/Next comment
k
Previous post/Previous comment
r
Reply
e
Edit
o
Show/Hide comments
t
Go to top
l
Go to login
h
Show/Hide help
shift + esc
Cancel