Dennis
6/11/2018 - 8:52 AM

FormSuite Data Dump

<!--%%[
  /* Data FS NAWTE ophalen*/
  SET @rows = LookupRows("FS NAWTE MO","userid",userid)
  IF RowCount(@rows) > 0 THEN
    SET @row = Row(@rows,1)
    SET @SubscriberKey = Field(@row,"SubscriberKey")
    SET @EmailAddress = Field(@row,"EmailAddress")
    SET @userid = Field(@row,"userid")
    SET @initial = Field(@row,"initial")
    SET @firstname = Field(@row,"firstname")
    SET @prefix = Field(@row,"prefix")
    SET @lastname = Field(@row,"lastname")
    SET @zipcode = Field(@row,"zipcode")
    SET @housenumber = Field(@row,"housenumber")
    SET @housenumber_suffix = Field(@row,"housenumber_suffix")
    SET @createdon = Field(@row,"createdon")
    SET @phonenumber = Field(@row,"phonenumber")
    SET @mobilenumber = Field(@row,"mobilenumber")
    SET @gender = Field(@row,"gender")
    SET @street = Field(@row,"street")
    SET @city = Field(@row,"city")
    SET @country = Field(@row,"country")
    SET @birthdate = Field(@row,"birthdate")
    SET @nboptin = Field(@row,"nboptin")
    SET @province = Field(@row,"province")
    SET @company = Field(@row,"company")
  ENDIF


SET @fs_header_image = HTTPGet(Concat("https://formulier.oranjefonds.nl/gminterfaces/import_emailcontent.php?url=", slug, "&field=thanks_mcemail_image"))

  SET @fs_content = HTTPGet(Concat("https://formulier.oranjefonds.nl/gminterfaces/import_emailcontent.php?url=", slug, "&field=thanks_mcemail_content"))
]%%-->


<h2 style="color:#3C3C3B;font-family:trebuchet ms,sans-serif;font-size:24px;font-style:normal;font-weight:bold;line-height:1.15;">
DATA DUMP:</h2>
<span style="color:#3C3C3B;font-size:12px;">
  <b>DE: FS Aanmelden MO<br></b>
SubscriberKey: <b>%%SubscriberKey%%</b><br>
EmailAddress: <b>%%EmailAddress%%</b><br>
childid: <b>%%childid%%</b><br>
userid: <b>%%userid%%</b><br>
formcode: <b>%%formcode%%</b><br>
istest: <b>%%istest%%</b><br>
slug: <b>%%slug%%</b><br>
createdon: <b>%%createdon%%</b><br>
nboptin: <b>%%nboptin%%</b><br>


  </span>
<br>
<span style="color:#3C3C3B;font-size:12px;">
  <b>DE: FS NAWTE MO<br></b>
SubscriberKey: <b>%%=v(@SubscriberKey)=%%</b><br>
EmailAddress: <b>%%=v(@EmailAddress)=%%</b><br>
userid: <b>%%=v(@userid)=%%</b><br>
initial: <b>%%=v(@initial)=%%</b><br>
firstname: <b>%%=v(@firstname)=%%</b><br>
prefix: <b>%%=v(@prefix)=%%</b><br>
lastname: <b>%%=v(@lastname)=%%</b><br>
zipcode: <b>%%=v(@zipcode)=%%</b><br>
housenumber: <b>%%=v(@housenumber)=%%</b><br>
housenumber_suffix: <b>%%=v(@housenumber_suffix)=%%</b><br>
createdon: <b>%%=v(@createdon)=%%</b><br>
phonenumber: <b>%%=v(@phonenumber)=%%</b><br>
mobilenumber: <b>%%=v(@mobilenumber)=%%</b><br>
gender: <b>%%=v(@gender)=%%</b><br>
street: <b>%%=v(@street)=%%</b><br>
city: <b>%%=v(@city)=%%</b><br>
country: <b>%%=v(@country)=%%</b><br>
birthdate: <b>%%=v(@birthdate)=%%</b><br>
nboptin: <b>%%=v(@nboptin)=%%</b><br>
province: <b>%%=v(@province)=%%</b><br>
company: <b>%%=v(@company)=%%</b><br>
  </span>
<br>
<span style="color:#3C3C3B;font-size:12px;">
  <b>Formsuite content<br></b>
Image url: <b>%%=v(@fs_header_image)=%%</b><br>
Content: <br>
  <table cellpadding="0" cellspacing="0" width="100%" border="0" role="presentation">
  <tr>
    <td align="left" valign="top" style="border:1px solid #cccccc; padding:20px;">
      %%=v(@fs_content)=%%
    </td>
  </tr>
</table>
  </span>
  <br>
<span style="color:#3C3C3B;font-size:12px;"><b>Prefill test</b><br>
purl: <b>?id=%%SubscriberID%%&amp;email=%%emailaddr%%&amp;sid=%%_subscriberkey%%</b></span>